I've heard that MariaDB has better performance than MySQL-Server. I'm running software that makes an intensive use of MySQL, thats why I want to try upgrading to MariaDB.
Please tell me your experiences doing this conversion, and instructions or tips.
Also, which files I should take care of for making a backup of MySQL-Server, so if something goes wrong with MariaDB, I could rollback to MySQL without issues? I would use this but I'm not sure if it's enough to get a full backup of MySQL-Server confs and databases:
- mysqldump --all-databases
- backup /etc/mysql
uname -a (Debian Lenny) Linux charizard 2.6.26-2-amd64 #1 SMP Thu Sep 16 15:56:38 UTC 2010 x86_64 GNU/Linux
MySQL Server Version:
Server version 5.0.51a-24+lenny4
MySQL Client: 5.0.51a
Threads: 25 Questions: 14690861 Slow queries: 9 Opens: 21428 Flush tables: 1 Open tables: 128 Queries per second avg: 162.666 Uptime: 1 day 1 hour 5 min 13 sec