Hello!
I have a following system.
Server A : a master for server B. MySQL 4.0.9
Server B : a slave for server A, a master for server C. MySQL 4.0.10
Server C : a slave for server B. MySQL 4.0.10
and I wanna that if update occurs on A, it forwarded to B and B forward it to C
But I don't know how to.
I had setted up all necessary options.
Replication A-B works well. Replication B-C works well too.
but A's update queries is not forwarded to C.
I think the problem is that C does not read Relay log of B.
so, I execute command "SLAVE START SQL_THREAD" on C.
but A's update query does not relay to C.
I found Relay_Master_Log_File in C's 'SHOW SLAVE STATUS' does
not match Relay_Log_File in B's 'SHOW SLAVE STATUS'
Here are some Replication related status.
# Server A ( Master for B ) #
mysql> SHOW MASTER STATUS ;
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+-------------------+----------+--------------+------------------+
| localhost-bin.001 | 1522 | repli_test | |
+-------------------+----------+--------------+------------------+
# Server B ( Slave for A, Master for C ) #
mysql> SHOW SLAVE STATUS \G
*************************** 1. row ***************************
Master_Host: 203.xx.xx.147
Master_User: repl
Master_Port: 3306
Connect_retry: 10
Master_Log_File: localhost-bin.001
Read_Master_Log_Pos: 1522
Relay_Log_File: test42-relay-bin.003 <= ??
Relay_Log_Pos: 146
Relay_Master_Log_File: localhost-bin.001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 1522
Relay_log_space: 150
mysql> SHOW MASTER STATUS ;
+----------------+----------+--------------+------------------+
| File | Position | Binlog_do_db | Binlog_ignore_db |
+----------------+----------+--------------+------------------+
| test42-bin.002 | 207 | repli_test | |
+----------------+----------+--------------+------------------+
# C ( Slave for B ) #
mysql> SHOW SLAVE STATUS \G
*************************** 1. row ***************************
Master_Host: 203.xx.xx.42
Master_User: repl
Master_Port: 3306
Connect_retry: 10
Master_Log_File: test42-bin.002
Read_Master_Log_Pos: 207
Relay_Log_File: localhost-relay-bin.002
Relay_Log_Pos: 383
Relay_Master_Log_File: test42-bin.002 <= should be 'test42-relay-bin.003' ?
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 207
Relay_log_space: 387
# end
thank you for read !
Any suggestion will please me.
##########################
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.com
Filter : sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
