Migrate from MySQL to MariaDB in Linux

So I decided to migrate all my servers from MySQL to MariaDB.

It is easy for Arch users to follow the official news:

 
 

  
  
systemctl stop mysqld 
  
  
pacman -S mariadb libmariadbclient mariadb-clients 
  
  
systemctl start mysqld 
  
  
mysql_upgrade -p 
 
 

OpenSUSE is even dumb. After all, it is the default: zypper in mariadb is enough.

Debian/Ubuntu users are a little more complicated, but the entire process is still smooth:

First, select an appropriate source from MariaDB's official Repository Configuration Tool, and put the address to the bottom of the/etc/apt/sources. list file:

 
 

  
  
# MariaDB 5.5 repository list - created 2013-03-26 14:20 UTC 
  
  
# http://mariadb.org/mariadb/repositories/ 
  
  
deb http://mirror2.hs-esslingen.de/mariadb/repo/5.5/debian squeeze main 
  
  
deb-src http://mirror2.hs-esslingen.de/mariadb/repo/5.5/debian squeeze main 
 
 

Run the following command:

 
 

  
  
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db 
  
  
apt-get update 
  
  
apt-get install mariadb-server mariadb-client 
 
 

MySQL or Percona) is automatically uninstalled and replaced with MariaDB. In some specific environments, you may need to execute these commands:

 
 

  
  
apt-get autoremove 
  
  
apt-get upgrade # or apt-get dist-upgrade 
  
  
mysql_upgrade -p 
 
 

Then we can get it done! Do whatever you want

Edit recommendations]

1. MariaDB 5.3 will support the alter table progress prompt
2. The founder of MySQL builds MariaDB fully compatible with MySQL 5.1.
3. MariaDB 2 anniversary
4. How to optimize your MongoDB in five steps
5. Development History of NoSQL in Enterprises