Oct 22
Posted by Sean Hull in mysql, open-source, oracle, review | 1 Comment
Just finished up O’Reilly’s Backup & Recovery by W. Curtis Preston. The title is wide-reaching, covering backups at the operating system as well as on all the popular database platforms, including Oracle, MySQL, Postgres, Sybase, SQL Server and DB2. Preston has an amazing grasp of a spectrum of technologies and platforms, and as an Oracle & MySQL DBA myself, I’d use this as my backup reference text any day.
I’ve posted my review of Backup and Recovery over at Amazon.
Was scanning through the facebook team’s engineering blog recently. Although it’s not updated very frequently, there’s some good technical discussion of the engineering behind Facebook, and what it takes to make the site work.
In particular I found this discussion Scaling Out by Jason Sobel. He talks about the cache coherency challenges they had, and how they used MySQL & memcache to get the job done.
As many of you may have already heard, Sun officially announced their purchase of MySQL today. After the last few years with Oracle pushing Linux and commodity hardware, Sun has certainly taken the hit. I guess this is their turn to hit back.
With MySQL 6.0 out, increasingly we find the full compliment of sophisticated database features in MySQL. But a lot of the devil is in the details. Where Oracle has had problems with the sheer size of the codebase, and addressing security vulnerabilities, and other bugs in a timely manner, MySQL has the problem of a mature codebase. Some of these features are newly available, and if my experiences with replication are any indication, often have hidden gotchas and “features” which are not emphasized in the literature.
The next question on my mind is, how does Oracle’s purchase and now ownership of Innobase impact the above purchase. It means a direct competitor owns a core component which provides transactional support to your database. A very good question.
Time will tell, so stay tuned.
Dec 11
Posted by Sean Hull in backup, migration, mysql, oracle | No Comments
The folks over at zmanda who specialize in MySQL backup are doing a webinar on December 13th, this Thursday. They specifically mention it as relevant for Oracle DBAs or anyone moving to MySQL. Looks to be an interesting event.
Incredible, but true. It seems that MySQL AB will be exhibiting next week at Oracle Open World. This of course isn’t the first time a competitor would advertise or exhibit on it’s rival’s home turf. Still it certainly signals a changing landscape, and heats up the battle for market share.
Here’s a longer list of exhibitors at the conference. I don’t see Enterprise DB there, but anything’s possible. You will see RedHat as well as Suse, now owned by Novell, represented there as well. Also if you make it to the conference, be sure to visit the Oracle pavilion section, where there are sure to be smaller booths for the Open Source Group, as well as Oracle Unbreakable Linux Support program.
Oct 31
Posted by Sean Hull in abstract, mysql, oreilly | No Comments
The fifth and last abstract submitted for the O’Reilly MySQL Conference in April 2008.
As an independent consultant, there are quite a few trouble spots I see repeatedly. I’ll discuss five of them, and how to avoid them in your own infrastructure.
As an independent consultant for twelve years, I’ve encountered a lot of interesting and challenging projects. I’ll discuss five different cases, and what lessons I took away from each.
1. Intro
2. The Right Hardware
3. Importance of Good Testing
4. Patchwork or Good Design
5. Don’t Mix Opposites
6. Use The Technology
7. Conclusion
The fourth in a series of five abstracts for the O’Reilly MySQL Conference in April 2008.
Learn how to audit your systems, and run through the right checklists so you can sleep better at night knowing your systems are more secure.
Security is on everyone’s radar these days. You may be wondering yourself whether your database systems are really as secure as they should be. We’ll discuss some of the latest vulnerabilities, and what you can do to protect your systems.
1. Introduction
2. Authentication
3. SQL Injection
4. OS Security
5. Network Security
6. Conclusions
Oct 31
Posted by Sean Hull in abstract, mysql, oreilly | No Comments
This is the third in a series of five abstracts submitted to the O’Reilly MySQL Conference in April 2008.
MySQL has a great facility for creating a read-only failover database. We’ll show you how to setup, start, failover, and monitor it.
Setting up MySQL to have a master + slave failover capability might be intimidating, but it needn’t be.
1. Intro
2. Anatomy of MySQL Replication
3. Initial Master copy
4. Setup + starting the slave
5. Failover from Master
6. Adding another slave
7. Monitoring your slave db
8. Conclusions
The second in a series of five abstracts for the O’Reilly MySQL Conference in April 2008.
Inevitably hackers are trying to get at your data, so you mine as well know what they can and can’t do. What better way to discover where you’re vulnerable than hacking your own systems.
Operating Systems have bugs, Database Software has bugs, and so does your application, probably. A better question is how hackable are you? We’ll look at some of the nefarious ways intruders can get in, so you’ll better know how secure your systems really are.
1. Intro
2. OS level
3. Database level
4. Application level
5. Conclusions
Oct 30
Posted by Sean Hull in abstract, mysql, oreilly | No Comments
I’ve just put together my abstracts for O’Reilly’s MySQL Conference in April 2008. Some of them might sound familiar…
Learn to watch your database like a fitness diet. Trim down the SQL queries, use the right hardware, and monitor the right metrics to keep it running fast.
There are healthy databases and their are unhealthy ones. We’ll take a look at what you feed your database, and how to keep it fit with just the right diet of hardware, configuration, and SQL query tuning.
1. Introduction – Diet of a Champion Database
2. Disk, Memory, CPU – Body by Intel
3. Applications – Lean & Fit
4. SQL Queries – High Fiber, Low Fat
5. Conclusions
You are currently browsing the archives for the mysql category.
Arclite theme by digitalnature | powered by WordPress