Questions tagged [proxysql]

The tag has no usage guidance.

12 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
287 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
0answers
21 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
22 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
76 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
0answers
40 views

issues with temporary table with proxysql using mysql replication

I have the following stage, we are implementing a database with 3 nodes with proxysql, this database is using percona xtradbcluster, inside the code is created a temporary table and is successful its ...
0
votes
1answer
20 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 ...
0
votes
0answers
77 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
344 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
94 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
643 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
votes
0answers
14 views

Entire table DataMasking with ProxySQL on MySQL

I'm trying to use ProxySQL to mask data of an entire table in my MySQL database. I'm aware of masking data of a particular column in a table. Similarly, I want to mask/obfuscate an entire table (with ...