Skip navigation links

MySQL Forums :: Replication :: Slave has more data than Master?


Advanced Search

Re: Slave has more data than Master?
Posted by: Yang Jie ()
Date: February 22, 2012 10:23PM

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

Options: ReplyQuote


Subject Views Written By Posted
Slave has more data than Master? 1373 Yang Jie 02/21/2012 06:43AM
Re: Slave has more data than Master? 639 Irfan Ali 02/22/2012 02:49AM
Re: Slave has more data than Master? 659 Yang Jie 02/22/2012 10:23PM
Re: Slave has more data than Master? 744 Irfan Ali 02/23/2012 06:01AM
Re: Slave has more data than Master? 566 Yang Jie 02/24/2012 04:27AM
Re: Slave has more data than Master? 592 Rick James 02/24/2012 07:26AM
Re: Slave has more data than Master? 556 Yang Jie 03/05/2012 04:38AM
Re: Slave has more data than Master? 458 Yang Jie 03/22/2012 05:26AM
Re: Slave has more data than Master? 437 Rick James 03/23/2012 08:03PM
Re: Slave has more data than Master? 562 Yang Jie 03/26/2012 02:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.