As of May 31, 2023, we have updated our Code of Conduct.

Questions tagged [proxysql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
99 views

Setup proxysql read-write split with both galera cluster and master slave replication

I have the following setup: Three node galera cluster (galera-1, galera-2, galera-3) galera-2 is master to slave-1 (master-slave replication) slave-1 is master to both slave-2 and slave-3 slave-1, ...
supercoco's user avatar
  • 121
0 votes
0 answers
55 views

How to make sure that SELECT mirroring rule is working in ProxySQL?

I have following servers: Admin> SELECT * FROM mysql_servers; +--------------+-----------------------------------+------+-----------+--------+--------+-------------+-----------------+---------------...
Dmitrij Kultasev's user avatar
0 votes
1 answer
130 views

Unable to find variable : mysql-monitor_username in global_variables table in information_schema database in MySQL

I am trying to perform the initial configuration in proxysql and I found that while doing the Configure monitoring, I am unable to find the variable mysql-monitor_username in the global_variables ...
msbeast's user avatar
  • 11
0 votes
1 answer
137 views

How to set the 'source address' ProxySQL uses to connect to MariaDB?

I'm deploying ProxySQL on Docker. When I try connecting to my database via ProxySQL, MariaDB rejected my login attempt as follows: Access denied for user 'usarr'@'172.18.0.1' (172.18.0.1 is the ...
pepoluan's user avatar
  • 187
3 votes
2 answers
2k views

How to avoid replication lag in case all writes on master and reads on replica?

I have stuck with the replication lag problem. I am trying to refactor my DB infrastructure. The first step was read-write split. I used ProxySQL то implement it. Now I have masterDb where all INSERT ...
Volodymyr Bilovus's user avatar
1 vote
1 answer
402 views

Proxysql setup for Percona PXC Multimaster cluster

I have a clean Ubuntu lab setup for PXC Cluster and Proxysql (each a separate VM)and i'm seeing this issue (error below). Is there a specific installation that needs to be followed for PXC cluster? I ...
Storm's user avatar
  • 11
1 vote
1 answer
175 views

mysql client auto reconnect in case of ERROR 2013

I'm searching for a way how to instruct mysql client to reconnect in case of ERROR 2013. I'm testing PXC with ProxySQL and want to keep sql statements flowing from the client in case when the writer ...
Sevak's user avatar
  • 11
0 votes
1 answer
108 views

Is there a way of securing ProxySQL's own SQLite3 database?

As I understand ProxySQL has support for SSL encryption for inbound and outbound traffic (front/backend) and supports password hashing. However back in 2017, one had direct database access: How to ...
Eduardo A del Corral Lira's user avatar
1 vote
1 answer
239 views

MySQL replication and ProxySQL

I just came across ProxySQL. I have one simple question, if I were to use ProxySQL, do I still need to set up Replication(master-slave) first for MySQL server? Because there is hostgroup(0,1) in ...
kleorence baker's user avatar
0 votes
1 answer
38 views

garbd with proxysql and mysql replication

Can be configured garbd with proxysql + MySQL Replication?, I installed proxysql with 1 master and two slaves using MySQL replication but I was disputed about to connect garb with proxysql how I was ...
Iori_Yagami's user avatar
2 votes
2 answers
2k views

Mysql: Is it possible to handle 1000 concurrent while having low cpu? [closed]

We're running Centos 7, we're in the process Mariadb 5.5, upgrading to 10.3 today. PHP 5. The queries are bad, and there are far too many of them to optimize, but I'm trying what I can, the database ...
Lynob's user avatar
  • 159
0 votes
2 answers
261 views

PROXYSQL configuration over mysql galera replication [closed]

can I have same databases connected to two different proxysql configuration?
SK ASIF RAJA HAMZA's user avatar
0 votes
0 answers
238 views

ProxySQL and MySQL cluster

This article describes the set-up of MySQL cluster with one cluster node, two data nodes and one MySQL server. This article describes the configuration of ProxySQL where, MySQL servers are added into ...
cogitoergosum's user avatar
0 votes
1 answer
323 views

How to cache inserted data with ProxySQL to avoid delays

we are using MariaDB 10.2 with Galera plugin. Cluster consists of 4 nodes - 3 are busy service complex queries and 1 is more for a backup. Recently we came across ProxySQL and this sounds very ...
Anton Aleksandrov's user avatar
0 votes
1 answer
734 views

Is it possible to setup MySQL replication through ProxySQL?

We currently have replication working through haproxy so that if a node goes down replication continues with one of the other nodes. We're trying to completely replace haproxy with proxysql. Due to ...
Chris Batchelor's user avatar
0 votes
0 answers
191 views

Reading from two shards using ProxySQL

I have a table that has been sharded between two machines, and the same table on each machine holds different data (not replicated). With ProxySQL, how can I create a mysql_query_rule that allows a ...
giogio's user avatar
  • 23
0 votes
0 answers
1k views

Is ProxySQL Suitable for Connection Pooling Apps?

I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up? I've found ...
Hexodus's user avatar
1 vote
0 answers
452 views

MHA vs Orchestrator

Im going to setup an HA solution. Im planning to use Orchestrator. But seems MHA is also doing well. If anyone already used/using any one these solutions, please suggest me to choose a right one ...
TheDataGuy's user avatar
  • 1,860
0 votes
1 answer
118 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
behnamy01's user avatar
1 vote
2 answers
2k views

ProxySQL user not connecting - XtraDB

I'm trying to set up a xtraDB Cluster consisting of 3 nodes. Now i've got the cluster up and running and per the instructions i'm trying to set up ProxySQL for load balancing. So i've installed ...
Jdeboer's user avatar
  • 21
0 votes
1 answer
527 views

Is good idea to implement ProxySQL in production with Docker?

The idea is to have solution with ProxySQL to give high availability solution with docker implementation? But this question maybe not have sense, I am to investigate alternative solution without VIP ...
Nicola Strappazzon's user avatar
2 votes
1 answer
755 views

ProxySQL equivalent of MaxScale schemarouter

background My employer developed a web application we provide on software-as-a-service terms to our customers. To allow for multiple customers with a huge mass of data to be stored in a database, we ...
Phillip -Zyan K Lee- Stockmann's user avatar
6 votes
4 answers
7k views

How to easily bring 80 MySQL users into ProxySQL?

I am setting up ProxySQL in front of a Percona MySQL server with 88 user accounts. I don't even know most of their passwords. Passwords are stored in MySQL as hashes but are stored in ProxySQL in ...
IcarusNM's user avatar
  • 581