From http://dev.mysql.com/doc/mysql/en/Replication_Options.html
--log-slave-updates
Normally, updates received from a master server by a slave are not logged to its binary log. This option tells the slave to log the updates performed by its SQL thread to the slave's own binary log. For this option to have any effect, the slave must also be started with the --log-bin option to enable binary logging. --log-slave-updates is used when you want to chain replication servers. For example, you might want a setup like this:
A -> B -> C
That is, A serves as the master for the slave B, and B serves as the master for the slave C. For this to work, B must be both a master and a slave. You must start both A and B with --log-bin to enable binary logging, and B with the --log-slave-updates option.
MaFai wrote:
Hello all:
I have set the repliaction between A and B server successfully.
While the B server replicate the data from A server,we fould the relay log refreshing.But the master log has no change.
Since we want to add a Server C to replicate the Server B, the master log must existing and refreshing.
Should I set the Server C 's master log to the relay log(Server B's)?
Or an other way to set the Server B updating the master log while it replicate the Server A.
We have make sure that the 'log-bin' parameter in our my.cnf file and the master log file existing.
Any idea apprecated.
Best regards.
MaFai [EMAIL PROTECTED] 2004-05-19
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
