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

This article mainly introduces the easy-to-understand mysql master-slave replication configuration method, the contents of the article are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand the easy-to-understand mysql master-slave replication configuration method.

Yum install-y mariadb*

two。 Start mariadb

Systemctl start mariadb

3. Modify mariadb root password

Mysqladmin-u root-p password 123456

4. Modify master configuration

Vi / etc/my.cnf.d/server.cnf

[mysqld]

Log-bin=mysql-bin

Last bit of server-id=227 / / IP address

5. Modify slave configuration

Vi / etc/my.cnf.d/server.cnf

[mysqld]

Log-bin=mysql-bin

Last bit of server-id=228 / / IP address

6. Restart mariadb

Systemctl restart mariadb

7. Authorize slave on master

GRANT REPLICATION SLAVE ON *. * TO 'root'@'%' IDENTIFIED BY' 123456'

8. View statu

Show master status

9. Configure slave CVM

CHANGE MASTER TO master_host='10.10.101.227',master_user='root',master_password='123456',master_log_file=' mysql-bin.000001',master_log_pos=1110

START SLAVE

SHOW SLAVE STATUS\ G

After reading the above about the easy-to-understand mysql master-slave replication configuration method, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.

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.