1.Master端
创建数据库及表
mysql>create datebase bktest;
mysql>create table test(id int);
插入数据;
mysql> insert into test values(1);
创建连接帐户
mysql>grant replication slave on *.* to 'repl'@'slaveip' identified by '123456';
mysql>flush privileges;
配置my.cnf,在mysqld下添加
server-id=1
log-bin=mysql-bin
log-bin=/usr/local/mysqllog/mysql-bin
binlog-do-db=bktest
binlog-ignore-db=mysql
expire-logs-days=1
max-binlog-size=100M
log-slave-updates
锁定表和查看binlog位置
mysql>flush tables with read lock
mysql>show master status;
备份数据库
/usr/local/mysql/bib/mysqldump -uroot bktest>bktest.txt
gzip bktest.txt
2.在SLAVE端
将备份COPY到SLACE机器
解压缩
gunzip bktest.txt.zp
导入数据
mysql -uroot bktest.txt<bktest
编辑配置文件
vi /etc/my.cnf
在MYSQLD处,添加
server-id=2
replicate-do-db=bktest
replicate-ignore-db=mysql
master-host=slaveip
master-port=3306
master-user=repl
master-password=123456
master-connect-retry=60
log-bin=slave-bin
expire-logs-days=3
退出,保存。
同步数据
change master to
master-host='',
master-port='3306',
matser-user='repl',
master-password='123456',
master-log-file='',
master-log-pos='';
start slave;