I have three servers, Server X, Y, and Z.
I have the main mysql DB on X (innodb DB).
now I have created Master-Slave from X to Y. everything is working fine here.
and now i set Y as a master for Z.
when i do show slave status on Z (the third server)
show slave status\G Slave_IO_State: Waiting for master to send event ... Slave_IO_Running: Yes Slave_SQL_Running: Yes ... Seconds_Behind_Master: 0
but the data is not synchronized and nothing has been moved from Y to Z.
any idea about what might cause this??
EDIT
in my.cnf on server Y, i have the following conf:
log-slave-updates=ON log-bin=mysql-bin
but in show variables like '%slave%' i have
show variables like '%slave%'; +---------------------------+--------+ | Variable_name | Value | +---------------------------+--------+ | init_slave | | | log_slave_updates | OFF | | slave_compressed_protocol | OFF | | slave_exec_mode | STRICT | | slave_load_tmpdir | /tmp | | slave_net_timeout | 3600 | | slave_skip_errors | OFF | | slave_transaction_retries | 10 | | sql_slave_skip_counter | | +---------------------------+--------+
Thanks for your help