master:

vim /etc/my.cnf

mysqld

server_id = 1

 

 

slave:

vim /etc/my.cnf

mysqld

server_id = 2

 

master:

vim /etc/my.cnf

mysqld

server_id = 1

log-bin=binlog

log-bin-index=binlog.index

 

 

 

slave:

vim /etc/my.cnf

mysqld

server_id = 2

relay_log = /var/lib/mysql/mysql-relay-bin

relay_log_index=/var/lib/mysql/mysql-relay-bin.index

 

 

 

master && slave

service mysqld restart

 

 

 

master:

GRANT replication slave ON *.* TO 'boxiang'@'%' identified by '123'; 

 

flush privileges;

 

 

 

 

slave:

cd /var/lib/mysql

rm -fr *

service mysqld restart

 

 

master 

mysqldump -A -x > /tmp/aaa.sql -A 所有库 -x锁表

scp /tmp/full.sql root@192.168.0.200:/tmp/

 

 

slave:

mysql < /tmp/aaa.sql

 

master:

flush tables with read lock;

show master status; 查看主状态 用的是003 at366

 

+---------------+----------+--------------+------------------+

| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB |

+---------------+----------+--------------+------------------+

| binlog.000003 |      366 |              |                  | 

+---------------+----------+--------------+------------------+

 

 

 

 

slave:

change master to master_host='192.168.0.100', master_port=3306, master_user='boxiang',

master_password='123',master_log_file='binlog.000003',master_log_pos=366;

start slave;

 

 

 

slave:

show slave status \G

 

                Master_Host: 192.168.0.100

                Master_User: boxiang

                Master_Port: 3306

              Connect_Retry: 60

            Master_Log_File: binlog.000003

        Read_Master_Log_Pos: 366

             Relay_Log_File: mysql-relay-bin.000002

              Relay_Log_Pos: 232

      Relay_Master_Log_File: binlog.000003

           Slave_IO_Running: Yes

          Slave_SQL_Running: Yes

 

在此基础上

建立2B

 

2B上输入

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

 

change master to master_host='192.168.0.100', master_port=3306, master_user='boxiang',master_password='123',master_log_file='binlog.000003',master_log_pos=366;

 

开启

start slave;

 

 

 

查看

show slave status\G

 

 

Slave_IO_State: Waiting for master to send event

完成

 

 

完成