Master and slave MySQL versions are MySQL5.6.31<\/p>\n
Primary server IP: 192.168.1.178<\/p>\n
From the server IP: 192.168.1.145<\/p>\n
Master and slave are able to ping each other.<\/p>\n
A?192.168.1.178?Master?
\nB?192.168.1.145?Slave?<\/p>\n
<\/p>\n
service mysqld stop
\nservice mysqld start
\nservice mysqld restart<\/p>\n
<\/p>\n
mysql> grant replication slave on *.* to ‘mohan’@’192.168.1.145’ identified by ‘123456’;
\nmysql> flush privileges;<\/p>\n
vi \/etc\/my.cnf<\/p>\n
port=3306<\/p>\n
binlog-ignore-db=mysql
\nserver-id=1
\nexpire-logs-days=7
\nbinlog-ignore-db=information_schema
\nbinlog-ignore-db=performation_schema
\nbinlog-ignore-db=sys
\nbinlog-ignore-db=gogs<\/p>\n
service mysqld restart<\/p>\n
mysql -u root -proot -P3306
\nmysql> flush tables with read lock;<\/p>\n
show master status;<\/p>\n
mysql> show master status;
\n+——————+———-+————–+——————————————————-+——————-+
\n| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
\n+——————+———-+————–+——————————————————-+——————-+
\n| mysql-bin.000001 | 154 | | mysql,information_schema,performation_schema,sys,gogs | |
\n+——————+———-+————–+——————————————————-+——————-+
\n1 row in set (0.00 sec)<\/p>\n
5 Slave<\/p>\n
# For advice on how to change settings please see
\n# http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/server-configuration-defaults.html<\/p>\n
[mysqld]
\n#
\n# Remove leading # and set to the amount of RAM for the most important data
\n# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
\n# innodb_buffer_pool_size = 128M
\n#
\n# Remove leading # to turn on a very important data integrity option: logging
\n# changes to the binary log between backups.
\n# log_bin
\n#
\n# Remove leading # to set options mainly useful for reporting servers.
\n# The server defaults are faster for transactions and fast SELECTs.
\n# Adjust sizes as needed, experiment to find the optimal values.
\n# join_buffer_size = 128M
\n# sort_buffer_size = 2M
\n# read_rnd_buffer_size = 2M
\ndatadir=\/var\/lib\/mysql
\nsocket=\/var\/lib\/mysql\/mysql.sock<\/p>\n
log-bin=mysql-bin
\nserver-id=3
\nbinlog-ignore-db = mysql
\nbinlog-ignore-db = information_schema
\nbinlog-ignore-db = performation_schema
\nbinlog-ignore-db = sys
\nlog-slave-updates
\nslave-skip-errors=all
\nslave-net-timeout=60<\/p>\n
# Disabling symbolic-links is recommended to prevent assorted security risks
\nsymbolic-links=0<\/p>\n
log-error=\/var\/log\/mysqld.log
\npid-file=\/var\/run\/mysqld\/mysqld.pid<\/p>\n
<\/p>\n
service mysqld restart<\/p>\n
<\/p>\n
mysql> stop slave;
\nmysql> change master to master_host=’192.168.1.178′,master_user=’mohan’,master_password=’123456′,master_log_file=’mysql-bin.000001′, master_log_pos= 154;
\nmysql> show slave status \\G;<\/p>\n
mysql> unlock tables;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
mysql> start slave;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
mysql><\/p>\n","protected":false},"excerpt":{"rendered":"
Master and slave MySQL versions are MySQL5.6.31<\/p>\n
Primary server IP: 192.168.1.178<\/p>\n
From the server IP: 192.168.1.145<\/p>\n
Master and slave are able to ping each other.<\/p>\n
A?192.168.1.178?Master? B?192.168.1.145?Slave?<\/p>\n
<\/p>\n
service mysqld stop service mysqld start service mysqld restart<\/p>\n
<\/p>\n
mysql> grant replication slave on *.* to ‘mohan’@’192.168.1.145’ identified by ‘123456’; mysql> flush privileges;<\/p>\n
vi \/etc\/my.cnf<\/p>\n
port=3306<\/p>\n
[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7147"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7147"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7147\/revisions"}],"predecessor-version":[{"id":7148,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7147\/revisions\/7148"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}