Posted by: cmani2010 | July 9, 2009

What I learned about MySQL in class !!

I and my team, were fortunate enough to get sponsored to attend a 5 day MySQL for DBA’s training in Bangalore recently. Even though, I am not a DBA, nor do I intend to become one, but there is upswell of interest for MySQL in India, every customer and partner seems to want to know more about it and there is ever growing linkage between other Sun Middleware products and MySQL.

Lets take the following products and how MySQL fits in:

There you have it, there is a fitment with MySQL with almost all of our middle ware products !!

The following are some key things (in my personal opinion) which makes MySQL stand out, from other commercial or open source databases:

  1. Everything and any server configuration settings can be changed/viewed using the my.ini (on Windows) or my.cnf (on Solaris and Linux) files. It is extremely simple. Just add it, under the appropriate headers and it will be picked up by MySQL when in starts. Plus, there are some sample, configuration files, which show sample settings for large or medium kind of databases.
  2. The concept of Storage engines, and switching storage engines, having different storage engines in a single database, blows you away !!! Moving databases, renaming databases is a snap, as simple as renaming files (for Innodb) or changing directory names (for ISAM). Knowledge of different Storage engines can be a little intimidating at first, but for now, there are a few parameters like – what kind of applications will be using it? do you need transactions/ACID compliance? etc etc. Google “compare MYSQL storage engines”
  3. Setting up a MySQL replication with a Master/Slave, is a breeze, and can be done in less than 10 mins for a simple setup. You will find good information in the MySQL documentation.
  4. Every configuration variable setting, can be found using “MySQL>show variables like ‘%keyword%’;”

  5. Doing a backup and restore of MySQL data is so simple using mysqldump.
  6. Tuning of MySQL databases seemed to be straightforward, will write up more stuff, as I experiment more. But generally, there are plenty of aids, which explain where time is being spent on queries, and how we can improve them
  7. Creating Triggers, Stored procedures are simple, and like other databases.

This is it for, more later …


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: