Recently, my hosting company Funio has replaced MySQL for MariaDB on their shared hosting infrastructure. Some friends working there told me they get better performance with MariaDB than their previous MySQL installation.
MariaDB is a drop-in replacement of MySQL. This WordPress blog was first installed with MySQL, and suddenly and automagically runs on MariaDB. As a DBA, I was excited to use all the new features… but I realized that I’m pretty limited on Funio’s database infrastructure since I’m just a simple user…! So, just for fun, I changed the engine of all my tables to ARIA. It’s the least I can do.
ALTER TABLE wordpress_tablename ENGINE = ARIA;
ARIA is a crash-safe alternative to MyISAM and according to plans, it will become Transactional in the next major release. I don’t expect it to be as fast, reliable and robust than InnoDB (or XtraDB.. the altered version of InnoDB developed by Percona and included in MariaDB), but it’s definitely a good “hybrid” solution between MyISAM et InnoDB.
I didn’t experience issue since the changes, so if you are a WordPress user, don’t be afraid to give it a try !