CentOS7 Installing and configuring MARIADB 10 with Yum

1. Create the/etc/yum.repos.d/mariadb.repo file, which has just released the official version of the 10.0 [HTML]View Plain copy print? [MARIADB] name = mariadb BaseURL = Http://yum.mariadb.org/10.2.1/centos7-amd64/gpgkey=https://yum.mariadb.org/RPM-G PG-KEY-MARIADB gpgcheck=1

2. After preparing the repo file, you can use Yum to install the [HTML]View Plain copy print? # yum Install Mariadb-server mariadb-client 3. I like to customize the data directory and the service port, so remove the default data directory [HTML]View Plain copy print? # Rm-rf/var/lib/mysql 4. Create a new Data Catalog [HTML]View Plain copy print? # MKDIR/VAR/DATA/DB/MARIADB 5. Modify the configuration file/etc/my.cnf.d/mysql-clients.cnf, the focus is [client], others can refer to [Plain]View Plain copy print? [Client] Port = 3307 socket =/var/data/db/mariadb/mysql.sock [MySQL] no-auto-rehash [mysqldum P] Quick Max_allowed_packet = 64M [Myisamchk] key_buffer_size = 128M Sort_buffer_size = 128M Read_buffer = 2M write_buffer = 2M [Mysqlhotcopy] Interactive-timeout

6. Modify the configuration file/etc/my.cnf.d/server.cnf, here the performance parameters from the My-large.ini file [Plain]View Plain copy print? [mysqld] Port = 3307