項(xiàng)目需求:
1:主數(shù)據(jù)庫(kù)ip:192.168.1.31從數(shù)據(jù)庫(kù)ip:192.168.1.32
2:建立主從關(guān)系,實(shí)現(xiàn)數(shù)據(jù)主從同步
實(shí)現(xiàn)步驟:
[root@zhu~]#vim/etc/my.cnf
[mysqld]
server_id=31
log_bin
[root@zhu~]#servicemysqlrestart
2:給從數(shù)據(jù)庫(kù)用戶授權(quán)
mysql>grantreplicationslaveon*.*toslave@"192.168.1.32"identifiedby"123";
3:配置從數(shù)據(jù)庫(kù)的主配置文件,重啟服務(wù)
[root@cong~]#vim/etc/my.cnf
[mysqld]
server_id=32
[root@cong~]#servicemysqlrestart
4:從數(shù)據(jù)庫(kù)指定主數(shù)據(jù)庫(kù)參數(shù)
mysql>changemasterto
->master_host="192.168.1.31",
->master_user="slave",
->master_password="123",
->master_log_file="localhost-bin.000001",
->master_log_pos=472;
5:開啟從數(shù)據(jù)庫(kù)同步功能