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

proxysql - having both hostgroup "-1" and "1"

I trying to cache query with proxysql with bellow command INSERT INTO mysql_query_rules (active,digest,apply,cache_ttl) VALUES (1,'0x4EFCD2A08D30486D',1, 8640000) after that i get this result from stats_mysql_query_digest can any one help me why i…
Majid Karimizadeh
  • 98
  • 1
  • 3
  • 10
1
vote
2 answers

proxysql SHUNNED servers in hostgroup

I have 2 proxysql(2.0.13) + keepalived in front of a 3-node galera-cluster, and 2 of the galera-nodes appeaers as "SHUNNED" in my hostgroup 10. I do not know why they appear as "SHUNNED" and they are never recovered. So i was hoping that somebody…
gwar
  • 21
  • 1
  • 4
1
vote
0 answers

Does Docker Swarm have IPVS (IP fail-over) available?

Recently we have been investigating running Percona cluster with ProxySQL on Docker Swarm, the following guide for reference: https://www.percona.com/blog/2016/06/14/scaling-percona-xtradb-cluster-proxysql-docker-swarm/ Since ProxySQL is SQL load…
Thomas G. Lau
  • 226
  • 3
  • 14
1
vote
0 answers

ProxySQL: how to configure a failover?

How can I config ProxySQL to have a failover, independent from read-only or not. The parameter 'weight' in mysql_servers do not work properly in this case. I have some nodes (MariaDB 10.3) with master-master-replication, and If node1 goes offline,…
Dave_B.
  • 173
  • 10
1
vote
1 answer

ProxySQL data masking for multiple columns

I want to mask sensitive information on multiple columns in a table named my_table using ProxySQL. I've followed this tutorial to successfully mask a single column named column_name in a table using the following mysql_query_rules: /* only show the…
Brian
  • 12,145
  • 20
  • 90
  • 153
1
vote
0 answers

Proxysql - Please help me clarify "chains of rules" feature

I'm newbie with proxysql, this my enviroment: Centos 7 , proxysql-1.4.13 . I define 2 host group ids : host group id 2 for mysql server that can write , host group id 3 for mysql server that can read. All queries that begin with insert, update,…
user36814
  • 141
  • 1
  • 1
  • 10
1
vote
0 answers

Writing to a table on a read only slave

I've a MySQL master-slave replication setup where the slave is marked as read-only=ON. I've some stored procedures that I want to route through ProxySQL to the slave and prefer not to run on the master. Each stored procedure logs into an…
Deb
  • 337
  • 3
  • 14
1
vote
1 answer

How to connect to ProxySQL from application

I have Percona XtraDB Cluster running in 3 nodes (node1, node2, node3). I've configured ProxySQL in the 4th node (admin). I have an python application code trying to access the cluster. While connecting to 3306 port of node1, I'm able to…
Anju
  • 631
  • 2
  • 9
  • 25
0
votes
0 answers

mysql statefulset endpoint connection from backend

i have a mysql statefulset, database on Kubernetes cluster. mysql-clusterip----> mysql-0(master)<------(mysql-headless-svc) mysql-clusterip-----> mysql-1(read replica) mysql-clusterip-----> mysql-2(read replica) so i have 2 endpoint…
kif
  • 43
  • 4
0
votes
0 answers

Silverstripe and ProxySQL

Has any one had any success setting ProxySQL up to work with Silverstripe? I get errors like: Unknown Error] Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that…
Thrash Cardiom
  • 1
0
votes
0 answers

Hostgroup 0 has no servers available! Checking servers shunned > for more than 1 second, ProxySQL

I was getting the above error, so, i was checking proxy logs. I found that every 3 failed logins, proxy shunned for 10 seconds. Is this behavior normal? Any work around from preventing from getting shunned? 2023-07-27 08:57:33…
dammyware
  • 7
  • 1
  • 8
0
votes
0 answers

How to track source of multiple sleep queries?

Our application developed using java and mysql Db as a backend. for conenction pooling we have used tomcat-jdbc connection pooling where configured the maxActive connection size to 300. from last few days our application frequently reaching the…
Avyaan
  • 1,285
  • 6
  • 20
  • 47
0
votes
0 answers

ProxySQL with 10+ MariaDB servers in Python app

I have written Python app which fetches data from 8-10 different databases. It works great with SQLAlchemy Pooling but i as soon as started scaling with Multiprocessing, every process creates own connection to database. I can not create more than 32…
Ninad Mhatre
  • 549
  • 1
  • 7
  • 17
0
votes
0 answers

How to shard on data value for prepared statements in proxysql

I am following this doc on implementing data shards in mysql cluster using proxysql: https://proxysql.com/documentation/how-to-setup-proxysql-sharding/. But my application generates prepared statements which are being captured in proxysql…
Shakti Garg
  • 263
  • 3
  • 15
0
votes
2 answers

ProxySQL user is not authenticated by MySQL

I have a container for ProxySQL 2.2.4 and another for MySQL 8.0.31. Both containers are using same network name. So from ProxySQL container I can access MySQL running in another container. Even, ProxySQL Admin can show the MySQL service as ONLINE…
Ravi Srivastava
  • 31
  • 5
1
2
3 4 5