Questions tagged [haproxy]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
23 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 ...
0
votes
0answers
166 views

HAPROXY for Postgres Failover Master/Replica

I have successfully set up a postgres master-replica with repmgr for automatic failover which can be found over here https://github.com/mgonzaga1990/pg-rpi-failover Now what I'm planning to do next is ...
0
votes
1answer
100 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 -...
0
votes
0answers
386 views

PSQLException: An I/O error occurred while sending to the backend

We are using PostgreSQL 11 wherein intermittently the below exception is popping up, causing our application to lose connection with the database. It isn't connecting until the application is ...
0
votes
0answers
9 views

MariaDB uses HAProxy IP instead of the WebServer IP

I have a HA Setup that goes like this: I made a user for the web server: grant all on user_db.* to 'db_user'@'10.10.10.26' identified by 'password'; But when I try to access it via this command: ...
0
votes
0answers
24 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
1answer
288 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 ...
2
votes
1answer
366 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
1answer
1k 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 ...
0
votes
1answer
676 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-...
0
votes
1answer
3k 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 ...
0
votes
2answers
638 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 ...
1
vote
0answers
5k 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 ...
2
votes
0answers
4k 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 ...
0
votes
1answer
65 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 ...
1
vote
2answers
1k 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 ...