mysql主备同步:
dd1主:yum install mysql-server -y
vim /etc/my.cnf
server-id=1
log-bin=mysql-bin启动二进制日志系统
binlog-do-db=test需要同步的数据库
binlog-ignore-db=mysql禁止同步的数据库
/etc/init.d/mysqld start
show master status
mysql> GRANT REPLICATION SLAVE ON *.* TO dd@'172.25.254.%'IDENTIFIED BY 'redhat'创建同步用户并给予权限
mysql>Flush privileges
dd2备:yum install mysql-server -y
测试 看能不能远程登陆访问:mysql -h 172.25.254.11dd -p redhat
vim /etc/my.cnf
server-id=2
read-only
/etc/init.d/mysqld start
在同步之前确保 master 与 slave 上的数据一致性
mysql> change master tomaster_host='172.25.254.11', master_user='dd',
master_password='redhat',master_log_file='mysql-bin.000003', master_log_pos=106;
slave start
show slave status\G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes如果都是 yes,表示从库的 I/O,Slave_SQL 线程都正确开启.表明数据库正在同步
测试: