Questions tagged [haproxy]
The haproxy tag has no usage guidance.
17
questions
0
votes
0
answers
11
views
Can i install haproxy on the same server of postgresql
I'm reading and preparing to create HA Postgresql cluster of 3 servers using patrnoi , etcd , haproxy and keeplived.
My question is - Is it ok to install HAProxy on the same servers of Postgres , or ...
0
votes
1
answer
1k
views
Patroni Haproxy and pg-bouncer
I'm building a Patroni Postgres cluster; however, I can't decide which is the better architecture:
App > HAproxy > Pgbouncer > PostgreSQL (Patroni)
App > PGBouncer > HAproxy > ...
0
votes
0
answers
64
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
109
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
934
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
0
votes
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 -...
- 1
0
votes
0
answers
137
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
772
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 ...
- 1
2
votes
1
answer
965
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
2k
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
984
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
952
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 ...
- 97
2
votes
1
answer
7k
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
...
- 293
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 ...
- 480
0
votes
1
answer
68
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 ...
- 213
1
vote
2
answers
2k
views
MariaDB Galera Cluster without HAProxy, MYSQL Proxy, etc
I'm looking to deploy a MariaDB galera cluster across three servers. However, I've noticed that the documentation often references HAProxy or the like. Does this not cause a single point of failure ...
- 11