I’m in the process of taking on some of the MySQL databases in my company. The first ones are MySQL 4.1 running on Windows, so we are upgrading them to MySQL 5.6 on Oracle Linux. As with many of our systems, these will be running on VMware virtual machines.
Since the current installations are so old, we are planning on dumping out the data and creating fresh installations on the new systems. Based on the advice I got from Ronald Bradford and Sheeri Cabral, we are also taking this opportunity to switch to InnoDB and utf8, rather than MyISAM and latin1 that are currently used.
We are using the MySQL yum repository for the installation, so we can be on the latest MySQL version, rather than that shipped as part of Oracle Linux (or RHEL) 6.5. The other neat thing about this is it takes care of point release upgrades as part of the “yum update” process.
So far all my testing has been done on VMs running on my PC, but we are soon going to start rolling this out. It should be an interesting piece of work. The developers are doing a bunch of testing with InnoDB and utf8 to see what issues we come up against…
Cheers
Tim…
Update. For those new to MySQL, you might like to read this post by Patrick Hurley.
Oracle Linux and MySQL | The ORACLE-BASE Blog http://t.co/zDuvIVMTcX
RT @oraclebase: Oracle Linux and MySQL | The ORACLE-BASE Blog http://t.co/zDuvIVMTcX
RT @oraclebase: Oracle Linux and MySQL | The ORACLE-BASE Blog http://t.co/zDuvIVMTcX
For any Oracle DBAs inspired by Tim’s blog to have a look at MySQL, I created this introduction, based on my own experiences getting to know MySQL http://patrickhurley.wordpress.com/mysql-for-oracle-dba/
@Patrick : Thanks for the link. I’ve updated the post with a link to your post. 🙂
Cheers
Tim…
Now to start sharding & get a job at twitter =]