MARIADB Installation and use

Introduction

MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL license. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of shutting MySQL out of the source, so the community uses a branching approach to avoid this risk. MARIADB is designed to be fully compatible with MySQL, including APIs and command lines, making it easy to be a replacement for MySQL. For the storage engine, use XtraDB (English: XtraDB) instead of the MySQL InnoDB.

Official website: https://mariadb.org

Configure the installation configuration file

The profile template is in the root directory, such as Mariadb-10.0.5-winx64\my-small.ini. In addition there are My-medium.ini, My-large.ini, My-huge.ini and My-innodb-heavy-4g.ini.

Please create a new My.ini configuration file in this directory according to the memory size and actual needs of your machine. Row Lock

In order to support the table row lock, we need to use InnoDB, take My-small.ini as an example, we need to open (the specified directory must exist):(if the configuration error, such as no corresponding folder, the service can not start)

1 2 3 4 5 6 7 8 9 Ten |

# uncomment the following if you a Re using innodb tables innodb_data_home _dir  = E: \ \ dbserver \ \ mariadb \ \ Mariadb-10.0.5-wi nx64 \ \ data \ \   #data配置在mariadb下data目录, configuration elsewhere, if InnoDB is created, the second boot has a problem innodb_data_file _path  =   Ibdata1:10m:autoextend Innodb_log_group_home _dir  = E: \ \ dbserver \ \ mariadb \ \ log \ \ # you&n BSP;CAN SET&NBSP, .... _buffer_pool_size up to 50 - 80 % # of ram but beware of  setting memory usage too high innodb_buffer_pool _size  =  16M innodb_ Additional_mem_pool _size  =  2M # set .. _log_file_size to 25 % of buffer pool size innodb_log_file _size  =  5M innodb_log_buffer _size  =  8M innodb_flush_log_at_trx _commit  =  1