6.停止master数据库,并将备份传到slave上(也可使用mysqldump等)
[root@test2 mysql]# mysqladmin -uroot -p shutdown
Enter password:
STOPPING server from pid file /usr/local/mysql/data/test2.pid
080313 16:08:55 mysqld ended
[1]+ Done mysqld_safe --user=mysql
[root@test2 mysql]# cd /usr/local/mysql
[root@test2 mysql]# tar -cvf data.tar data
7.备份完后,恢复写操作
mysql> unlock tables;
Query OK, 0 rows affected (0.01 sec)
8.在slvae上将数据备份解压到相应的目录
[root@test1 mysql]# mysqladmin -uroot -p shutdown
Enter password:
STOPPING server from pid file /usr/local/mysql/data/test1.pid
080229 02:26:53 mysqld ended
[1]+ Done ./mysqld_safe --user=mysql (wd: /usr/local/mysql/bin)
(wd now: /usr/local/mysql)
[root@test1 mysql]# tar -xvf data.tar
9.修改slave上的my.cnf,设置server-id(server-id是唯一的)
[mysqld]
datadir = /usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock
log-error = /var/lib/mysql/test1_mysqld.err
log-slow-queries = /var/lib/mysql/slow_query_log.log
log-bin = /var/lib/mysql/test1_log-bin
server-id=2
10.在slave上,使用--skip-slave-start启动mysql,这个参数据不用马上启动复制进程.这样方便我们下一步配置
[root@test1 mysql]# bin/mysqld_safe --skip-slave-start --user=mysql &
[1] 8185
[root@test1 mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data