- 论坛徽章:
- 0
|
linux下建立mysql镜像数据库
/google 的广告条-->
mysql 版本:3.23.58
环境介绍:主库 10.210.136.12 从库 10.210.136.61
【注意】step2这一步很重要,我就是在这一步走了不少弯路,这个操作的作用是保证主库、副库同步之前数据库数据的一致性。
Steps for replication between master 10.210.136.12 and slave 10.210.136.61
step 1:
在Master上开放一个账号 repl 密码123456给IP:10.210.136.61有档案处理的权限
$> mysql –u root –p
mysql> GRANT FILE ON *.* TO
[email=repl@"10.210.136.61]repl@"10.210.136.61[/email]
" IDENTIFIED BY '123456';
step 2;
mysql> FLUSH TABLES WITH READ LOCK;
tar -cvf /tmp/mysql-snapshot.tar /data2/mysql/var/
mysql> SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+---------------+----------+--------------+------------------+
| VR1-bin.003 | 73 | | |
+---------------+----------+--------------+------------------+
mysql> UNLOCK TABLES;
step 3
修改Master数据库的my.cnf文件
[mysqld]
log-bin
server-id=1
step 4:
Stop the slave server(s).
/data/mysql/bin/mysqladmin -uroot shutdown -p
修改Slave数据库上的my.cnf文件
server-id=100
master-host=172.16.152.64
master-user=replicator
master-password=123456
master-port=3306
log-slave-updates
master-connect-retry=60
step 5:
Start the slave server(s).
./safe_mysqld --user=root &
step 6:
在Slave机器上
tar xvf /mysql-snapshot.tar /data2/mysql/var
step 7:
Execute the following command on the slave(s):
mysql> CHANGE MASTER TO MASTER_HOST='10.210.136.12', MASTER_USER='repl', MASTER_PASSWORD='123456', MASTER_LOG_FILE='VR1-bin.003',MASTER_LOG_POS=73;
step 8:
Start the slave threads:
mysql> SLAVE START ;
参考相关语句:
slave stop;
reset slave;
reset master;
slave start;
show status slave\G;
SHOW MASTER STATUS;
FLUSH MASTER;
FLUSH SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/11263/showart_54733.html |
|