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 HTTP Web Server doesn't work behind HAProxy

I trying to mount a docker-compose stack with a mariadb and proxysql and all works fine. When i navigate to https://172.25.0.174:6080/ (the VM that holds docker stack), the browser shows the ProxySQL Web UI. On top of this stack, i mount another VM…
Alvaro Fuentes Zurita
  • 404
  • 3
  • 14
0
votes
1 answer

What is Mysql/Maria "appication info" or "client identification" - and how not to send it with mysqldump?

There is a mariadb behind a ProxySQL that I am trying to connect to. When using "debugging tools" like IntelliJ's Database plugin or DBeaver, it only works when we disable "sending application information". In IntelliJ it is this setting: On…
Xosofox
  • 840
  • 1
  • 7
  • 21
0
votes
1 answer

ProxySQL vs MaxScale on Kubernetes

I'm looking to set up a writing proxy for our MariaDB database on Kubernetes. The problem we are currently having is that we only have one Write master on our 3 master galera cluster setup. So even though we have ours pods replication properly, if…
Eric Fritz
  • 1
0
votes
1 answer

Can Galera Cluster have multiple writers?

I am currently running a Galera Cluster in Kubernetes. The problem I am having is whenever I use a replicaset for Galera it causes problems. The problems stems from the service I have calling the first node I deploy as the "Write" member. The other…
Eric Fritz
  • 1
0
votes
2 answers

ProxySQL Client Connections

When I Query ProxySQL Client Connections : select * from stats.stats_mysql_global where variable_name like 'Client_connection%'; +-------------------------------------+----------------+ | Variable_Name | Variable_Value…
Primadi
  • 1
  • 4
0
votes
1 answer

9006 ProxySQL Error: connection is locked to hostgroup XX but trying to reach hostgroup YY

ProxySql just stop working, no idea why. And no matter what query is used error would be the same. 9006 ProxySQL Error: connection is locked to hostgroup XX but trying to reach hostgroup YY ProxySQl version: ProxySQL version…
Stevan Tosic
  • 6,561
  • 10
  • 55
  • 110
0
votes
1 answer

mysql_query_rules defined in proxysql.cnf but not loaded

My proxysql.cnf contains: # ... mysql_query_rules: ( { active = 1 match_digest = "^SHOW.*" destination_hostgroup = 3 apply = 0 }, { active = 1 match_digest = "^SELECT.*" …
redochka
  • 12,345
  • 14
  • 66
  • 79
0
votes
1 answer

Issue of small delay after insert / update using proxySQL and MySQl clusters

We are using MySQL clusters with proxySQL with the following set up: Server 1 is the main server hosting the main dB, located in Europe Server 2 is a server in Asia used to serve local users, this server contains a read only version of the DB that…
user1620090
  • 499
  • 6
  • 19
0
votes
2 answers

Proxysql query rule starting with comment didn't work

On proxyql 2.2.0 I've the following rule which isn't working (stats_mysql_query_rules counter always on 0). INSERT INTO mysql_query_rules (active, match_digest, destination_hostgroup, apply, multiplex) VALUES (1, '/\* Master \*/', 1, 1, 1); This…
alxsbn
  • 340
  • 2
  • 14
0
votes
2 answers

ProxySQL - Different MySQL servers

I wanted to use ProxySQL to manage two groups of servers that would have different databases, how could this be done? Example: X instance group Write server 1 Read Server 2 - Replicate Read Server 3 - Replicate database a database b database c Y…
braulio_holtz
  • 141
  • 1
  • 6
0
votes
1 answer

ProxySQL backends always online never shunned

I'm trying to setup simple proxy to galera cluster via proxysql. Backend nodes and proxysql all in docker. Proxy works ok, except monitoring. When i stop mariadb on one node, proxysql still shows the node as ONLINE. I've tried: Create monitoring…
Дмитрий Стародубцев
  • 21
  • 5
0
votes
0 answers

Slow queries and proxysql

I would like to use proxysql so that they can by itself redirect requests which will take too long to execute, I don't know if it's possible but I look no matter how hard I find anything. Someone would have any idea ?
Axel Morvan
  • 41
  • 3
0
votes
1 answer

ProxySQL ssl by command connection works but through Java Client doesn't

I can connect through ProxySQL (using ssl) to a MariaDB instance: E:\>mysql -h 192.168.33.180 -P 6033 -u user --password=password --ssl Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 38364 Server version:…
davigre
  • 21
  • 3
0
votes
1 answer

Lost connection error when trying to connect to proxy SQL on VM with Container Optimised OS

For a project with Data Fusion I need to create a Virtual Machine with Proxy SQL. In order to test this proxy I've created a second instance with MariaBD but I'm not able to establish the connection with the proxy. Here is what I have: A VM running…
Simon Breton
  • 2,638
  • 7
  • 50
  • 105
0
votes
3 answers

ProxySQL Query Cache doesn't always respect the query rules for some reason

I use ProxySQL (2.0.17) to cache all SELECT queries sent to MySQL. The mysql_query_rules table looks like…
gamasexual
  • 1,267
  • 2
  • 8
  • 9
1 2
3
4 5