Shulou(Shulou.com)06/01 Report--

I. brief introduction of mariadb and mysql

1. Introduction to mariadb

MariaDB was developed by Michael Widenius (English: Michael Widenius), the founder of MySQL, who earlier sold his company, MySQL AB, to SUN for $1 billion. Since then, with the acquisition of SUN by Oracle, the ownership of MySQL has also fallen into Oracle's hands. The name MariaDB comes from the name of Michael Widenius's daughter Maria.

2. The cause of mariadb.

MariaDB database management system is a branch of MySQL, which is mainly maintained by the open source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of shutting down MySQL, so the community uses a branching approach to avoid this risk. The goal of MariaDB is to be fully compatible with MySQL, including API and the command line, making it an easy replacement for MySQL. In terms of storage engine, XtraDB (English: XtraDB) is used instead of MySQL's InnoDB.

3. Advantages of mariadb

Free for commercial use (after being acquired by oracle, MySQL can be divided into community version and enterprise version) Maria storage engine PBXT storage engine XtraDB storage engine FederatedX storage engine faster replication query processing thread pool fewer warnings and bug faster more Extensions better functional test data tables to eliminate the expansion statistics of slow query logs support the sorting of Unicode

4. Have started to use mariadb

Google,twitter,facebook, a big company, has also, or begun to shift from mysql to mariadb.

A new version of redhat,archlinux,opensuse,slackware,fedora has been or has been announced to replace mysql with mariadb as the default database.

Individuals have always regarded google as the weather vane of technology, and google transferred to mariadb soon after oracle acquired mysql, which shows that the future of mysql is 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. Delete mysql

I have tested that mysql5.1,mysql5.5 can be smoothly transferred to mariadb,mysql5.6.X and has not been tested. If you don't rest assured, you can backup it with mysqldump first. Mariadb cannot be installed without deleting mysql.

# yum remove mysql mysql-server

3. Install mariadb

# yum install MariaDB-server MariaDB-client # yum install MariaDB-Galera-server MariaDB-client galera / / with synchronous multi-master cluster feature

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 207Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026 Copyright (c) 2000, 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 | | CSV | YES | CSV storage engine | NO | NO | | BLACKHOLE | YES | / dev/null storage engine (anything you write to) It disappears) | NO | | MyISAM | YES | MyISAM storage engine | NO | | FEDERATED | YES | FederatedX pluggable storage engine | YES | NO | YES | | ARCHIVE | YES | Archive storage engine | NO | NO | InnoDB | DEFAULT | Percona-XtraDB Supports transactions, row-level locking, and foreign keys | YES | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | | MEMORY | YES | Hash based, stored in memory Useful for temporary tables | NO | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | +-- -+ 10 rows in set (0.03 sec)

Summary

The above is the whole content of this article, I hope that the content of this article has a certain reference and learning value for your study or work, if you have any questions, you can leave a message and exchange, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.