Questions tagged [proxysql]
The proxysql tag has no usage guidance.
23
questions
0
votes
0answers
7 views
Can we use proxysql 2.x for load balancing multiple Galera clusters?
We have recently introduced proxysql 2.x for loadbalancing a galera cluster in production environment. It is working great so far.
I have been tasked to separate staging cluster which is currently in ...
1
vote
0answers
24 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 ...
0
votes
0answers
17 views
Can ProxySql balance load considering saturation of servers
I will be implementing a PXC Multi-master enviroment with ProxySql.
I need to know if this is doable and if it's a good approach:
Normal mode:
Node1 is primary for writes, N2 and N3 are backup_writes ...
0
votes
0answers
26 views
Will Federated engine work with pxc cluster
I'm a bit new to MySQL specific settings and I can't find any hint/insight to this question.
I have several Federated tables that work great for their current purpose, the rest of the database is in ...
1
vote
1answer
46 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 ...
0
votes
0answers
50 views
Azure mysql user connections with proxy sql
I’ve looked for a couple of days, and can’t find a definitive answer. I have an application running on a kubernetes cluster that wants to connect to an Azure Database for MySQL server via proxysql. ...
0
votes
1answer
31 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 ...
0
votes
0answers
15 views
What is the side effect of duplicate rules?
I found that some rules are stored twice in the mysql_query_rules , would this cause any problem?
Also, if I delete the duplicate rule, there would be a gap in the rule_id , would this cause any ...
0
votes
1answer
115 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 ...
0
votes
1answer
23 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 ...
2
votes
2answers
590 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 ...
0
votes
2answers
201 views
PROXYSQL configuration over mysql galera replication [closed]
can I have same databases connected to two different proxysql configuration?
0
votes
0answers
115 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 ...
0
votes
1answer
210 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 ...
0
votes
1answer
456 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 ...
0
votes
0answers
119 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 ...
0
votes
0answers
844 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 ...
1
vote
0answers
327 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 ...
0
votes
1answer
107 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 ...
1
vote
2answers
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 ...
0
votes
1answer
498 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 ...
2
votes
1answer
658 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 ...
6
votes
4answers
4k 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 ...
