Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [haproxy]

16 questions
3
votes
1 answer

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 user haproxy group haproxy …
gzc
  • 323
  • 1
  • 4
  • 13
2
votes
1 answer

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 promote slave in case of failure. Now we want to…
Gagandeep Singh
  • 21
  • 2
2
votes
0 answers

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 app we're using here, but we use Tableau (some…
Mauricio Cacho
  • 520
  • 3
  • 13
1
vote
0 answers

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. I have 3 nodes, I will use these IPs for the sake…
Gábor Major
  • 163
  • 1
  • 7
1
vote
1 answer

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 problem generally handled in this setup? Is there a…
DMin
  • 163
  • 6
1
vote
2 answers

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 balance roundrobin server mongo1…
user128113
  • 11
  • 1
  • 2
1
vote
2 answers

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 situation? I guess the question I'm asking is -…
user3890702
  • 11
  • 2
0
votes
0 answers

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 the crash. Is it possible that all nodes crashed…
Lucas Rasolofoniaina
  • 103
  • 1
  • 9
0
votes
1 answer

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, balanced/failover arranged through haproxy (tcp…
Thomas van Hesteren
  • 1
  • 1
0
votes
1 answer

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 --sort=-%mem | head -30 USER PID %CPU…
Argha
  • 1
  • 3
0
votes
0 answers

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 its Ip (lets say 192.168.0.1) to the ips of the sql…
Nikita Voevodin
  • 1
0
votes
1 answer

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 working to an extent. My HAProxy configuration…
Argha
  • 1
  • 3
0
votes
1 answer

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 distribute the load. I get "server closed the…
user3443757
  • 101
  • 1
  • 3
0
votes
1 answer

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-over with this. However, write requests to be routed to…
gnyanendra
  • 1
  • 2
0
votes
2 answers

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 is when there is a heavy write situation as …
dragon
  • 95
  • 1
  • 1
  • 7
1
2