无需申请自动送

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;