A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [proxysql]

The tag has no usage guidance.

9 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
253 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
21 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
11 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
11 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
46 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
188 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
64 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
417 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 ...
0
votes
1answer
75 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 ...