Migrate MySQL database to MariaDB on Ubuntu 15.10
MariaDB is the best alternative to MySQL databases. Since Oracle's acquisition of SUN, the open-source community believes that Oracle has never been very popular with MySQL. It is true that MySQL, as an open-source database, has a competitive relationship with Oracle's main business, after the acquisition, its fate will be very subtle, so there is a MariaDB project. MariaDB has developed quite well and has surpassed MySQL to become a new pillar of open source databases.
Okay. Let's take a look at how to transfer it! Note that there is a transfer risk, so please back up the data in advance!
This article applies to Ubuntu 15.10 users. For other Linux versions, visit the official website.
First, enter the following command to add the database and key:
Sudo apt-get install software-properties-common
Sudo apt-key adv -- recv-keys -- keyserver hkp: // keyserver.ubuntu.com: 80 0xcbcb082a1bb943db
Sudo add-apt-repository 'deb [arch = amd64, i386] http://mirrors.hustunique.com/mariadb/repo/10.1/ubuntu wily main'
Update the library and run the following command:
Sudo apt-get update
Sudo apt-get install mariadb-server
Linux Tutorial: How to check the MariaDB server version
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
How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu
Install MariaDB on the Ubuntu 14.04 (Trusty) Server