Skip to main content

Questions tagged [proxysql]

The tag has no usage guidance.

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
439 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
1 vote
1 answer
529 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
236 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
1 vote
0 answers
563 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,950
0 votes
0 answers
51 views

ProxySQL with multiple reader_hostgroups

I have a ProxySQL instance that is currently configured with one master and two replication slaves for basic read/write query splitting. However, I would like to configure different sets of slaves for ...
user2531657's user avatar
0 votes
1 answer
85 views

MySQL Master Slave Asynchronous GTID Replication Failover/Switchover over ProxySQL with little downtime

This is a production setup and I have to perform a failover from Master A to new potential master B. MySQL Version is 5.7 and CentOS 7 is the OS. I have a simple master slave setup with A as Master ...
Avinash Pawar's user avatar
0 votes
1 answer
193 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
143 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
0 votes
1 answer
42 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
0 votes
0 answers
282 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
791 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