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.
maxscale
80
questions
0
votes
0
answers
18
views
How connecting all users (old & new) to maxscale proxy
I'm encountering an issue where I have set up maxscale as a database proxy.
After installing and configuration, when I connect using the maxscale user, data masking rules are applied successfully ...
0
votes
1
answer
26
views
shard MySQL/Aurora DB by table name with maxscale
I am wanting to split up our DB schema so that one of our session tables resides on its own DB and the remainder of the tables remain on the original server.
So, I want to configure the DB proxy to ...
0
votes
1
answer
69
views
Autorestarting mariadb cluster after node reconnection
I use official mariadb/columnstore docker image. I run docker compose with MaxScale and try to imitate the situation when one of the msc node is disconnected and connected again. I can see in mcs ...
0
votes
1
answer
49
views
How to add development server to running maxscale configuration with auto failover?
I have two MariaDB 10.4.28 servers A and B that run under the control of Maxscale in auto-failover, auto-rejoin mode. I need to add a third, development, server C, which should always be in slave mode,...
0
votes
0
answers
79
views
MaxScale - Mask every column in all tables of a DataBase and specify which not
What I am looking for is to mask all the columns (and new columns that could be added in the future to the tables in my DB).
So for that I want to know if there is a way to mask everything and specify ...
0
votes
1
answer
203
views
How to test load-balancer of MaxScale
I built master/slave constructure in MariaDB and set MaxScale. I tried to test MaxScale if it distribute SELECT queries to multiple replicaDBs but I'm not sure how to test it.
Here is the information ...
0
votes
2
answers
140
views
Maxscale not detecting AWS Aurora 3/MySQL 8 replication slave
I have installed Maxscale v23.02.04 and am able to connect to my AWS RDS instances, and am trying to configure the readwritesplit to split traffic between read/writes.
However, whenever I run maxctrl ...
0
votes
1
answer
32
views
Prevent the execution of "SET NAMES" on all nodes in MaxScale?
Our current setup has multiple slave nodes and one remote master server located in a different datacenter (with a ~100ms latency)?
Is there any way to configure MaxScale to execute the 'SET NAMES' ...
0
votes
1
answer
689
views
ERROR 1045 (28000): Access denied for user on MaxScale
I set up MaxScale so I tried to test whether it work or not.
I did tried to access from application server using this command below
$ mysql --host=192.168.30.145 --user=client --password -P 3309
and ...
0
votes
1
answer
448
views
MaxScale doesn't connect to Galera Cluster
I am working on a distributed HA cloud system and I have a Galera Cluster with 3 separated servers in Docker Swarm. It works as expected.
I have 3 separated services for the Galera members due to ...
0
votes
1
answer
498
views
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 ...
1
vote
1
answer
95
views
maxscale rewrite filter with awk
The following rewrite rule works as expected:
%%
regex_grammar: Awk
case_sensitive: false
ignore_whitespace: true
%
SELECT msg FROM mytable WHERE id = 123
%
SELECT msg FROM mytable WHERE id = sha1(123)...
0
votes
1
answer
801
views
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....
1
vote
1
answer
217
views
MySQL select faster in master but slower in slaves
We have a MariaDB database running to record instant events where the data accumulates quite fast. There are 1000 and up sensors transmitting data into our server which inserts events into the ...
0
votes
2
answers
1k
views
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 ...