Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
share|improve this question
2  
Your English is great! :-) –  Josh Jan 15 '11 at 16:36
    
Could you please start accepting some answers? –  chrisjlee Jan 31 '12 at 16:24
add comment

4 Answers

up vote 1 down vote accepted

According to the MariaDB website, you do not need to dump anything. Just install the new binaries and reuse existing data directory. See:

http://kb.askmonty.org/v/how-can-i-upgrade-from-mysql-to-mariadb

I would still advise to do a backup though. To be paranoid:

  1. tar cvfz /etc.tar.gz /etc
  2. tar cvfz /var/lib/mysql.backup.tar.gz /var/lib/mysql # while mysql is stopped, as Kevin mentioned
  3. mysqldump --all-databases
share|improve this answer
add comment

I've never heard of MariaDB, but if MySQL is good enough for Facebook, it should be good enough for you.

Check out memcached to see how you can optimise your existing MySQL setup for better performance: http://www.mysql.com/why-mysql/memcached/

share|improve this answer
1  
-1 Different tools for different requirements... –  squillman May 9 '11 at 17:00
    
I didn't vote you down (enough people have done that) but the question was clearly asking about MariaDB and you stated immediately that you'd never heard of it. If thats the case, you probably shouldn't have responded. –  Christian Aug 18 '13 at 11:55
add comment

You could make a backup of /var/lib/mysql after shutting MySQL down; the data files are stored there.

share|improve this answer
add comment

mariadb is definitely better performing mysql version for both myisam and innodb performance. Especially mariadb 5.2.x see http://vbtechsupport.com/606/

to upgrade on centos at least, i basically

  1. backup mysql databases via mysqldump
  2. yum remove mysql
  3. rpm -i mariadb 5.2.x rpms
  4. run mysql_upgrade to check compatibility
  5. if issues, restore mysqldump sql dump then rerun mysqlcheck --check-upgrade
  6. then recompile php making sure --with-mysql=/path/to/mysql and --with-mysqli=/path/to/mysql_config are included to use mariadb 5.2.x client libraries.
share|improve this answer
1  
Giving RPM commands to Debian user is a bit useless. And it is better to use standard distribution packages whenever possible rather then manually compiling packages which won't automatically or easily upgrade when there are security/bug fixes later. –  Wim Kerkhoff Jun 18 '11 at 21:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.