Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to use MySQL master/slave". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Master my.ini

Basedir = D:\ mysql_test\ mysql-5.7.17-master

Datadir = D:\ mysql_test\ mysql-5.7.17-master\ data

Port = 3306

Log-bin=mysql-bin

Server_id=1

Binlog-ignore-db=information_schema

Binlog-ignore-db=cluster

Binlog-ignore-db=mysql

Binlog-do-db=test

Slave my.ini

Basedir = D:\ mysql_test\ mysql-5.7.17-slave

Datadir = D:\ mysql_test\ mysql-5.7.17-slave\ data

Port = 3307

Log-bin=mysql-bin

Server-id=2

Binlog-ignore-db=information_schema

Binlog-ignore-db=cluster

Binlog-ignore-db=mysql

Replicate-do-db=test

Replicate-ignore-db=mysql

Log-slave-updates

Slave-skip-errors=all

Slave-net-timeout=60

Master operation

Mysql > CREATE USER 'rep'@'%' IDENTIFIED BY' rep'

Mysql > GRANT FILE ON *. * TO 'rep'@'%' IDENTIFIED BY' rep'

Mysql > GRANT REPLICATION SLAVE ON *. * TO 'rep'@'%' IDENTIFIED BY' rep'

Mysql > FLUSH PRIVILEGES

Mysql > show master status

+-+ +

| | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | |

+-+ +

| | mysql-bin.000002 | 4570 | test | information_schema,cluster,mysql |

+-+ +

Slave operation

Mysql > CREATE USER 'rep'@'%' IDENTIFIED BY' rep'

Mysql > change master to master_host='localhost',master_user='rep',master_password='rep',master_log_file='mysql-bin.000002', master_log_pos=4570

Mysql > start slave

Mysql > show slave status

Slave_IO_Running and Slave_SQL_Running are both Yes for success.

Master creates databases, creates tables, adds data, and automatically replicates to Slave.

That's all for "how to use MySQL master/slave". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.