469,266 Members | 1,679 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,266 developers. It's quick & easy.

Replication database on slave is not updated

Hello,

We are using mysql v4.0.24 on Linux machines.
I'm trying to set up replication with a master and only one slave
database.
The syncronization seems to work well, the relay file on slave is wrote
correctly (Read_Master_Log_Pos and Relay_Log_Pos are updated) but the
information on slave database is not updated.
Master and slave are sincronyzed as shown below but for some reason I
don't understand.
I have to say thay sometimes the replication worked but sometimes
setting up a new slave or changing a slave to master it does not.

This is what I see on the error.log file

050718 11:23:04 Slave I/O thread killed while reading event
050718 11:23:04 Slave I/O thread exiting, read up to log
'mysql-bin.027', position 382
050718 11:23:04 Error reading relay log event: slave SQL thread was
killed
050718 11:23:07 Slave SQL thread initialized, starting replication in
log 'mysql-bin.027' at position 382, relay log
'/var/log/mysql/relay.001' position: 462
050718 11:23:07 Slave I/O thread: connected to master
'r********@192.168.0.100:3306', replication started in log
'mysql-bin.027' at position 382
This is the master status:

mysql> show master status\G
*************************** 1. row ***************************
File: mysql-bin.027
Position: 382
Binlog_do_db:
Binlog_ignore_db:
1 row in set (0.00 sec)
This is the slave status:

mysql> show slave status\G
*************************** 1. row ***************************
Master_Host: 192.168.0.100
Master_User: replicant
Master_Port: 3306
Connect_retry: 60
Master_Log_File: mysql-bin.027
Read_Master_Log_Pos: 382
Relay_Log_File: relay.001
Relay_Log_Pos: 462
Relay_Master_Log_File: mysql-bin.027
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db: copiare
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 382
Relay_log_space: 462
1 row in set (0.00 sec)

This is the processlist:

mysql> show processlist\G
....
*************************** 3. row ***************************
Id: 21
User: system user
Host:
db: NULL
Command: Connect
Time: 1265
State: Waiting for master to send event
Info: NULL
*************************** 4. row ***************************
Id: 22
User: system user
Host:
db: NULL
Command: Connect
Time: 367
State: Has read all relay log; waiting for the I/O slave thread to
update it
Info: NULL
Thank you in advance.

Michele

Jul 23 '05 #1
0 1716

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Nick Gaugler | last post: by
reply views Thread by cjackson | last post: by
reply views Thread by Ilja Booij | last post: by
3 posts views Thread by muldoon | last post: by
3 posts views Thread by Chad J. Lemmer | last post: by
3 posts views Thread by Juan Antonio Villa | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.