Is your Server B using the --log-slave-updates flag? -Mike
> 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 > -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (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