Upgrading from MySQL Server to MariaDB

Posted by Korrupzion on Server Fault See other posts from Server Fault or by Korrupzion
Published on 2011-01-15T01:07:19Z Indexed on 2011/01/15 1:55 UTC
Read the original article Hit count: 274

Filed under:
|
|
|
|

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

© Server Fault or respective owner

Related posts about linux

Related posts about mysql