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
5
votes
1 answer

How to resolve libpcre.so.1()(64bit) dependency in amazon linux ami

When try to install maxscale, it ask libpcre. How to install libpcre on linux? rpm -ivh maxscale-1.4.3-1.rhel.7.x86_64.rpm warning: maxscale-1.4.3-1.rhel.7.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 8167ee24: NOKEY error: Failed dependencies: …
Prince
  • 51
  • 1
  • 4
3
votes
2 answers

maxscale cannot find gtid_binlog_pos

I have active master - slave (ssl) replication. I installed maxscale, set a configuration, but maxscale cannot get gtid_binlog_pos error : [mariadbmon] Can not select 'master' as a demotion target for failover because it does not have a…
Alexander Kolesnik
  • 41
  • 6
2
votes
1 answer

Maxscale readwritesplit show the same number of connections

I've set up Maxscale to ReadWriteSplit with no reads to master (the default) to a Galera cluster (3 nodes). # # Global configuration # [maxscale] threads=auto local_address=10.1.0.11 query_retries=2 # #…
ac_s_fer
  • 53
  • 4
2
votes
1 answer

HO to fix "json: cannot unmarshal string into Go struct field Event.No. Events Queued of type uint64"

I am trying to implement "maxscale_exporter" in my local env. but I am not get all status in Prometheus which is related to maxscale, I am also getting some repetitive error like below. json: cannot unmarshal string into Go struct field Status.Value…
Smit Shah
  • 314
  • 1
  • 3
  • 13
2
votes
2 answers

Connection killed by MaxScale: Router could not recover from connection errors

Please Help. I have used maxscale for a month, but today something happened. It's not working. I then saw the follow error: this is my error log from spring boot error log: org.springframework.dao.DataAccessResourceFailureException: ### Error…
tian fee
  • 21
  • 1
  • 2
2
votes
1 answer

MaxScale blocks direct connect to database

I have a 2 nodes mariadb cluster with one maxscale load balancer. maxscale blocks connection if i want to connect directly to a database: so for example: mysql -h 35.300.208.100 -u finn -p works and if i then do a USE test i can do everything…
siterytive
  • 23
  • 3
2
votes
2 answers

How to scale up write speed on galera cluster? using maxscale as db proxy

Currently, i am researching about galera cluster using many of servers(linux centos). Scaling up read traffic is very effective and easy, but scaling for write seems difficult(not improved). I have used many servers, using maxscale as…
tesmojones
  • 2,496
  • 2
  • 21
  • 40
1
vote
1 answer

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) My question now is, how can I write this query…
user3876906
  • 55
  • 5
1
vote
1 answer

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 MaxScale cluster. The cluster has one master making the…
Chi-Hsiu Liang
  • 11
  • 3
1
vote
1 answer

MaxScale no Slave State set

We want to use MaxScale and two MariaDB databases with docker-compose. We have the problem that we do not achieve replication of the database via maxscale. Write permissions are available via MaxScale on both databases. Via the command maxscale list…
rvalely
  • 13
  • 4
1
vote
1 answer

maxscale proxy does not route read requests from flask-sqlachamy to the slaves

I have a maxscale mariadb cluster with one master and two slaves. I am using flask-sqlachemy ORM for querying and writing. I have written read queries in style db.session(User).join().... Now all my read queries are going to max scale master…
Sarvesh Kumar
  • 131
  • 1
  • 1
  • 4
1
vote
1 answer

How can i get alarmed if the master's GTID differs from the slave?

The MaxScale distributes the requests to the MariaDB database -> master/slave server on which the database is located. What i need is a script running as a cron or something similar which verifies the GTID from master and slaves. If the slaves GTID…
alessio
  • 31
  • 5
1
vote
1 answer

select database query getting called frequently in mariadb maxscale

We are migrating our java based application from oracle to mariadb. With mariadb 10.5.9, we are using hibernate-5. When our application is running, we are observing in the maxscale query filter, that too many select database queries are getting…
Anil HB
  • 21
  • 3
1
vote
1 answer

Nginx load balancing Maxscale to failover

I have a simple stream block to stream MySQL TCP traffic to Maxscale instances. 2nd instance acts as a failover only, like: stream { upstream maxscale { zone upstream_maxscale 64k; server 10.1.0.11:3307; server…
ac_s_fer
  • 53
  • 4
1
vote
1 answer

maxscale master slave Valid connection check in connection pool

Currently, master-slave replication is finished, and select and insert are branched using the readwritesplit function of maxscale. I was using common dbcp and checking the connection using the options of testOnBorrow and validationQuery through…
kimGT
  • 11
  • 1
1
2 3 4 5