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

Why ERROR 1045 (28000): Access denied in ProxySQL server?

I have setup the proxysql on MySQL master for read and write splitting. MySQL master and slave, proxysql server is running, however, I got an Access denied error in the proxysql terminal. [devops@DRMBUST05 ~]$ mysql -uproxysql -p**** -h 127.0.0.1 -P…
Crypto营长
  • 149
  • 3
  • 14
6
votes
2 answers

ProxySQL between master/slave replication on flaky connection

I have two MySQL servers with master/slave replication between them. The connection between them is ADSL. It is not reliable at all. I decided to add another ADSL connection from another ISP with its own IP address. The problem is that when when one…
Behdad
  • 184
  • 3
  • 12
3
votes
1 answer

Why does jemalloc memory profile evaluated by jeprof seem to show all memory allocations?

We are trying to track down a memory leak in proxysql (2.0.14) which uses jemalloc (5.2.0). We compiled proxysql with debug symbols enabled. The jemalloc configuration that is baked into proxysql is the…
izzy
  • 358
  • 4
  • 7
3
votes
3 answers

ProxySQL giving me the error Access denied for user

I installed ProxySQL in my server. Server details : CentOS Linux release 7.5.1804 (Core) ProxySQL version : proxysql-2.0.2-1-centos7.x86_64.rpm MaridaDB version : Distrib 10.3.7-MariaDB Everything is working fine, but i am getting the following…
Faiz Ahmed
  • 396
  • 6
  • 13
2
votes
0 answers

how to troubleshoot "Communications link failure" error with Cloud Data Fusion

I have two GCP projects. A testing environment, built from scratch and a production environment with an already existing Cloud SQL for MySQL instance. My goal is to set a replication pipeline with Data Fusion to replicate some MySQL table. On the…
Simon Breton
  • 2,638
  • 7
  • 50
  • 105
2
votes
1 answer

How to customize error log format in ProxySQL?

I've notice some syntax error in my proxysql error log (/var/lib/proxysql/proxysql.log): Error during query on (0,1.2.3.4,3306): 1064, syntax error, unexpected '-' But they're report only the error and not the query that cause it. Is it possible to…
Ivan Buttinoni
  • 4,110
  • 1
  • 24
  • 44
2
votes
2 answers

Golang MySQL Driver does not allow database changes with ProxySQL

We are trying to use GO to create a web app that connects to ProxySQL, which will in turn connect to the various MySQL database servers based on MySQL query rules that are set in ProxySQL. We can connect to ProxySQL via command line in linux and…
Bob Kreitz
  • 51
  • 3
2
votes
0 answers

ProxySQL active-standby setup

My setup: Two MySQL servers running with Master-Master replication using third party Tungsten Replicator (for a legacy reasons, can't change that now). Typically this cluster is used as Active-Standby. In normal operation all queries should hit…
Mateusz Bartczak
  • 39
  • 2
2
votes
2 answers

Is it necessary to duplicate user credentials when using proxysql in front of a database cluster?

I've set up a Percona Xtradb Cluster with 5 nodes on a network that also has a ProxySQL server. I have ProxySQL working, I can log in to the admin interface on port 6032 and administer it and I can also log in through port 6033, connecting to the…
jrebs
  • 413
  • 1
  • 3
  • 10
2
votes
1 answer

yum install not working from Dockerfile

I was trying to create a Docker Image for ProxySQL . Following is my DockerFile FROM rhel7:latest USER root MAINTAINER Ques Zama # Update the image with the latest packages (recommended) RUN yum update -y; yum clean all # Update image RUN…
Zama Ques
  • 1,497
  • 5
  • 26
  • 45
1
vote
2 answers

Regex to capture multiple element

I was writting a regex to capture the mysql query execute in proxysql. my expectation of the regex will capture the following commend where email, password, or both of them appear together: SELECT email FROM user_tbl SELECT password FROM…
Axen Wong
  • 13
  • 2
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

Proxysql how do i perform a health check on GCLOUD

I am new to Proxysql and have created a docker file for the Gcloud instance group following is the configration of Docker.file FROM debian:11 MAINTAINER Hitesh Sidhiyta RUN apt-get update && apt-get install -y wget…
Hitesh patel
  • 48
  • 8
1
vote
0 answers

ProxySQL with GCP MIG

Right now I have set the backend as a managed instance group with "N" machines. Where N in 2 to 5. Inside each machine is installed a ProxySQL. As persistence layer, I have set up a Master/Slave configuration with CloudSQL where M is the numer of…
jacorl
  • 396
  • 2
  • 9
1
vote
0 answers

Proxy SQL Error "Detected a broken connection during SET NAMES"

i am testing proxysql cache functionality but i got this error. My idea is to use proxysql to decrease the load on the remote database server. 2021-04-08 13:50:42 MySQL_Session.cpp:2543:handler_again___status_CHANGING_CHARSET(): [ERROR] Detected a…
Emma
  • 23
  • 4
1
2 3 4 5