MySQL asynchronous replication between 2 percona clusters doesn't work
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Percona Cluster Charm |
In Progress
|
Undecided
|
Unassigned |
Bug Description
As it was described in the bug https:/
To overcome that limitation we decided to replicate from Galera cluster to a single percona-cluster unit, but we're still seeing a few issues with the replication:
1) asynchronous replication between the clusters that have members with equal server-id may fail during 'START SLAVE' with errror like this:
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-
2) max_allowed_packet might be too low and prevent certain transaction to go through
[1] https:/
[2] https:/
Fix proposed to branch: master /review. opendev. org/c/openstack /charm- percona- cluster/ +/802066
Review: https:/