Turns out I’ve been living under a rock. I found out a few days ago that there are several drop-in replacements to Oracle MySQL that provide additional features and better performance. After doing some research, I chose to try out MariaDB.
Although MariaDB is a drop-in replacement for MySQL, they don’t really go out of their way to make it easy to switch. It took a fair amount of searching and some trial and error, but eventually I figured it out. Here is what I did for CentOS 5 and CentOS 6:
All said and done the entire process took less than 5 minutes and resulted in downtime of about 1 minute.
I’ve read that MariaDB takes more memory than MySQL, but my experience has been the opposite. I have drastically more free memory than before the switch (we’re talking gigabytes of extra free RAM). No idea what was going on with MySQL that it was eating all this RAM that MariaDB doesn’t seem to need. I ran a few informal benchmarks and things seem to be slightly faster. Not enough by itself to justify the effort of switching, but a nice perk.