A simple and easy-to-understand configuration method for mysql master-slave replication

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.