- 论坛徽章:
- 0
|
我的主从结构已经建好了
我的mysql版本是5.1.15-beta
从机配置如下
server-id = 2
master-host = 192.168.1.10
master-user = a
master-password = b
master-port = 3306
master-connect-retry=60
replicate-do-db = a
replicate-ignore-db=mysql
replicate-do-table=a.ware_item
replicate-do-table=a.ware_item_list
replicate-do-table=a.ware_item_title
replicate-do-table=a.ware_item_adTop
replicate-do-table=a.ware_item_tmp
replicate-do-table=a.buyAd
replicate-do-table=a.ware_faq
ware_item_tmp这张表主要是一张商品临时表,每分钟会将商品删除,插入到ware_item表去.但是,每分钟都有一些数据在主mysql上有,但从mysql里没有.
我在从机上使用show slave status\G 又都是正常的
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.10
Master_User: a
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: log.000029
Read_Master_Log_Pos: 834518780
Relay_Log_File: localhost-relay-bin.000027
Relay_Log_Pos: 176741748
Relay_Master_Log_File: log.000029
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: a
Replicate_Ignore_DB: mysql
Replicate_Do_Table: a.ware_item,a.ware_item_adTop,a.ware_faq,a.ware_item_list,a.ware_item_title,a.buyAd,a.ware_item_tmp
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 834518780
Relay_Log_Space: 176744122
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
ware_item_tmp里有text字段,使用的是latin1编码,实际内容使用UTF8编码
text字段如果修改成CHAR,就会报错说匹配出错.
请问,我要怎么做才能消除这里的同步不一致问题呢? |
|