4、测试
在master上新建表,
MySQL> use blog;
Database changed
mysql> create table hi_tb(id int(3),name char(10));
Query OK, 0 rows affected (0.14 sec)
mysql> show tables;
+----------------+
| Tables_in_blog |
+----------------+
| hi_tb |
+----------------+
1 row in set (0.00 sec)
在slave查看
mysql> use blog;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql slave没有发现新建的表,说明主从复制中间出了问题,所以需要查看mysql错误日志
tail -f /var/log/mysql/mysql.error
2013-09-22 15:39:21 2150 [Warning] Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives.
2013-09-22 15:39:21 2150