maria-developers team mailing list archive
Mailing list archive
Re: Best way of starting multi-source connections with active slave.
Giuseppe Maxia <g.maxia@xxxxxxxxx> writes:
> I am setting up multi-source replication with four nodes, where nodes
> 1, 2, and 3 are masters and node 4 is the slave of the first 3. The
> slave is *active*, meaning that it has a binary log and runs
> transactions of its own.
> Got fatal error 1236 from master when reading data from binary log:
> 'Error: connecting slave requested to start from GTID 0-104-1, which
> is not in the master's binlog. Since the master's binlog contains
> GTIDs with higher sequence numbers, it probably means that the slave
> has diverged due to executing extra erroneous transactions'
> I get the same result if I use 'slave_pos' instead of 'current_pos'.
You need to set gtid_domain_id different on each server:
This way, your slave's GTID position can be multi-dimensional, effectively
tracking the position in each server individually, eg:
>From the error it looks like you do not have different gtid_domain_id
configured, but else do ask again if you still have problems.
Hope this helps,