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 <mysql-thread131720@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-##L=##H@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
