List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:June 16 2010 10:06am
Subject:Version-differing replication trouble
View as plain text  
Hey list,

Got another strange problem.

I'm in the process of migrating a 4.1 server to a 5.1. Replication is not
compatible between them, so I have an intermediate 5.0 server. Setup is

4.1 -> 5.0 -> 5.1

The server-id is different on all servers. It's been soft-set, followed by a
flush logs, and it shows correctly. All servers have binlogs enabled, and
the 5.0 has log-slave-updates enabled. The 5.0 additionally has a set of
replicate_wild_do_db statements.

Now, replication from 4.1 to 5.0 works fine. However, *some* replication
from 5.0 to 5.1 simply doesn't get sent/executed, while other does.

For example, creating a table on the 4.1 replicates to the 5.0, but not on
to the 5.1. I've checked, and the statement does show up in the 5.0 binlog.
It does however not show up in the 5.1 relay log, although that slave
correctly follows the 5.0 master - no lag, both IO and SQL running, no
errors and correct (and counting) logfile and position. I do see other
modifications (inserts, updates and deletes) in the 5.1 relay log, which I
presume get executed correctly.

Additionally, when I do a create table on the 5.0 host, that replicates
correctly to the 5.1 host.

Can anyone offer some clue as to what goes wrong ?

Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Version-differing replication troubleJohan De Meersman16 Jun