Skip to main content
Share Your Experience: Take the 2024 Developer Survey
3 votes
Accepted

maxscale memory requirements

Update: The amount of memory MaxScale uses for data buffering can be limited with the writeq_high_water and writeq_low_water parameters. This is the recommended way of dealing with excessive memory ...
markusjm's user avatar
  • 283
2 votes

How Maxscale deals with "Select for update transactions"

It would be routed to the master, because SELECT ... FOR UPDATE is only a part of a transaction, and according to the MaxScale 2.1 readwritesplit documentation, "all statements within an open ...
dbdemon's user avatar
  • 6,371
2 votes
Accepted

ProxySQL equivalent of MaxScale schemarouter

You can find the answer here: Can proxysql have multiple listener? (Google Groups). In short: ProxySQL's query rules support routing by schemaname. For simplicity, let's assume you have 3 distinct ...
René Cannaò's user avatar
2 votes
Accepted

Why should I use MaxScale readwritesplit router over a three node Galera cluster?

TL;DR: Don't write to multiple Galera nodes, you get deadlocks on COMMIT and it's not what Galera was designed for. MaxScale helps you abstract the cluster into a single database endpoint that your ...
markusjm's user avatar
  • 283
2 votes
Accepted

MariaDB Maxscale caching not working

Edit: You forgot to add filters=Cache to the service definition. This is why it looks like it's not working. Filter by default apply only to the services that use them. To take them into use and ...
markusjm's user avatar
  • 283
1 vote
Accepted

How to resolve GTID difference between Master and Slave servers in MariaDB replication using MaxScale?

I have found the solution in this article: https://www.redips.net/mysql/replication-slave-relay-log-corrupted/ I had to detect the last bin log from the Master node, and to execute the following ...
Lucian Tarbă's user avatar
1 vote

How to Sync MySQL Databases when offline?

You commented: So there is no really "simple" solution to implement the scenario described? It's so strange because I don't want to believe that my scenario is so unusual... It's not an ...
Bill Karwin's user avatar
  • 15.1k
1 vote

How to Sync MySQL Databases when offline?

I think you're looking at your scenario the wrong way. Firstly, is your client application a mobile application? Because then that makes more sense why you want to implement an offline mode. It's ...
J.D.'s user avatar
  • 37.9k
1 vote
Accepted

MariaDB Maxscale REST API can't show result

already got for default configuration when you need enable rest api maxscale the tag must be [maxscale] and this is part when you need enable rest api for maxscale [maxscale] ... admin_host=192.168....
febry's user avatar
  • 47

Only top scored, non community-wiki answers of a minimum length are eligible