Stack Overflow
Stack Overflow

Questions tagged [maxscale]

MariaDB MaxScale is a database proxy that provides advanced load balancing and high-availability features, a modular architecture and a complete set of modules to suit a wide range of use cases.

The MaxScale documentation can be found on the MariaDB Knowledgebase. The Troubleshooting Guide contains solutions common problems (feel free to add your solutions there).

If you run into a problem or need a new feature, open a new issue on the MariaDB Jira under the MaxScale project. If want to contribute to MaxScale, do a pull request on GitHub.

72 questions
0
votes
1 answer

MariaDB server isn't rejoining as slave after being down

I was testing a few failover cases & initially this was my setup maxctrl list servers ┌─────────┬────────────────┬──────┬─────────────┬─────────────────┬────────────┐ │ Server │ Address │ Port │ Connections │ State │ GTID …
Nandni
  • 1
0
votes
2 answers

How to enable authentication in MaxScale in MONGO for production?

We have a MariaBD version using MaxScale to use the NoSQL version using MongoDB driver. However, the connection is made without authentication and so it is possible to create new databases and collections within MaxScale. How to enable…
marcelo.delta
  • 2,730
  • 5
  • 36
  • 71
0
votes
2 answers

Maxscale "Capability mismatch"

I did a fresh install of Maxscale, and I was trying to set up a Read-Write-Split service on a master-slave mariadb cluster. When I was trying to connect with DataGrip or DBeaver, I got the following error message: [HY000][1927] Capability mismatch…
DavidBu
  • 478
  • 4
  • 6
0
votes
1 answer

How to configure a read-only server with MariaDB Maxscale

Is it possible to configure a read-only server that remains slave even though no more masters are available with MariaDB Maxscale 6. I tried it with a readconroute router, but that one turned the slave eventually in to a master as well. /Theo
Theo
  • 3
  • 2
0
votes
1 answer

Maxscale, ranks and priority

I'm using a maxscale (6.2) readwritesplit router with 3 galera servers (mariadb 10.4). 2 of them are in DC1, and a 3rd one is on a distant DC2. Using ranks is the only option I see here, as priority will be used by galeramon to select the master. My…
CrazyRabbit
  • 251
  • 3
  • 10
0
votes
0 answers

MariaDB Maxscale returns the result of a different query

I currently work on a Java batch application which writes and reads data to a MariaDB Maxscale Galera Cluster with a connection pool. This involves 50-100 read/write operations every second. An issue that we face frequently is that the results of…
Daniel Sundersingh
  • 11
  • 1
  • 3
0
votes
0 answers

Maxscale keep connections that are killed by the application

We are trying to use maxscale for DB load balancing (MySQL 5.7). We are using Hikari for application connection pool. We would like that the Hikari will manage the connection pooling and maxscale will follow the connections from Hikari's side. For…
alubin
  • 11
  • 1
0
votes
1 answer

How to setup MySQL users with Maxscale

I'm setting up a 3 nodes (MariaDB 10.4) Galera cluster with 2 frontal servers. Inside each of these frontal servers there is also a Maxscale 6…
CrazyRabbit
  • 251
  • 3
  • 10
0
votes
1 answer

MaxScale cluster (master-master) setup

When deploying multiple MaxScale in a Master-Slave typology (failover from master to slave with Keepalived or similar) in front of a Galera Cluster in read-write-split mode , everything goes fine. But what about a Master-Master like typology in a…
CrazyRabbit
  • 251
  • 3
  • 10
0
votes
0 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
  • 920
  • 1
  • 14
  • 34
0
votes
1 answer

maxscale/mariadb and automatic failover : Access denied

I am testing the maxscale solution with a simple mariadb architecture, a primary (server2) that receives all requests and a replica (server1). Replication is working properly but at the stop of the primary, I have an error reported by maxscale…
lc63
  • 25
  • 1
  • 4
0
votes
1 answer

MariaDB Spider with Galera Clusters failover solutions

I am having problems trying to build a database solution for the experiment to ensure HA and performance(sharding). Now, I have a spider node and two galera clusters (3 nodes in each cluster), as shown in the figure below, and this configuration…
ycs18153
  • 13
  • 3
0
votes
0 answers

mariaDB Galera Cluster some concepts confused

I am currently studying on MariaDB for HA and data sharding, but there are a few points that confuse me, please helps me out with it. Suppose I wanna implement data sharding to my Galera Clustering, I think both MaxScale and Spider can do this. So,…
ycs18153
  • 13
  • 3
0
votes
2 answers

Maxscale not allowed to connect mysql8 with java application

I have a mysql 8.0.3 database over top of that maxscale server is running when i tried to connect with that mysql jdbc driver this error is coming unknown system variable 'query_cache_size'. But when i tried to connect directly to database is…
Devendra Mishra
  • 77
  • 3
  • 10
0
votes
1 answer

How to change the switching logic of the master? | ProxySQL Maxscale

ENVIRONMENT: MariaDB Ver 15.1 Distrib 10.5.9-MariaDB ProxySQL Maxscale Debian 10 I have master(A)>slave(B) replication. Replication is controlled by Maxsale with autofailover. If there is no Internet on my master(A), then the master switches to…
Alexander Kolesnik
  • 41
  • 6
1 2
3
4 5