mysql主从复制

在主服务器上配置

master添加配置
[mysqld]
log-bin=/var/log/mysql/mysql-bin
server-id=1

mkdir /var/log/mysql

chown mysql.mysql /var/log/mysql
创建主从同步的用户：
mysql> GRANT REPLICATION SLAVE ON *.*  TO  'repl'@'%'  identified by 'Qiu121423！';
mysql> flush privileges;
mysql> show master status\G；

slave
[mysqld]
server-id=2
mysql> \e
CHANGE MASTER TO
MASTER_HOST='主的ip',
MASTER_USER='用户',
MASTER_PASSWORD='密码',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=849;
mysql> start slave;
mysql> show slave status\G；