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

Maxscale: maxctrl error when admin_ssl parameters are set in maxscale.cnf

System: Maxscale 2.5.9 Ubuntu 20.04 In order to access the Web AdminGUI my maxsclale.cnf file looks like…
user4169982
  • 3
  • 1
0
votes
1 answer

How to change default MaxScale credentials for GUI

MaxScale from v2.5 has a nice web Gui based on REST API. However it has default credentials admin:mariadb. Does any one know how to change this? I've searched around in Mariadb Docs, but found the only options you can change is to add ssl cert's for…
gluktd
  • 46
  • 5
0
votes
1 answer

MaxScale MaxGUI tarball install MaxGUI error

If you configure maxgui when installing with maxscale 2.5 tarball, the web browser does not display normally. However, if I install it at RPM, my web browser will display normally, but why doesn't it display normally when I install it with…
1000
  • 3
  • 2
0
votes
1 answer

SpringBoot HikariCP Maxscale select queries not sending to Slave

Standalone MaxScale is working fine. I used this link to test it. But when I run Spring Boot Data JPA with Maxscale, SELECT queries are sending to Master. I observed the long and found that Spring data starting transactions. Maxscale sending queries…
Chaitanya Kumar Ch
  • 309
  • 1
  • 5
  • 16
0
votes
1 answer

Maxscale looses users sync after node restart

I have Maxscale as a ReadWriteSplit for 3 Galera nodes. Node 1 is MASTER and other 2 are SLAVES. I always create my users on master with: mysql -e "CREATE DATABASE ${DB_NAME} CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;" mysql -e "CREATE USER IF NOT…
ac_s_fer
  • 53
  • 4
0
votes
2 answers

Sequelize-cli returns "Unknown Database" when doing migrations

I have been using sequelize migration all this while with no issue, for example in our development server: "development": { "username": "root", "password": "password", "database": "db", "host": "127.0.0.1", "dialect": "mysql" …
Mohamad Kamal Zakaria
  • 1
  • 1
0
votes
1 answer

MaxScale tries to authenticate users in all servers

I'm trying to test if we could use MaxScale 2.4 to add multiple MySQL servers to an existing application and route the queries to the appropriate server using the schema name. I have set skip_authentication=true to let the MySQL servers handle…
Krychek
  • 3
  • 1
0
votes
1 answer

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 connect to maxscale i can't see processlist like SHOW…
febry
  • 27
  • 7
0
votes
1 answer

maxscale does not split select queries

I have 2 mariadb instances master and one slave. Replication is mixed. SLAVE lag is 0 Seconds_Behind_Master: 0 I have maxscale instance which have to split SELECT queries between master and slave but all SELECT queries are sent to master. Could you…
Anton Antonov
  • 31
  • 4
0
votes
1 answer

MariaDB Maxscale throwing Access Denied though UserID/Password is Correct

Database Version : 10.2.14 Maxscale Version : 2.4.6 Application is using jdbc driver to connect to database userid1 & userid2 is allowed to connect from anywhere i.e. If we connect to database directly from application server we are not receiving…
Jos8483
  • 53
  • 1
  • 1
  • 5
0
votes
1 answer

MaxScale after Failover the master-slave-configuration on previous slave server is resetted

After MaxScale Failover my configuration for the master/slave replikation on my slave server was resetted. Do I have to config it again? I have configured a Master/Slave Replikation and Maxscale Read/write splitting. I've shutted down my master…
mymarcelsql
  • 11
  • 3
0
votes
1 answer

How to reload MaxScale cache rules without restarting the service?

I'm looking for a way to apply a new set of rules in /etc/maxscale.rules (JSON) as specified as rules=/etc/maxscale.rules in my cnf file, without restarting the entire MaxScale service. I am not seeing a MaxAdmin setting that allows manipulating of…
ctrlbrk
  • 1,174
  • 2
  • 17
  • 27
0
votes
1 answer

how can I configure maxscale with one master mariadb server, 3 slave mariadb server?

I need database proxy. Because I need to setup write/read queries and especially row sharding. I found and installed maxscale. How can I configure maxscale with one master mariadb server, 3 slave mariadb server? The original documentation is not…
nomad culture
  • 52
  • 2
  • 11
0
votes
1 answer

Error while connecting to the MariadDB maxscale with tx

While I tried connecting my Mariadb TX server using mxs_adapter and cdc connectors I get the following error: 2018-09-20 16:12:38 [cdc_test.cdc_tab] MaxScale connection could not be created: Exception caught: basic_string::_S_create 2018-09-20…
Abir Adhikari
  • 1
  • 1
0
votes
1 answer

MaxScale with multicluster setup

I've been working on some High Availability scenario's for some database servers and inspected MaxScale & HAProxy and both seem very interesting but the problem is as follows. When setting up MaxScale everything went well until I discovered that I…
ZigaJack
  • 1
  • 1
1 2 3
4
5