2.设置复制指定数据库
在slave上的my.cnf中设置如下(加入replicate-do-db)
......
replicate-do-db=test
......
3.启动slave
[root@test1 mysql]# /usr/local/mysql/bin/mysqld_safe --user=mysql &
[1] 8357
[root@test1 mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
4.检验
(1).在master上
mysql> use test;
Database changed
mysql> create table t3(id int,name char(8));
Query OK, 0 rows affected (0.01 sec)
mysql> create table t3(id int,name char(8));
Query OK, 0 rows affected (0.01 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| pet |
| t1 |
| t2 |
| t3 |
+----------------+
4 rows in set (0.00 sec)
mysql> use dbatest;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> create table t11(id int,name char(8));
Query OK, 0 rows affected (0.01 sec)
mysql> show tables;
+-------------------+
| Tables_in_dbatest |
+-------------------+
| t11 |
+-------------------+
1 row in set (0.00 sec)
(2)在slave上查看同一个数据库test
mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| pet |
| t1 |
| t2 |
| t3 |
+----------------+
4 rows in set (0.01 sec)
(3)在slvae查看不同数据库dbatest(可以看到没有复制过来了)
mysql> use dbatest;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> show tables;
Empty set (0.01 sec)
参数说明
relay-log= /var/lib/mysql/test1-relay-bin -----设置中断日志存位置和中断日志名字
relay-log-purge=1 ----- 在不需要中继日志时禁用或启用自动清除。默认值是1(启用)。