[MDEV-16572] server_id in combination with galera is not properly documented Created: 2018-06-25 Updated: 2019-12-16 Resolved: 2019-12-16 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera, Replication |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Oli Sennhauser | Assignee: | Geoff Montee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | galera,, replication, server_id | ||
| Description |
|
Replicating from a Galera Cluster to a Slave is a bit tricky when it comes to server_id. It is IMHO not properly documented if the server_id's on the Galera Cluster have to be all the same or different. General MariaDB docu says: All server_id's in a Replication set-up must be different (without mentioning Galera). Codership (Alex) told me: In MySQL Galera Cluster all server_id's must be the same in a Galera Cluster. s9s says: They must be the same. My experiments show me, that it works with all different. But I would like to have a clear statement from the Software vendor... |
| Comments |
| Comment by Geoff Montee (Inactive) [ 2019-12-16 ] |
|
This is already documented here: The value of server_id can be set to be the same on all nodes, or they can be set to different values. Both options are valid. One option may be better in some situations, and the other option may be better in other situations. I agree that in general, it is usually best to set server_id to the same value on all nodes. |