1)*.登录mysql数据库主服务器,并给从服务器设置授权用户.
#mysql-uroot -p123456 test
mysql>grant all (slave) on *.* to user1_zc@192.168.10.2identified by “456”;
or
mysql>grant replication (slave) on *.* user1_zc@192.168.10.2identified by “pass”;
mysql>show grants for user1_zc@192.168.10.2;//检查用户是否授权成功
ormysql>select user,host,password from mysql.user;
2)*.登录mysql数据库主服务器清空bin-log日志记录.
mysql>reset master;
mysql>show master status;
3)*.修改mysql数据库主服务器的配置文件/etc/my.cnf,开户bin-log,并设置server-id的值并重启服务.
#vi/etc/my.cnf (默认开启了)
log-bin=mysql-bin
server-id=1(server-id只要设置一次就可以)
#service mysqld restart or /usr/local/mysql/bin/mysqld_safe –user=mysql &
4)*.备份mysql数据库主服务器数据(库)
#/usr/local/mysql/bin/mysqldump -uroot -p123456 test -l -F > /tmp/test.sql
5)*.把备份的数据(库)恢复到从服务器上
#scp/tmp/test.sql root@192.168.10.2:/tmp/
6)*.再从mysql数据库服务器上恢复数据(库)
#/usr/local/mysql/bin/mysql -uroot -p123456 test < /tmp/test.sql
mysql>show tables;
mysql>select * from t1;//观察主从数据是否一至
7)*.清空从服务器上的bin-log日志(保证主从数据库原始bin-log日志一致)
mysql>reset master;
mysql>show master status;
8).*修改从数据库服务器的配置文件my.cnf,并重启服务.
log-bin=mysql-bin
server-id=2(server-id只要设置一次就可以)
master-host =192.168.10.1
master-user =user1_zc
master-password = 456
master-port = 3306
#service mysqld restart or /usr/local/mysql/bin/mysqld_safe –user=mysql &
9).从测试user1_zc用户能否从从服务器登录主服务器
#/usr/local/mysql/bin/mysql-u user1_zc -p456 -h192.168.10.2 test
10).测试在主服务器上插入数据,在从服务器上检查数据是否一致。