1.主ä¸ä¿®æ¹my.cnfæ件ï¼
server-id=1
log-bin=mysql-bin
2.ä»ä¸ä¿®æ¹é
ç½®æ件 my.cnf
server-id=2
relay-log=relay-bin
read-only =1
replicate-ignore-db = mysql
replicate-ignore-db = test
replicate-ignore-db = information_schema
#replicate-wild-do-table = tt.admin
replicate-wild-do-table = my_db.stu // æè¦åæ¥çæ°æ®åºçå个表
3. å建 åæ¥çç¨æ·ï¼ä¸»ä¸ï¼
grant replication client,replication slave on *.* to rep@'10.41.50.105' identified by 'root';
4.åæ¥å°ä¸»åºï¼å¨ä»ä¸æä½ï¼
change master to master_host='10.41.50.80',master_user='rep',master_password='root';
5.å¨ä»ä¸éªè¯ï¼
show slave status\G;
主ä»åæ¥æäºè¡¨
温馨提示:答案为网友推荐,仅供参考