安装忽略，参考我前面的博客。从库克隆主库，克隆主数据库后，需要修改 server-id 和 /data/mysql/auto.cnf中的UUID， 修改pid文件名字

修改my.cnf

master:只发送binlog-do-db=autoopsslave:只接受replicate-do-db=autoops

主库设置：

配置文件开启 log-bin=mysql-bin从库一般开启

mysql>showvariableslike'log_bin%';+---------------------------------+-------+|Variable_name|Value|+---------------------------------+-------+|log_bin|ON|mysql>grantreplicationslaveon*.*to'rep'@'192.168.10.%'identifiedby'123456';mysql>flushprivileges;

主库:

mysqldump-uroot-p-Bautoops--events--master-data=2--single-transaction>rep.sql

查看req.sql记录 MASTER_LOG_FILE 和MASTER_LOG_POS

22--CHANGEMASTERTOMASTER_LOG_FILE='mysql-bin.000009',MASTER_LOG_POS=1564447;

注意：innodb用–single-transaction,myisam需要用–lock-all-tables。

scprep.sqlroot@192.168.10.36:/root

从库:

mysql-uroot-p123456</opt/rep.sql

CHANGEMASTERTOMASTER_HOST='192.168.10.29',MASTER_PORT=3306,MASTER_USER='rep',MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000009',MASTER_LOG_POS=1486295;

/data/master.info//生成的文件

mysql> start slave;

mysql> show slave status\G;

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

relay-bin.index

/data/3307/relay-bin.000001

/data/3307/relay-bin.000002

relay-log.info/中继日志

427

mysql-bin.000005

591