mysql主从复制

 主数据库的my.cnf.d

[mysqld]
server-id=1
log-bin=mysql-bin
binlog-format=row

从数据的my.cnf.d

[mysqld]
server-id=2
relay-log=mysql-relay-bin
log-slave-updates=1
read-only=1

-- 在从数据库上执行
CHANGE MASTER TO
MASTER_HOST='主数据库IP',
MASTER_USER='复制用户',
MASTER_PASSWORD='复制用户密码',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=1234;
START SLAVE;