Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [maxscale]

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

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

How to resolve GTID difference between Master and Slave servers in MariaDB replication using MaxScale?

I wrote accidently directly on the Slave DB, and therefore the data is not in sync anymore. When I check MaxScale status, all servers are running, but the Slaves are not detected as "Slave" ...
Lucian Tarbă's user avatar
1 vote
1 answer
878 views

Why should I use MaxScale readwritesplit router over a three node Galera cluster?

In the following official MariaDB blog Getting Started with MariaDB Galera and MariaDB MaxScale the author configures a MaxScale host over a three node Galera cluster, and uses the Galer monitor (OK) ...
g.pickardou's user avatar
0 votes
1 answer
226 views

Maxscale R/W split - SELECTS hitting master?

Using Maxscale 6.3.0 in Read-Write Split, with 1 master and 2 slaves( all MariaDB 10.4), MASTER not configured to accept reads, is it normal that Maxscale redirect these to master? If yes, why? ...
CrazyRabbit's user avatar
1 vote
0 answers
685 views

Best Practice of High Availability For MariaDB

I'm preparing to run a MariaDB Cluster with High Availability and I'm looking for the best practices. Years back, I used to run MariaDB in master-master mode, and there was a big issue. Whenever any ...
Zareh Kasparian's user avatar
0 votes
1 answer
553 views

MariaDB Maxscale caching not working

I have setup Maxscale (v6.2) and have connected to the Galera Cluster (3 nodes - MariaDB 10.5). I am trying to use the cache filter but it seems to not work. I have enabled general log for all the ...
Suraj's user avatar
  • 103
0 votes
0 answers
198 views

Galera Cluster in read-write split and query cache

I currently have 3 MariaDB 10.4 servers, configured as a Galera cluster. In front of it, a Maxscale router to split writes (1 master) and reads (2 slaves). QC is disabled in all 3 servers. My question ...
CrazyRabbit's user avatar
1 vote
3 answers
4k views

How to Sync MySQL Databases when offline?

My application that is running on a client uses a MySQL database running on a server. So multiple clients are connected to the same server. That works well when the server is online. But now I would ...
Lars's user avatar
  • 111
1 vote
2 answers
1k 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 ...
Amit P's user avatar
  • 111
0 votes
1 answer
426 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 ...
febry's user avatar
  • 47
0 votes
1 answer
466 views

MariaDB Maxscale REST API can't show result [closed]

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 ...
febry's user avatar
  • 47
0 votes
1 answer
1k 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 ...
haj_baba's user avatar
0 votes
1 answer
488 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 ...
PsySkeletor's user avatar
3 votes
2 answers
3k 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 ...
nelaaro's user avatar
  • 727
2 votes
1 answer
782 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 ...
Phillip -Zyan K Lee- Stockmann's user avatar
1 vote
3 answers
885 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 ...
Bif Stone's user avatar
1 vote
1 answer
332 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 ...
Bif Stone's user avatar
2 votes
0 answers
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 ...
user3566845's user avatar