vim /etc/my.cnf
[mysqld]
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/mydata/data
log-bin=/mydata/binlog/log-bin
server-id=1
bind-address = 0.0.0.0
skip-name-resolve
mysql
GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO &无需申请自动送39;repluser&无需申请自动送39;@&无需申请自动送39;192.168.130.%&无需申请自动送39; IDENTIFIED BY &无需申请自动送39;replpass&无需申请自动送39;;
FLUSH PRIVILEGES;
mysql> show master status;
+----------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+----------------+----------+--------------+------------------+-------------------+
| log-bin.000017 | 154 | | | |
+----------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
在master2上
vim /etc/my.cnf
[mysqld]
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/mydata/data
log-bin=/mydata/binlog/log-bin
server-id=2
bind-address = 0.0.0.0
skip-name-resolve
mysql
GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO &无需申请自动送39;repluser&无需申请自动送39;@&无需申请自动送39;192.168.130.%&无需申请自动送39; IDENTIFIED BY &无需申请自动送39;replpass&无需申请自动送39;;
FLUSH PRIVILEGES;
mysql> show master status;
+----------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+----------------+----------+--------------+------------------+-------------------+
| log-bin.000017 | 154 | | | |
+----------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
在slave上
vim /etc/my.cnf
[mysqld]
socket=/tmp/mysql.sock
basedir=/usr/local/mysql
datadir=/mydata/data
无需申请自动送log-bin=/mydata/binlog/log-bin
server-id=3
relay-log = /mydata/binlog/relay-bin
bind-address = 0.0.0.0
skip-name-resolve
master_info_repository=TABLE
relay_log_info_repository=TABLE
SHOW GLOBAL VARIABLES LIKE &无需申请自动送39;%repository%&无需申请自动送39;;
CHANGE MASTER TO MASTER_HOST=&无需申请自动送39;192.168.130.61&无需申请自动送39;, MASTER_USER=&无需申请自动送39;repluser&无需申请自动送39;, MASTER_PASSWORD=&无需申请自动送39;replpass&无需申请自动送39;, MASTER_LOG_FILE=&无需申请自动送39;log-bin.000017&无需申请自动送39;, MASTER_LOG_POS=154 FOR CHANNEL &无需申请自动送39;Master_1&无需申请自动送39;;
START SLAVE FOR CHANNEL &无需申请自动送39;Master_1&无需申请自动送39;;
SHOW SLAVE STATUS FOR CHANNEL &无需申请自动送39;Master_1&无需申请自动送39;\G;
CHANGE MASTER TO MASTER_HOST=&无需申请自动送39;192.168.130.62&无需申请自动送39;, MASTER_USER=&无需申请自动送39;repluser&无需申请自动送39;, MASTER_PASSWORD=&无需申请自动送39;replpass&无需申请自动送39;, MASTER_LOG_FILE=&无需申请自动送39;log-bin.000017&无需申请自动送39;, MASTER_LOG_POS=154 FOR CHANNEL &无需申请自动送39;Master_2&无需申请自动送39;;
START SLAVE FOR CHANNEL &无需申请自动送39;Master_2&无需申请自动送39;;
SHOW SLAVE STATUS FOR CHANNEL &无需申请自动送39;Master_2&无需申请自动送39;\G;