CentOS7 Installing and configuring MARIADB 10 with Yum

Source: Internet
Author: User
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

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.