MARIADB binary installation and basic management

This article aims to review mariadb binary installation and basic management

Basic knowledge

1, mariadb is MySQL original author, open source community maintenance, features compared to MySQL at least flat;

2, using the new engine xtradb to replace the MySQL InnoDB, earlier version 5.1 of the MySQL default storage engine is MyISAM;

3, XTRADB on the multi-core CPU performance and scalability is better, for the allocation and use of memory is better, but also lifted the InnoDB a lot of restrictions, provide more than INNODB configuration and performance monitoring parameters.

4, database backup often cold, Win Bei, hot-standby, M has ISAM is not support hot-standby, should be eliminated.

5, the latest version is divided into 5.10 and 5.5 of these 2 large versions, the experimental environment using 5.5.46

Binary installation

MARIADB has 3 mounting options, RPM package, compile, Universal binary installation

1. RPM Installation: Suitable for small environment, the core functions are equipped, quickly build the environment;

2. Compile and install: more recommended, complex requirements, to have a compilation environment, you can specify almost all options;

3. Binary installation: The most recommended way, pre-compiled, not only to avoid the trouble of compiling, but also provide a considerable number of enhancements.

Step 1. Download binary package, unzip

Basic operations

Table Management

Index management

User and Rights Management

This article is from the "Blue Warehouse" blog, be sure to keep this source http://bluebox.blog.51cto.com/8852456/1705967

MARIADB binary installation and basic management