Migrate the MySQL database to MariaDB on Ubuntu15.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, no nonsense.

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 MariaDB server version http://www.linuxidc.com/Linux/2015-08/122382.htm

Implementation http://www.linuxidc.com/Linux/2014-05/101306.htm of MariaDB Proxy read/write splitting

Method http://www.linuxidc.com/Linux/2014-11/109049.htm for compiling and installing MariaDB database in Linux

CentOS system install MariaDB database http://www.linuxidc.com/Linux/2014-11/109048.htm with yum

Install MariaDB and MySQL co-exist http://www.linuxidc.com/Linux/2014-11/109047.htm

How to migrate MySQL 5.5 database to MariaDB 10 http://www.linuxidc.com/Linux/2014-11/109471.htm on Ubuntu

Install MariaDB on the Ubuntu 14.04 (Trusty) ServerHttp://www.linuxidc.com/Linux/2014-12/110048htm

MariaDB details: Click here
MariaDB's: Click here

This article permanently updates the link address: Http://www.linuxidc.com/Linux/2015-12/1259.htm