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
1
vote
1 answer

Does maxscale (with Galera) handle Non-primary component/node condition automatically?

We are going to use maxscale as a sql proxy with our mariadb database, with Galera cluster. In Galera cluster, when quorum is not achieved and split-brain condition happens, some node becomes Non-primary. The Non-primary nodes start rejecting…
Anup_Tripathi
  • 2,817
  • 3
  • 26
  • 37
1
vote
0 answers

Why does Maxscale not pass the slave in master with the failover?

I just set up a MariaDB Eslace and master server. I would like to use the failover function, but when I stop the mariadb master service, MaxScale recognizes its stop and tells me that it will switch the slave to master ... But the slave remains in…
Jeremy support
  • 11
  • 2
1
vote
0 answers

How can I configure two datacentres in master-slave topology

I am trying to insert data between two datacenters using mariadb, galera and maxscale. each data centre has three nodes, one as master and other two as slave. Now I want my data to be inserted to second data centre in case if my 1st datacentre…
rajeev
  • 11
  • 2
1
vote
1 answer

Failing to connect applications via MaxScale

I have 3 node Galera Cluseter and a node for maxscale. the problem is only maxscale user i have defined in maxscale.cnf can connect to cluster via listener service. all nodes are in local network and can see each…
haj_baba
  • 117
  • 4
  • 13
1
vote
2 answers

Too many 'Total Connections'. Is it normal status? MaxScale 2.3.9

I installed Mariadb 10.3.15 and Maxscale 2.3.9 It works fine, but sometimes the query speed is slow. When I look at the status of the service through MaxCtrl, I can see that the value of 'Total Connections' is very high. At first it was small, but…
AIWeaver
  • 11
  • 1
1
vote
1 answer

Maxscale slow and lost connection

i have maxscale installed, I obtain this error: Refresh rate limit exceeded for load of users' table. what can I do? I have mariadb database
Luca Becchetti
  • 1,210
  • 1
  • 12
  • 28
1
vote
2 answers

Maxscale is writing on slave with router_options=master (slave/master replication) and listeners stopped

I've configured on 2 servers(srv50/51), one of them is Master and the second one is slave, Here the configuration of my configuration file /etc/maxscale.cnf : [Read-Only Service] type=service router=readconnroute servers=server50,…
NicoMinsk
  • 1,716
  • 6
  • 28
  • 53
1
vote
1 answer

How to speed up mariaDB query using multiple db server, using Galera Cluster and MaxScale?

I test with stress test tool (to run many concurrent user and many query). There is no speed added when i use more db server (i use 5 servers). I have check on each server, and i see the queries have been distributed on each server. What should i…
tesmojones
  • 2,496
  • 2
  • 21
  • 40
1
vote
1 answer

Scaling Mariadb Galera Cluster

I have installed MariaDB Galera Cluster on ubuntu 14 and it is working fine. See the tutorial I have 3 nodes (each 500GB HDD capacity) mariadb cluster and all replications are working perfect. My questions are : When I run out of disk space after…
Supun Silva
  • 580
  • 5
  • 21
1
vote
1 answer

Setting up MaxScale read/write split routing with MySQL

I am attempting to setup MaxScale read/write split routing with MySQL. My vagrant setup is as follows: Vagrant.configure(2) do |config| config.vm.box = "ubuntu/trusty64" config.vm.define 'maxscale' do |haproxy_instance| …
lorefnon
  • 12,875
  • 6
  • 61
  • 93
0
votes
1 answer

Original master fails to join maxscale as slave once he is back up

In my projecto i am using docker compose to run an api (using tomcat). That api connect to a maxscale server that "connects" to other 3 databases (1 master and 2 slaves). I've enabled replication on the mariadb side and it is recognized on the…
Paulo Barbosa
  • 76
  • 6
0
votes
1 answer

MaxScale Connects to MySQL replica but cannot execute queries

I am setting up a Master-slave MySQL replication setup using 3 MySQL 8 nodes(Fresh installations). I have setup a master and configured another nodes to replicate from the master which is working fine. I have setup MaxScale as a load balancer and I…
Kalana Dananjaya
  • 100
  • 2
  • 14
0
votes
2 answers

maxcrtl cannot connect to maxscale

I have a k8s cluster on which I want to deploy the MariaDB cluster. I have master and slave pods and want to monitor them with a maxscale. The pod runs with its default config without any problem, but when I mount the volume in a type of configmap…
mona moghadampanah
  • 141
  • 2
  • 9
0
votes
1 answer

ProxySQL vs MaxScale on Kubernetes

I'm looking to set up a writing proxy for our MariaDB database on Kubernetes. The problem we are currently having is that we only have one Write master on our 3 master galera cluster setup. So even though we have ours pods replication properly, if…
Eric Fritz
  • 1
0
votes
1 answer

Can Galera Cluster have multiple writers?

I am currently running a Galera Cluster in Kubernetes. The problem I am having is whenever I use a replicaset for Galera it causes problems. The problems stems from the service I have calling the first node I deploy as the "Write" member. The other…
Eric Fritz
  • 1
1
2
3 4 5