Upgrading from MySQL Server to MariaDB
- by Korrupzion
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
My Environment:
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
Statistics:
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
Thanks!
PS: Rate my english :D