数据库主从复制

 

 

 

 

刷新权限
flush privileges;

 

数据库主从复制
1.主操作


a:
[mysqld]
......
server-id=1
log-bin=mysql-bin
binlog-do-db=xxxshujuku

c:
查看server-id，命令'SHOW VARIABLES LIKE 'server_id';'

d:
show master status;

e:授权
GRANT REPLICATION SLAVE ON *.* to 'xxxx_edu'@'%' identified by 'xxxxxmima';

从操作
b:
[mysqld]
......
server-id=2
log-bin=mysql-bin
slave-net-timeout=60
replicate-do-db=xxxshujuku

f:
 stop slave; 

g:
change master to master_host='47.9333.22.7',master_user='xxx',master_password='xxx',master_Log_File='mysql-bin.000007',master_log_pos=154;

master_Log_File===File 和 master_log_pos== Position 见d操作

h:开启
 start slave;

i:
show slave status \G;



框架主从复制 见下图