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; --Vevb.com 
4. start slave; 
5. 確保： 
6. Slave_IO_Running: Yes 
7. Slave_SQL_Running: Yes