Linux mysql 主从复制

主：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