Questions tagged [haproxy]
The haproxy tag has no summary.
16 questions
1 vote
0 answers
93 views
How to prevent PostgreSQL logging Patroni health check connections?
I have PostgreSQL 15.2 from the Percona repo, along with Patroni 3.0.1 as management tool, HAProxy 2.5.11 for proxying and PGBouncer 1.18.0 as server side pool and keepalived 2.1. for the virtual IP. ...
- 163
0 votes
0 answers
138 views
Galera Cluster MariaDB down due too high CPU
We have 3 nodes of MariaDB Galera Cluster runing with 2 HAproxy for loadbalancing. Recently, all 3 nodes of MariaDB crashed . I noticed that CPU was really high like 99% or 100% on the 3 nodes before ...
0 votes
1 answer
198 views
MySQL Group replication failover detection while node is recovering
I'm trying to get a solid MySQL group replication load balancing / failover set-up. Currently I use keepalived to share one private IP to connect to the loadbalanced MySQL GROUP REPLICATION cluster, ...
1 vote
1 answer
2k views
HAProxy + Patroni - Configure reads from a master when no slaves available
I have a HAProxy + Patroni setup with split reads and writes. The problem is, when both my replicas go down, only my writes are supported, the reads stop because both replicas are down. How is this ...
- 163
1 vote
1 answer
2k views
PostgreSQL High Memory consumption
We have been getting a lot of issues pertaining memory consumption in Postgres. I am thinking of deploying PgBouncer to resolve this issue, but wanted to know what could be the cause for this. ps aux -...
- 11
0 votes
0 answers
190 views
MySQL cluster with HAProxy balancer outside of local network
I am building a mysql cluster on local network. I have 3 nodes and would like to load balance them using HAProxy. It works fine when I place HAProxy on one of my nodes inside of the network. I bind ...
0 votes
1 answer
1k views
PostgreSQL HA using HAProxy and Patroni
I am currently trying to deploy Load Balancing using HAProxy for my PostgreSQL cluster (used Patroni HA solution). Now, I have been able to successfully implement the setup and Load Balancing is ...
- 11
2 votes
1 answer
1k views
Mariadb master master replication supported by HAPROXY for automatic failover
We have implemented master-master setup in maria-db. Master A is being used for read\write and Master B is used for backups and MIS operations. We have built this setup so that we do not need to ...
0 votes
1 answer
3k views
Load Balancing PG Bouncer With HA Proxy
I have a server with two instances of PG Bouncer running on different ports. Both are using session mode to pool. I set up HA Proxy to load balance incoming connections between these two processes to ...
- 101
0 votes
1 answer
1k views
Managing failover for MySQL nodes using HA Proxy
We have an S1<-M1<->M2->S2 setup of MySQL replicated nodes. These are now to be brought to the back-end of an HA Proxy server to split read from writes. We also intend to achieve automatic fail-...
1 vote
2 answers
4k views
How to load balance mongodb replica cluster
I have created a mongod replica cluster of 2 nodes , mongo1 and mongo2. to load balance I have added following rule in my haproxy listen mongo_replica_cluster bind *:27017 mode tcp ...
- 11
0 votes
2 answers
1k views
What to do in times of data inconsistency in Master-Master Replication in MySQL?
I am building an architechture consisting MySQL Master-Master replication with HAProxy in its front. For HAProxy i am using round_robin algorithm to distribute loads between two masters. My question ...
- 95
3 votes
1 answer
8k views
Haproxy + Mysql Lost connection to MySQL server during query
I have setup a master-slave replication and added a haproxy before them. #HA-Proxy version 1.4.24 global log /dev/log local0 log /dev/log local1 notice chroot /var/lib/haproxy ...
- 323
2 votes
0 answers
5k views
Configure HAProxy to load balance Postgresql
I'm trying to load balance between servers running Postgresql (Master-Slave configuration with Streaming Replication). First I've tried setting up PgPool-II, and it worked fine when I connected some ...
- 520
0 votes
1 answer
86 views
Is it ok to use 4 application server against one database server?
Initially I have two database server (Master Master Replication config with Haproxy load balancing) A and B. And two application server say P and Q. Both P and Q is pointed towards A will move to B ...
- 203