Lab Environment:
main MySQL server source installation IP address: 172.16.1.1
from the primary MySQL server RPM installation IP address: 172.16.1.10
install IP address from MySQL server rpm: 172.16.1.11
start configuration below:
primary MySQL server:
vi/etc/my.cnf
[Mysqld]
Log-bin=a_master
server-id=1
Authorization to 172.16.1.10 access rights
Grant Replication Slave on * * to ' slave ' @ ' 172.16.1.10 ' identified by ' king123 ';
from the primary MySQL server:
vi/etc/my.cnf
[Mysqld]
server-id=2
Log-bin=b_master
log-slave-updates
master-host=172.16.1.1
Master-user=slave
master-password=king123
Authorization to 172.16.1.11 access rights
Grant Replication Slave on * * to ' slave ' @ ' 172.16.1.11 ' identified by ' king123 ';
from MySQL server:
vi/etc/my.cnf
[Mysqld]
server-id=3
master-host=172.16.1.10
Master-user=slave
master-password=king123
empty all log records and resynchronize if there is a different step
This article is from the "Small Zheng Technology Blog" blog, please be sure to keep this source http://ko178.blog.51cto.com/220419/1765214
MySQL Practice title: AB Copy "master----from (master)------from"