There is possibility for asynchronous replication with XtraDB cluster. I have tested it with following cases:
- XtraDB1 → XtraDB2
- Standalonedb → XtraDB
It seems to work really well. And it even posses self-healing features. If the node where replication is configured goes down, then the replication will be configured on another node.
I have mostly followed this guide: Set up Percona XtraDB Cluster cross-site replication, but also viewed some blog writings.
So my question: should async replication work with ProxySQL? I was not able to get it to work in my tests.