Andrey Kotrekhov <[EMAIL PROTECTED]> wrote: > >> >> What replication options do you use? >> >> Check if queries are present in the master binary logs and in the rela= > y l=3D >> > ogs on the slave. >> > >> > I research the problem and have got some details. >> > Now we have this theme of mysqld replication (with server ids) >> > +-->---+ >> > +--+-1| 4 >> > | | ^--<---| >> > | | >> > 5<-+ +-->6 >> > >> > And when I update something server 1 query relicates to the >> > servers 5,6,4 >> > But when I update the same table in server 4 query replicates to the >> > server 1 but doesn't replicate to the servers 5 and 6. >> > Servers 1,4 has version 4.0.17. >> > Servers 5,6 has version 4.1.1 >> > >> > Is it a bug? >> > Can anybody repeat it? >> > >> >> Did you run server 1 with --log-slave-updates option? > > No. But I can restart mysqld with this option. > Should I do this? >
Yes. You should start MySQL server with above option if you set up chain replication servers: http://www.mysql.com/doc/en/Replication_Options.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]