Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Simple setting for Poxysql

28 views
Skip to first unread message

Jose Cabrera

unread,
Feb 9, 2025, 6:09:08 AMFeb 9
to proxysql
I have 3 mariadb servers:
   
    mariadb1.cn.lan
    mariadb2.cn.lan
    mariadb3.cn.lan

I already set them in a Galera Cluster, replication is on among them, and installed Proxysql.

Yet, Can I have an easy example of how to set up this arrangement:

   mariadb1.cn.lan   as solely writer
   mariadb2.cn.lan  as reader
   mariadb3.cn.lan as reader

I went through: 


Yet, it is so hard for me to understand how to set just one server as Read Only and another as Writer. How could mariadb1.cn.lan could be set as Reader and Writer is still hard for me to understand, too.

René Cannaò

unread,
Feb 9, 2025, 7:26:26 AMFeb 9
to Jose Cabrera, proxysql

Hi Jose,

Did you check the documentation?

https://proxysql.com/documentation/galera-configuration/

Thanks


--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/proxysql/a559544a-91d8-441d-82bf-a01aff3574bdn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages