ProxySQL can have logic to send data to different tenants?

Question

Hi,

From the link below, I believe ProxySQL can be used for load balancing or splitting the read and write workloads across Azure Database for MySQL Flexible read replicas.
"https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/setting-up-proxysql-as-a-connection-pool-for-azure-database-for/ba-p/2589350"

But this is not something you can have logic to send query or data to different tenants, say, this query is sent to the database A and the other one is to Database B, right?
I believe this can be used for only "Database A" (Master server "A" and read replica server "A"). My understanding is correct?

Answer 1

Hi, @Testa Thanks for posting your question in the Microsoft Q&A forum.
Yes, you are correct, proxysql can only perform read-write splitting, which means it can send writes to master server A and reads to replica server A, replica server B, and so on.
Also, there can be only one master server in a replication topology and proxysql is designed for that singular purpose.

Please let me know if you have any additional questions.

Regards
Geetha

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.