主:192.168.246.130
从:192.168.246.131
主配制:my.conf
server_id=131
log-bin=mysql-bin
binlog-format=mixed
从配制:my.conf
server_id=130
relay-log=mysql-relay
主授权(130):
mysql> grant replication client,replication slave on *.*
-> to 'repl'@'192.168.%.%'
-> identified by 'repl';
查看主服务器日志文件(默认data目录):
more mysql-bin.index
查看主服务器状态值
mysq> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000002 | 467 | | | |
+------------------+----------+--------------+------------------+-------------------+
从连接主(131上操作)
mysql> change master to
-> master_host='192.168.246.130',
-> master_user='repl',
-> master_password='repl',
-> master_log_file='mysql-bin.000002',
-> master_log_pos=467;
Query OK, 0 rows affected, 2 warnings (0.08 sec)
--记住一个命令
--reset slave;
--start slave;
--stop slave;
--show slave status G
--show master status G