主库IP：58.192.112.60
从库IP：10.65.0.19
1、主库配置编辑my.cnf在[mysqld]中添加：
# 启用二进制日志
server-id=1
log-bin=mysql-bin
binlog-do-db=webplus3_14783 //同步数据库
innodb_flush_log_at_trx_commit=1//具体参数意义可以参考附录地址
sync_binlog=1
log-slave-updates
2、创建同步账号(可以用单独创建个普通用户)
mysql> grant replication slave on *.* to root@10.65.0.19 identified by '12344idc@60' ;
3、主库状态
mysql> flush privileges;
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB |Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000002 | 120 | | |
+------------------+----------+--------------+------------------+
记录下二进制日志文件名和位置
4、从库配置文件配置
# [必须]服务器唯一ID，不可重复
server-id = 2
replicate-do-db = webplus3_14783 //指定同步数据库名
master-info-file = master.info
relay-log = relay-relay-bin
relay-log-index = relay-relay-bin.index
relay-log-info-file=relay-relay-log.info
read-only
5、配置连接主库
mysql> change master to master_host='58.192.112.60',master_user='root',master_password='12344idc@60', master_log_file='mysql-bin.000002',master_log_pos=120;
6、开始同步
mysql> start slave;
mysql> show slave status/G;
7、正常状态
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
（两种状态必须都为Yes）