mysql主从数据库配置

mysql主从数据库配置有复杂的有简了,下面我们来给各位简单的介绍一下mysql主从数据库配置吧,希望能帮助到各位.

主:配置my.conf:

1. log-bin=mysql-bin 
2. server-id       = 1 
3. binlog-do-db=jinrimingpin_com 
4. binlog-do-db=jinripinpai_com 
5. binlog-do-db=jinritemaihui_com 
6. binlog-do-db=mingpintejia_com 

binlog-do-db 是允许同步的数据库,一行一个.

SHOW MASTER STATUS

mysql-bin.000001 4658 下面设置从库要用 change master to

然后导数据到从库,新建一个可让从库访问的账号.

grant replication slave on *.* to “congku”@”xxxx” identified by “密码”;

flush privileges;

从:配置my.conf

1. server-id = 2 
2. replicate-do-db=mingpintejia_com 
3. slave_skip_errors = 1062,1032 

从库要同步的数据库 replicate-do-db.

mysql -u congku -p -h xx.xx.xx.xx 检测是否可以连接主服务器.

1. slave stop; 
2. CHANGE MASTER TO 
3. MASTER_HOST=’xxx’,MASTER_USER=’congku’,MASTER_PASSWORD=’密码’,MASTER_LOG_FILE=’mysql-bin.000002′,MASTER_LOG_POS=102470; --phpfensi.com 
4. start slave; 
5. 确保： 
6. Slave_IO_Running: Yes 
7. Slave_SQL_Running: Yes