MySQL MARIADB Database Smoothing Transition Example

One, mariadb and MySQL

1,MARIADB Introduction

MARIADB, led by MySQL founder Michael Widenius (English: Michael Widenius), had previously sold his company, MySQL AB, to Sun at a price of 1 billion dollars, and since then, as Sun was acquired by Oracle, MySQL's ownership also falls into Oracle's hands. The name of MARIADB is from the name of Michael Widenius's daughter Maria.

The cause of 2,MARIADB

MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, with the GPL license. One of the reasons for developing this branch is that Oracle has a potential risk of MySQL closed source after acquiring MySQL, so the community uses a branching approach to avoid the risk. MARIADB is designed to be completely compatible with MySQL, including APIs and command lines, making it easy to become a replacement for MySQL. On the storage engine side, use XTRADB (English: xtradb) to replace the MySQL InnoDB.

Advantages of 3,MARIADB

Free commercial use (after Oracle acquisitions, MySQL has a community and Enterprise version of the Division)

Maria Storage Engine
PBXT Storage Engine
XTRADB Storage Engine
Federatedx Storage Engine
Faster replication Query Processing
Thread pool
Fewer warnings and bugs
Run faster
More Extensions.
Better Functional Testing
Data table elimination
Extended statistics for slow query logs
Support Sorting for Unicode

4, already started using MARIADB

Google,twitter,facebook this big company has also, or started to turn from MySQL to mariadb
The new version of Redhat,archlinux,opensuse,slackware,fedora has been, or has been announced, mariadb instead of MySQL as the default database.
Individuals have been Google as a technology vane, Google in Oracle acquisition of MySQL not long before the transfer to mariadb under the door, the future of the MySQL can be seen bleak.

Second, install MARIADB

1,MARIADB Source

[Root@node1 tank]# Cat/etc/yum.repos.d/mariadb.repo//32-bit system
[MARIADB]
Name=mariadb
Baseurl=http://yum.mariadb.org/5.5/centos6-x86
Gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadb
Gpgcheck=1

[Root@node1 tank]# Cat/etc/yum.repos.d/mariadb.repo//64-bit system
[MARIADB]
Name=mariadb
Baseurl=http://yum.mariadb.org/5.5/centos6-amd64
Gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadb
Gpgcheck=1

2, remove MySQL

I have tested that mysql5.1,mysql5.5 can be smoothly transferred to mariadb,mysql5.6.x and not tested. Do not be assured that you can use mysqldump for backup. Do not delete MySQL can not be loaded mariadb
# yum Remove MySQL Mysql-server
3, install MARIADB
View copy print?
# yum Install Mariadb-server mariadb-client

# yum Install mariadb-galera-server mariadb-client galera//Synchronous multi-host cluster characteristics

Third, start and test mariadb

1, start mariadb

#/etc/init.d/mysql Start
2, Test mariadb

[Root@node1 ~]# MySQL
Welcome to the MARIADB Monitor. Commands End With; Or\g.
Your mariadb Connection ID is 207
Server Version:5.5.40-mariadb-wsrep mariadb Server, wsrep_25.11.r4026

Copyright (c), 2014, Oracle, Monty program Ab and others.

Type ' help, ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

MARIADB [(none)]> show engines;
+--------------------+---------+----------------------------------------------------------------------------+-- ------------+------+------------+
| Engine | Support | Comment | Transactions | XA | savepoints |
+--------------------+---------+----------------------------------------------------------------------------+-- ------------+------+------------+
| Mrg_myisam | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV Storage Engine | NO | NO | NO |
| Blackhole | YES | /dev/null Storage Engine (anything you write to it disappears) | NO | NO | NO |
| MyISAM | YES | MyISAM Storage Engine | NO | NO | NO |
| Federated | YES | Federatedx Pluggable Storage Engine | YES | NO | YES |
| ARCHIVE | YES | Archive Storage Engine | NO | NO | NO |
| InnoDB | DEFAULT | PERCONA-XTRADB, Supports transactions, Row-level locking, and foreign keys | YES | YES | YES |
| Performance_schema | YES | Performance Schema | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| Aria | YES | Crash-safe tables with MyISAM Heritage | NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------------------+-- ------------+------+------------+
Rows in Set (0.03 sec)