Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [maxscale]

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

MariaDB MaxScale is an intelligent database proxy that provides features such as transparent load balancing, query routing, read-write splitting, filters, plugins (known as modules) and high availability.

As binary packages MaxScale is currently (Jan. 2018) only available for selected Linux distributions.

MaxScale is released under the Business Source License (BSL).

22 questions
3
votes
2 answers

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 on the same server. I have found on doing a large…
nelaaro
  • 767
  • 3
  • 10
  • 22
2
votes
1 answer

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) and the readwritesplit router, It is not clear…
g.pickardou
  • 187
  • 10
2
votes
1 answer

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 of the nodes (two nodes in total) was disconnected…
Zareh Kasparian
  • 121
  • 4
2
votes
1 answer

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 chose to let the application create a schema per…
Phillip -Zyan K Lee- Stockmann
  • 75
  • 8
2
votes
1 answer

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 storage is also therefore 120Gb. If I add a 4th…
user3566845
  • 113
  • 8
1
vote
2 answers

Why Maxscale doesn't switch master?

I have a galera cluster with mariadb 10.6.22 and maxscale 24.02.2 in ubuntu 22.04 server. This is my…
Tobia
  • 211
  • 3
  • 11
1
vote
1 answer

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" and there is a difference in GTID. Does anyone know how to…
Lucian Tarbă
  • 21
  • 5
1
vote
3 answers

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 like to enhance my application to be able to run…
Lars
  • 109
  • 1
  • 5
1
vote
2 answers

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 connections and doesn't close them. No of…
Amit P
  • 111
  • 6
1
vote
3 answers

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 of the slaves we have hooked up the the…
Bif Stone
  • 11
  • 3
1
vote
1 answer

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 accordingly (and does not bring our website down),…
Bif Stone
  • 11
  • 1
0
votes
1 answer

maxscale - getting access denied when specifying DB name, but successful when I omit it

We are implementing MaxScale as a DB proxy between our app and the DB hosted in AWS Aurora MySQL. I've configured MaxScale and verified the servers can all connect, and when I connect from the app server to the proxy endpoint via cli, everything…
Brian Phelan
  • 11
  • 3
0
votes
1 answer

How can I disable the MaxScale readwriterouter for specific queries?

I'm using a Galera replication and MaxScale readwriterouter. I'm facing an issue because the application has been developed with this flow: start transaction update a record commit read that record The result is the the record is updated using the…
Tobia
  • 211
  • 3
  • 11
0
votes
0 answers

Cluster MariaDB Primary + Two Replicas orchestrated via MaxScale: how to recover from a major disruption?

I am working on a Mariadb cluster primary/replica handled via maxscale, to which I successfully added a third node. When I left things few days ago everything was fine. today I found that all nodes were down, supposedly because of a power outage.…
albea798
  • 1
  • 1
0
votes
0 answers

Issue with MariaDB Master-Slave Cluster Failover in MaxScale When Multiple Pods Are Deleted

Issue with MariaDB Master-Slave Cluster Failover in MaxScale When Multiple Pods Are Deleted Hello everyone, I’m running a MariaDB master-slave-slave setup with MaxScale for automatic failover. The cluster consists of one master and two…
unknown
  • 104
  • 2
  • 11
1
2