-- 主库
server_id = 105 (设置问IP的最后一位即可)
log_bin=mysql-bin (二进制日志文件名称)
binlog-do-db =childrendb (要备份的数据库名称)
log_bin_trust_function_creators=TRUE (若涉及及同步函数或者存储过程需要配置,否则主备会产生异常不能同步 )grant replication slave on *.* to 'tantuls'@'%' identified by 'world';
flush tables with read lock;
show master status;(获取主库的同步位置)
unlock tables;
-- 从库
server_id = 103
read-only(是否只读)
innodb_flush_log_at_trx_commit =2
grant select on xxxx.* to xxxx@'%' identified by 'xxxx';
change master to
master_host='101.200.175.88',
master_user='tantuls',
master_password='world88',
master_log_file='mysql-bin.000002',
master_log_pos=253; (Master status里的pos,同步位置)
start slave;
show slave status;