mysql互为主从复制详解----mysql-mm(9)

mysql> insert into lian (a,b)values(22,hahah);
ERROR 1054 (42S22): Unknown column 'hahah' in 'field list'
mysql> insert into lian (a,b)values(22,'hahah');
Query OK, 1 row affected (0.00 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| lian           |
+----------------+
1 row in set (0.00 sec)

mysql> select * from lian;
+------+-------+
| a    | b     |
+------+-------+
|   22 | hahah |
+------+-------+
1 row in set (0.00 sec)

查看一下B的master日志，证明以上操作成功：
cat mysql-bin.000002                                                                                                                                                                                  
.?Nh?@
stdtestcreate table lian (a int,b char(10))??Nl>
@
stdtestinsert into lian (a,b)values(22,'hahah')

现在查看从服务器A的relay日志，发现日志已经同步了
[root@XKWB5510 var]# cat XKWB5510-relay-bin.000003