How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu

How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu

This article has been tested by ourselves. The system is Ubuntu 14.04 server, and the Mysql database is Mysql 5.5. We are preparing to migrate it to Maria DB 10.1, for details about the migration methods of other versions, go to the official website. Here I will only talk about what I have tested.

As to why Oracle migrated to MariaDB, users who know Oralce's acquisition of Sun should know that, of course, this has been a thing a few years ago. I have never liked Oracle's attitude on MySQL, mariaDB is basically used for database installation. The entire migration process is basically painless and requires no special settings. The compatibility is very good.

First, select a proper source from the MariaDB official website, and put the address to the bottom of the/etc/apt/sources. list file:

# MariaDB 10.1 repository list - created 2014-11-17 01:55 UTC
# http://mariadb.org/mariadb/repositories/
deb http://mirrors.neusoft.edu.cn/mariadb/repo/10.1/ubuntu trusty main
deb-src http://mirrors.neusoft.edu.cn/mariadb/repo/10.1/ubuntu trusty main

Save and enter the following commands:

sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo apt-get update
sudo apt-get install mariadb-server

The installation command will automatically uninstall the Mysql database! During the installation process, you are required to reset the password and follow the prompts to perform the operation. phpmyadmin is also supported by default!

Install LAMP (Apache with MariaDB and PHP) in CentOS/RHEL/Scientific Linux 6)

Implementation of MariaDB Proxy read/write splitting

How to compile and install the MariaDB database in Linux

Install MariaDB database using yum in CentOS

Install MariaDB and MySQL

MariaDB details: click here
MariaDB's: click here