Hi, In order for you to run SQL queries through MaxScale, you need to configure a service and a listener in MaxScale. I assume you've already configured the servers and the monitor since you've managed to test out the automatic failover. The MaxScale tutorial has a chapter on how to configure a readwritesplit service <https://mariadb.com/kb/en/mariadb-maxscale-2402-maxscale-2402-read-write-splitting-with-mariadb-maxscale/>. You can follow that tutorial to configure a port on which MaxScale listens for SQL connections. After that, you simply connect to the port with your normal MariaDB client software and proceed to execute your SQL queries. The readwritesplit service will take care of figuring out where the queries must go and send writes to the current master node and load balance the reads across the slave servers. Markus On 3/20/25 02:49, Richard Reina via discuss wrote:

I am experimenting with maxscale and have set up a test cluster with a master and three slaves. I have successfully tested automatic failover and everything seems to work fine. However, I will need to run occasional direct read and write SQL queries which in the past have done in a non-maxscale/proxy environment by simply logging into the master and doing select and update queries. Since with Maxscale the master can change I believe I cannot do that. Can someone tell me how I can do SQL queries on the maxscale proxy?

How can I get a CLI like:

maxscale> UPDATE contact SET inactive='Y' WHERE ID =923;

_______________________________________________ discuss mailing list --discuss@lists.mariadb.org To unsubscribe send an email todiscuss-leave@lists.mariadb.org

-- Markus Mäkelä, Senior Software Engineer MariaDB Corporation