Stack Overflow
Stack Overflow

Questions tagged [proxysql]

The ProxySQL Mailing List is very active and is a good place to help with complex issues and potential bugs.

References:

More:

72 questions
0
votes
0 answers

ProxySQL in kubernetes cluster dumps servers

I manage a kubernetes cluster where I just recently added a ProxySQL to handle the query routing between the Master and Read-Replica. In the beginning it seemed to work well but after a few days it crashes when it recieves high traffic. Causing more…
Mikkel Nordskjold
  • 21
  • 1
  • 4
0
votes
1 answer

How to change the switching logic of the master? | ProxySQL Maxscale

ENVIRONMENT: MariaDB Ver 15.1 Distrib 10.5.9-MariaDB ProxySQL Maxscale Debian 10 I have master(A)>slave(B) replication. Replication is controlled by Maxsale with autofailover. If there is no Internet on my master(A), then the master switches to…
Alexander Kolesnik
  • 41
  • 6
0
votes
1 answer

Proxysql Isn't sending data to MySQL replicas/slaves in a multi db cluster

TLDR; Proxysql isn't sending any data to or replicas. The master works just fine, and the replicas are all caught up, but they aren't serving traffic. Overview: The main issue is that no traffic is going to the replicas: We have 4 mysql clusters.…
Maximus
  • 1,417
  • 15
  • 19
0
votes
0 answers

Problem with connecting ProxySQL from remote computer

I just solved my problem, thanks for your help! I'm a developer who wants to connect to the aurora serverless (mysql) through the ec2 instance using ProxySQL. The ec2 instance is running on Amazon Linux 2. I tried to connect from my computer using…
Eliott
  • 23
  • 4
0
votes
1 answer

Spring boot and ProxySQL together, does it work?

We have been reviewing different softwares to load-balancing our spring boot application without change our application, looks like this is the best solution, no single line of code change needed, just connect to the proxysql container instead of…
The MW
  • 401
  • 4
  • 15
0
votes
1 answer

ProxySql connection manages to backend server unavailability

In proxysql we have the query rules for going to Backend DB servers ie Master (Write/Read) and Secondary(Read) but in case as secondary gets down then queries will start failing but how can we manage it from proxysql if secondary is down then that…
anu-27
  • 1
0
votes
0 answers

Cannot install Prestashop with ProxySQL / MariaDb replication - unable_to_parse_set_statement error

I am trying to setup a Mariadb replicated environment to scale a Prestashop e-commerce application on multiple DB servers. My setup : 1 x Mariadb 10.4 Master , 2 x Mariadb 10.4 Slaves (read-only), 1 x ProxySQL Loadbalancer I have setup the…
gennaris
  • 1,467
  • 1
  • 11
  • 17
0
votes
2 answers

In Proxysql Insert,Update are not happening on Master

I have configured Proxysql with master slave. I have only one slave configured and on. Instead of happening update,insert on master, It is happening on slave server. My proxysql server and slave server are same. The query rules I have given is…
Gopal
  • 1
  • 3
0
votes
1 answer

mysql user connection issue through proxysql

Frequent Access denied coming for database user connecting through proxysql. Here is my environment: Azure ubunti 18.4 instance with three mysql 8.018 version of master slave xxx.xxx.xxx.73 (mysql slave) xxx.xxx.xxx.75 (mysql master ) …
Debashis Mallick
  • 104
  • 6
0
votes
1 answer

ProxySQL SSL backend configuration from the config file

Using proxysql 2.0.8 (docker severalnines/proxysql:2.0.8) and I was struggling to configure the SSL for backend servers (hosted as managed cloud instances). At the end - it works while issueing following SQL statements in the admin interface: UPDATE…
gusto2
  • 11,210
  • 2
  • 17
  • 36
0
votes
2 answers

Connecting to ProxySQL via socket - "No such file or directory"

I am trying to connect to ProxySQL from PHP with mysqlnd using the local socket, but I get "No such file or directory" , as the socket would not exist. The same code can connect to the mysql socket with no problem. Basically I am reproducing what…
Zoltan Fedor
  • 2,004
  • 2
  • 23
  • 40
0
votes
1 answer

ProxySQL setup hostgroup concern

It's regarding this instruction from AWS. https://aws.amazon.com/blogs/database/how-to-use-proxysql-with-open-source-platforms-to-split-sql-reads-and-writes-on-amazon-aurora-clusters/ I am not sure if there is an issue with hostgroup_id. When I…
jfordec H
  • 85
  • 1
  • 1
  • 6
0
votes
1 answer

NodeJS mysql module transforms localhost to 127.0.0.1 and fails connection

I am using the mysql package to connect to ProxySQL that is set-up to connect to a MySQL database. From command line, the following works: mysql -u demo1 -P6033 --database=database -p However, this does not work. var connection =…
cogitoergosum
  • 2,309
  • 4
  • 38
  • 62
0
votes
2 answers

Can ProxySQL be asked to use a specific GTID on a read?

We have an application that issues a write to ProxySQL, followed by an immediate read that might be affected by the write. Behind ProxySQL are four MySQL servers - one writer and three readers that replicate from the writer. Now, ProxySQL is able…
Thickycat
  • 894
  • 6
  • 12
0
votes
2 answers

How to use Google App Engine and Google Cloud SQL for auto-scaling database?

I'm trying to setup a web app in Google App Engine standard environment using Flask and MySQL. I know Google App Engine is capable of scaling it's instance dynamically based on the performance needed but I'm unsure how I can do this for my MySQL…
Lennard Deurman
  • 213
  • 1
  • 3
  • 11
1 2 3
4
5