I would like to ask a question regarding replication of 3 nodes within MySQL before I do proceed with my idea by purchasing more hardware.
That being the case, currently I do have 2 nodes with master-master GTID based replication (lets name those nodes A and B, so A is master for B and B is master for A). They do replicate each others data flawlessly without issues. So, in general, it looks like this:
Now, I would like to add another node C, which would be a master to A and vice-versa (A being master to C). This of course would work on a different channel name:
My main question is - will a query executed on B replicate to C through A and will a query executed on C replicate to B through A?
I would like to avoid circular replication for that matter because it simply increases possible points of failure.
