This article was self-tested. The system is Ubuntu14.04server, And the Mysql database is Mysql5.5. You are about to migrate it to MariaDB10.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 in My
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 the LAMP (Apache with MariaDB and PHP) http://www.linuxidc.com/Linux/2013-07/86755.htm in CentOS/RHEL/Scientific Linux 6
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
MariaDB details: Click here
MariaDB's: Click here
For more information about Ubuntu, see Ubuntu special page http://www.linuxidc.com/topicnews.aspx? Tid = 2
This article permanently updates the link address: Http://www.linuxidc.com/Linux/2014-11/109471.htm