I just completed my week long training “MySQL for Database Administrators” at Sun Microsystems, Santa Clara. Now, I am back at work.
It’s almost amazing how much this training can transform you. It’s one thing to build applications using MySQL, but a totally different perspective is required to administer a MySQL database. Yes, your development team is almost going to hate you for this.
Anyway, this course is about how MySQL works, the ultimate truth. And how you can turn that to your advantage. Some very interesting topics covered are NDB Cluster and Blackhole storage engines and database and server optimization. You also get to try out hands-on replication, backup and recovery techniques and such.
For this training, they also offered their new hands-on MySQL DBA 5.1 certification at the end of the course.
Yes, I passed.
Monday, September 21, 2009
Tuesday, September 15, 2009
Integrity Vs Performance
Its not an easy decision. If you love your data as much, you probably have nightmares all the time about your server crashing. And so, you have daily backups setup, and even binary logging on a separate physical device, may be even clusters, and yet you remain paranoid.
On the other hand, you have your application team constantly complaining about how your databases are sooooo slow. Yes, they don't have any idea how much work it took to organize the data the way it is, choosing the right storage engines, optimizing the tables ever so frequently, and tuning the several hundred server variables just to get to this point.
The fact remains, you can't have a perfect system. You have to compromise, depending on your use case.
It's all about the balance...
On the other hand, you have your application team constantly complaining about how your databases are sooooo slow. Yes, they don't have any idea how much work it took to organize the data the way it is, choosing the right storage engines, optimizing the tables ever so frequently, and tuning the several hundred server variables just to get to this point.
The fact remains, you can't have a perfect system. You have to compromise, depending on your use case.
It's all about the balance...
Tuesday, September 1, 2009
Gmail Outage
So, Gmail is down. Service outage.
Complaints and frustrations are pouring in, even when some have been experiencing the downtime only for a few minutes now. Innumerable tweets about the outage have made Gmail one of the Trending Topics on Twitter. Tech crunch posts a related article about 7 minutes ago, and there are 115 comments already.
I just want to say, Google rocks!
P.S. Yes, they are continually assuring us that they are looking into the problem. They have also put up videos with step by step instructions on how to access you email via IMAP or POP.
Check status at: http://www.google.com/appsstatus#rm=1&di=1&hl=en
Complaints and frustrations are pouring in, even when some have been experiencing the downtime only for a few minutes now. Innumerable tweets about the outage have made Gmail one of the Trending Topics on Twitter. Tech crunch posts a related article about 7 minutes ago, and there are 115 comments already.
I just want to say, Google rocks!
P.S. Yes, they are continually assuring us that they are looking into the problem. They have also put up videos with step by step instructions on how to access you email via IMAP or POP.
Check status at: http://www.google.com/appsstatus#rm=1&di=1&hl=en
Subscribe to:
Posts (Atom)
