Questions tagged [haproxy]

The tag has no usage guidance.

12 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
355 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 ...
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 ...
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 ...
0
votes
0answers
158 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
97 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
366 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
23 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
286 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 ...
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
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
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 ...