测试一:
从:
vi /etc/my.cnf
replicate_do_db=hadoop
测试步骤:
主:
mysql> use hadoop;
mysql> select * from test;
+------+
| id |
+------+
| 1 |
| 3 |
| 2 |
+------+
3 rows in set (0.00 sec)
mysql> use love;
mysql> insert into hadoop.test values(4);
Query OK, 1 row affected (0.00 sec)
mysql> select * from hadoop.test;
+------+
| id |
+------+
| 1 |
| 3 |
| 2 |
| 4 |
+------+
4 rows in set (0.00 sec)
从:
mysql> use hadoop;
mysql> select * from test;
+------+
| id |
+------+
| 3 |
| 1 |
| 2 |
+------+
3 rows in set (0.00 sec)
从:
vi /etc/my.cnf
replicate_do_db=hadoop
测试步骤:
主:
mysql> use hadoop;
mysql> select * from test;
+------+
| id |
+------+
| 1 |
| 3 |
| 2 |
+------+
3 rows in set (0.00 sec)
mysql> use love;
mysql> insert into hadoop.test values(4);
Query OK, 1 row affected (0.00 sec)
mysql> select * from hadoop.test;
+------+
| id |
+------+
| 1 |
| 3 |
| 2 |
| 4 |
+------+
4 rows in set (0.00 sec)
从:
mysql> use hadoop;
mysql> select * from test;
+------+
| id |
+------+
| 3 |
| 1 |
| 2 |
+------+
3 rows in set (0.00 sec)