Questions tagged [maxscale]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
24 views

How to limit impact of a bad application on MariaDB Galera Cluster with MaxScale?

I have a Galera Replication cluster with three MariaDB nodes where a Maxscale Active-Passive cluster in front provides a single node image to tis clients. I have a bad behaving client, which opens ...
0
votes
1answer
28 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
118 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
266 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
1answer
190 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
667 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
488 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
262 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
1k 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 ...