Questions tagged [maxscale]

All versions of MaxScale, the MariaDB/MySQL database proxy.

Filter by
Sorted by
Tagged with
0
votes
1answer
12 views

show detail processlist like at mariadb on maxscale

on mariadb when i need check what are query is running or sleep on mariadb instance. i can see with SHOW PROCESSLIST or select * information_schema.processlist. But after mariadb join and client ...
0
votes
1answer
17 views

MariaDB Maxscale REST API can't show result

hi i have already setup maxadmin on maxscale can access from rest api this is my configuration ..... [CLI_Service] type=service router=cli [CLI_Listener] type=listener service=CLI_Service ...
0
votes
1answer
63 views

MaxScale login as root or other users

I installed MaxScale 2.4.4 with Galera Cluster. I can access to galera with maxscale user but I can't login with other users to maxscale. I created a user in galera and another user with same username ...
0
votes
0answers
36 views

Maxscale PAM and native authentication

I created 2 mysql users on a MariaDB 10.3.20 server (Linux Debian Stretch): simpleuser is a standard mysql user (native authentication) pamuser is a mysql user using PAM authentication GRANT ALL ...
0
votes
1answer
119 views

How Maxscale deals with “Select for update transactions”

We are facing intermitent deadlock issues that doesnt got reflected in the maxscale log nor the mariadb log. Only in the applications triying to do sql transactions in the database. We use mostly ...
3
votes
2answers
1k views

maxscale memory requirements

What is the expected production requirements for memory / cpu for maxscale We have a server with 4 GB of memory configured, to run maxscale as a query r / w router, with a replication manager running ...
2
votes
1answer
623 views

ProxySQL equivalent of MaxScale schemarouter

background My employer developed a web application we provide on software-as-a-service terms to our customers. To allow for multiple customers with a huge mass of data to be stored in a database, we ...
1
vote
1answer
387 views

Manually specifying candidate masters in Maxscale

Looking over the documentation, I haven't quite been able to find if its possible to manually set the candidate master status of a server in Maxscale. The reason I am looking for this is because some ...
1
vote
1answer
258 views

MaxScale not correctly recognizing new topology when we failover to a new master

So I currently have an architecture where we have one master and one slave and read/write splitting in Maxscale. When we fail the slave, Maxscale correctly recognizes it and displays the information ...
2
votes
0answers
948 views

Expanding MariaDB cluster (sharding)

I have an expanding MariaDB 3 node cluster and need to expand the available storage. Each node has (to make the maths slightly easier) 120Gb of database storage. As this is replicated, the total DB ...