Re: Slave has more data than Master?

[Yang Jie]

Thank your for your reply. I have double checked the issues mentioned by you, I am sure there is not other people or applications which will delete data from the master or insert data to the slave. Additionally, I cannot set the slave to read-only, because some tables, which are not in the replication, will be changed sometimes.

There is another thing which I think may be relevant: the replication crashed twice for the same reason Fatal error 1236. the slave said" reading data from binary log from impossible position". According to this, I check the position on Master, I found"Most probably mysqld crashed writing it". Is it relevant?

my.cnf of master and slave are shown below:

---Master---

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /mnt/user/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking

key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8

myisam-recover = BACKUP

query_cache_limit = 1M
query_cache_size = 16M

server-id = 3000
log-bin = meshlium_mysql_master_bin
expire_logs_days = 10

skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]

[isamchk]
key_buffer = 16M


---Slave---

[client]
user = mysql
socket = /var/run/mysqld/mysqld.sock

[mysqld]
server-id = 4001
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr/local/mysql
datadir = /home/energylab/database/mysql/instances/master/data
tmpdir = /tmp
log_error = /var/log/mysql/error.log