Is it possible to use percona server with Proxysql for replication?

Polyglot Projects ProxySQL
1

Good day. I trying to use
Percona Server → Proxysql → PXE cluster.
I have successful replication from percona server to PXE, but when using it with proxysql I have errors:
on Percona server (slave)

Master command COM_REGISTER_SLAVE failed: Lost connection to MySQL server during query (Errno: 2013)

I see that all queries proxied to PXE but get error.
Is it possible to use Proxysql in this schema ?

1 Like
2

Hello @andrey1,
Firstly, it is PXC, not PXE :slight_smile: Secondly, why are you trying this configuration? ProxySQL is not required nor needed between two MySQL servers. As you have PS → PXC working, you should just stick to that. I do not believe ProxySQL can handle replication-based traffic.

2 Likes
3

Ok. Got it. Thank you

1 Like