0
votes
1answer
35 views

HAProxy's Flooding MySQL Connections

I have a setup of 2 HAProxy servers using the KeepAlived process for failover, and each HAProxy is configured to load balance mysql connections to my MariaDB Galera cluster of 3 nodes. I'm trying to ...
1
vote
1answer
84 views

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and ...
0
votes
0answers
73 views

High availability MySQL with HA Proxy failover

I am looking to load balance a Percona cluster behind two HA Proxy nodes with failover (using keepalived) so there is no single point of failure. I have HA Proxy already setup with keepalived using a ...
2
votes
2answers
60 views

HAProxy mysql write failover

I have an HAProxy server load balancing two mysql servers that are in master-master / active-passive mode. I can see that I've successfully scaled all READS to my two database nodes, but how would I ...
0
votes
1answer
103 views

Setting Up a Load Balancer on VPS with Replication

I'm looking for some expert advice on how to go about setting up a load balancer across a VPS, configuring two other VPS for PHP/MySQL replication and then linking them together. I've looked into ...
1
vote
2answers
164 views

Using proxy server to redirect MySQL traffic to multiple servers using standard port?

Is it possible to redirect MySQL (tcp) traffic to multiple servers based on domain name alone? Our DNS is setup to point several sub-domain aliases to one proxy machine. (running haproxy and ...
0
votes
0answers
49 views

Percona XtraDB cluster not replying to queries

Since last month, suddenly our percona cluster started to have connection issues as discussed in Percona Cluster Failed with Haproxy : Connection Limit Exceeded question. As @RolandoMySQLDBA ...
0
votes
0answers
190 views

HAProxy and MySQL Server Timeout

I have load balanced HAProxy/MySQL/Galera cluster set up and I am having a little trouble with disconnections. I keep getting a "No connection. Trying to reconnect..." after my MySQL client idles for ...
0
votes
1answer
78 views

How to get HAproxy to return next db server's ip address?

I'd like to use HAproxy for checking if my db servers are online, without actually routing the requests through the HAproxy box. Is there any way I can connect to HAproxy and have it return a DB host ...
0
votes
1answer
679 views

HAProxy + Percona XtraDB Cluster

I am attempting to setup HAproxy in conjunction with Percona XtraDB Cluster on a series of 3 EC2 instances. I have found a few tutorials online dealing with this specific issue, but I am a bit stuck. ...
0
votes
1answer
198 views

HAProxy MySQL Failover is not starting

I am trying to setup HAProxy with MySQL failover with Ubuntu. I used a setup similar to this serverfault question, however I am getting the following error when starting haproxy: [ALERT] 341/220001 ...
4
votes
1answer
1k views

HAProxy, client timeouts when connecting from JDBC pool

I have a webapp (Tomcat/Hibernate/DBCP 1.4) that runs queries against MySQL, and this works fine for a certain load, say 50 queries a second. When I route the same moderate load through HAProxy (still ...
3
votes
2answers
1k views

HA Proxy for MySQL - Failover only

I am interested in using HA proxy as a failover/load balancer in our MySQL environment. We have a master-master + 2 slaves setup. I would like for the master/master setup, even though they are setup ...
5
votes
1answer
2k views

Load balancing MySQL using HAProxy: Got an error reading communication packets?

I've set up load balancing MySQL slaves using HAProxy via a xinetd. 2 load balancers shared a virtual IP that is managed by Pacemaker: crm configure show: node SVR120-27148.localdomain node ...
0
votes
1answer
411 views

Monitoring MySQL replication through HAProxy Xinetd service

I have have set up MySQL multi-master replication with HAProxy as a load balancer following Alex Williams' tutorial found here; ...
3
votes
1answer
889 views

HAproxy with MySQL Master-Master Replication incredibly slow

I have two MySQL servers in multi-master mode, with an HAproxy machine for simple load balancing/redundancy. When I am connected to one of the servers directly and try to update about 100,000 entries, ...
1
vote
1answer
161 views

Trace what Application is Going through HAproxy

I have this setup where several applications are going through the load balancer (HAproxy) and accessing the MySQL database. Several applications -> HAproxy -> MySQL database I would like to ...
0
votes
3answers
1k views

Apache with mod_php high memory utilization

We have Magento application deployed on Apache with mod_php and mysql. I have observed that sometime apache server starts consuming high memory which causes memory swapping and results in high load on ...
6
votes
1answer
3k views

Pacemaker Active/Active haproxy load balancing

I am using Haproxy to load balance replicated mysql master servers. I am also using Heartbeat and Pacemaker for Active/Active ip failover with two virtual ips on the two load balancers for web server ...
4
votes
4answers
4k views

Haproxy mysql failover load balancing

I have setup mysql master-master replication and now I am trying to load balance mysql servers with Haproxy. Load balancer: 192.168.1.5 mysql1: 192.168.1.7 mysql2: 192.168.1.8 The below haproxy ...
2
votes
1answer
2k views

ERROR 2013 when connecting to mysql via HAProxy

I am trying to use HAProxy as a load balancer for 2 mysql nodes. I have HAProxy listening on 3307 and it routes requests to the DBs on 3306. When the client is trying to connect to the Proxy (mysql -u ...
0
votes
1answer
474 views

Best MySQL failover and load-balancing for shared hosting environment [closed]

I am creating a shared hosting environment, load balanced and HA. HTTP/HTTPS is okay as well as the distribution of files (code and file uploads) between the servers. The last thing remaining is to ...
0
votes
2answers
179 views

Load balancer, file merging & mysql

So I have three rack servers here, the main one connected to the WWW and has a public ip, its running HAProxy set up to point to the other two servers. The other two are running apache which a cron ...
1
vote
1answer
341 views

High Availability Mysql without virtual IP

I am trying to design a simple high availability system for our production system at the mysql level. From what I have read so far, the best solution is to set up master-master replication. ...
2
votes
0answers
676 views

HAProxy + MySQL Slaves, random lost connections

The Setup Right now I've got set up 3 MySQL Servers (5.1.x, on RHEL5), one Master and two Slaves. Last week I added a load balancer (HAProxy) for some services, and thought I'd experiment with using ...