MySQL MARIADB Database Smoothing Transition Example

Source: Internet
Author: User
Tags gpg

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.