ABB

A：/etc/my.cnf

server_id = 1
log-bin=binlog
log-bin-index=binlog.index
重启mysql

B1：/etc/my.cnf

server_id = 2
relay_log = /var/lib/mysql/mysql-relay-bin
relay_log_index=/var/lib/mysql/mysql-relay-bin.index
重启

A：

进入到mysql中，创建用户：

GRANT replication slave ON *.* TO 'zhm'@'192.168.18.%' identified by '123456';
flush privileges;
 

B1：

将/etc/lib/mysql 下面的所有东西删除

重启mysql

A：

备份数据 到/tmp下面

mysqldump -A -x > /tmp/aaa.sql
 

再推送到B1主机上 

scp /tmp/aaa.sql root@192.168.18.2:/tmp/

B1：

导回数据

mysql < /tmp/full.sql

A：

mysql> flush tables with read lock;

将表给锁上，自己做实验时候可以执行这一步，再生产环境下必须执行
mysql> show master status;
查看主状态

mysql> show master status;
+---------------+----------+--------------+------------------+
| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| binlog.000003 |      460 |              |                  |
+---------------+----------+--------------+------------------+
1 row in set (0.00 sec)
 

mysql>unlock tables;

再解锁

B1:

mysql> change master to master_host='192.168.18.1', master_port=3306, master_user='zhm', master_password='123456', master_log_file='binlog.000003',master_log_pos=460;



mysql> start slave;

让slave运行

show slave status;

mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 192.168.18.1
                Master_User: zhm
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: binlog.000003
        Read_Master_Log_Pos: 460
             Relay_Log_File: mysql-relay-bin.000004
              Relay_Log_Pos: 232
      Relay_Master_Log_File: binlog.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes

看见如上信息表示成功。。。

 

B2：

B2上得操作和B1基本上是一模一样的

vim /etc/my.cnf

server_id = 3
relay_log = /var/lib/mysql/mysql-relay-bin
relay_log_index=/var/lib/mysql/mysql-relay-bin.index

重启mysql

进入到mysql

mysql> change master to master_host='192.168.18.1', master_port=3306, master_user='zhm', master_password='123456', master_log_file='binlog.000003',master_log_pos=460;



mysql> start slave;

让slave运行


mysql> show slave status\G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 192.168.18.1
                Master_User: zhm
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: binlog.000003
        Read_Master_Log_Pos: 460
             Relay_Log_File: mysql-relay-bin.000002
              Relay_Log_Pos: 313
      Relay_Master_Log_File: binlog.000003
           Slave_IO_Running: Yes
          Slave_SQL_Running: Yes

ok了。。。