[MDEV-5119] Events from a GTID-incapable master inherit domain ID of the slave Created: 2013-10-09 Updated: 2022-10-22 Resolved: 2022-10-22 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | 10.0.10 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Elena Stepanova | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | gtid, multisource, replication | ||
| Issue Links: |
|
||||||||
| Description |
|
If I have replication, for example, from 5.5 master to 10.0 slave, then even if I set gtid_domain_id on the slave to a non-default value, events from master and slave still end up in the slave's binlog with the same (slave's) domain ID. I'm not sure whether it's designed to be this way, I'd rather expect master's events to have the default domain ID 0, so that I could still have a choice – either to keep the slave in the same domain or put it into a different one. But maybe there is a bigger plan behind it, then it should be somehow documented (if it isn't yet). |
| Comments |
| Comment by Michael Widenius [ 2014-01-14 ] |
|
The same issue happens when you are using multi source replication from servers that doesn't have domain id set (like MariaDB 5.5 or MySQL 5.5/5.6) The suggestion to solve this is to add a new option to CHANGE MASTER: DOMAIN_ID=# This domain id will be set for all events without a domain id coming from the given master. |
| Comment by Kristian Nielsen [ 2014-09-03 ] |
|
I think the behaviour is "correct". There is nothing magic in principle about However, it is definitely a valid feature request to be able to set the |
| Comment by Elena Stepanova [ 2022-10-22 ] |
|
I suppose it's of no importance anymore, MariaDB 5.x and MySQL 5.6 are long gone, and we can hardly expect to be able to replicate from other non-mariadb-gtid-capable servers anyway. |