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

MariaDB + MaxScale Replication Error : The slave I/O thread stops because a fatal error is encountered when it tried to SELECT @master_binlog_checksum

I am trying to setup Real-time Data Streaming to Kafka with MaxScale CDC with MariaDB veriosn 10.0.32. After configuring replication, I am getting the status: "The slave I/O thread stops because a fatal error is encountered when it tried to SELECT…
Khorshed Alam
  • 314
  • 2
  • 11
0
votes
1 answer

Is it possible to specify a connection timeout for Maxscale connections from applications?

I have setup a two node MariaDB Galera cluster on Ubuntu systems. A simple application connects to a database using MaxScale and it works fine. But when the node in the cluster that is currently in use, say, node 1, fails, the application gets error…
mvsagar
  • 1,998
  • 2
  • 17
  • 19
0
votes
0 answers

can telnet into MaxScale but can't connect with MySQL console

I am attempting to connect to a server with MaxScale on it (which in turn is connected to a master/multiple slaves setup). I can telnet to the MaxScale IP and port but can't connect using the MySQL console. Any ideas?
eabates
  • 878
  • 1
  • 8
  • 22
0
votes
1 answer

Route prepared statements to the slaves

My setup is as the following: MaxScale 2.1.4 -> Master -> 2 slaves (both MariaDB 10.2). *CentOS 7 Most of my queries are prepared statements so the master basically handles 90% of the queries right now. I've enabled the hintfilter and tried to add a…
Jack
  • 81
  • 2
  • 5
0
votes
2 answers

MaxScale JSON cache rules

I would like to know how to correctly format JSON cache rules to MaxScale. I need to store multiple tables for multiple databases and multiple users, how to correctly format this? Here, i can store one table on one database and use it for one…
TheMadCat
  • 107
  • 1
  • 7
0
votes
1 answer

maxscale: Backend server didn't accept authentication for user

on the same machine where maxscale installed, connection is successfull but when running any query it shows ERROR 2013 (HY000): Lost connection to MySQL server during query logs shows this message: maxscale[]: Backend server didn't accept…
user2976045
  • 1
  • 1
0
votes
1 answer

Can't start mariadb MaxScale service on Ubuntu

I'm running Ubuntu 16.04 with mariadb, And I've downloaded maxscale on the official website, installed, https://downloads.mariadb.com/MaxScale/2.0.4/ubuntu/dists/xenial/main/binary-amd64/maxscale-2.0.4-1.ubuntu.xenial.x86_64.deb And now I can't…
daisy
  • 22,498
  • 29
  • 129
  • 265
0
votes
1 answer

Database Proxy Node Failures During Writes

In cases when a database proxy (e.g., maxscale) is present between the backend database and the client, what happens to writes if the proxy node itself fails. Specifically, I am interested in the following scenario: Client issues a write command…
gmemon
  • 2,573
  • 5
  • 32
  • 37
0
votes
1 answer

Maxscale: combine readwritesplit and schemarouter

I'm trying to setup maxscale to use schemarouter and readwritesplit. I have many shards for my mysql database. Each shard has a slave So the idea is to use one schemarouter on masters and one on slaves to proxy all shards. Then use These 2 services…
Younes
  • 375
  • 4
  • 16
0
votes
2 answers

MaxScale: Failed to retrieve database names

When I start maxscale, I get the following error: ... 2017-01-17 20:26:05 debug : qc_sqlite: Token 34 not handled explicitly. 2017-01-17 20:26:05 debug : qc_sqlite: Token 103 not handled explicitly. 2017-01-17 20:26:05 debug : qc_sqlite:…
Younes
  • 375
  • 4
  • 16
0
votes
1 answer

How to actually make persistent connection between php application, maxscale and RDS

I need to create persistent connection between my application, MaxScale and RDS. When load is around 40K MaxScale stops finding master and send all connections to Slave for no reason. I am using mysql pconnect and maxscale persistent connection…
rohitarora
  • 1,380
  • 2
  • 13
  • 20
0
votes
1 answer

Can MariaDB's Maxscale(BinLog Server) be used as a collector of binlogs from different mysql clusters?

I have read that Maxscale(BinLog Server) of MariaDB can be used for relaying the bin logs from a MySQL Cluster to a single BinLog Server, however i wanted to know if its possible to collect all the bin logs from different MySQL Cluster and persist…
Sushil Ks
  • 403
  • 2
  • 10
  • 18
1 2 3 4
5