Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013

    Question MySQL Cluster with Load Balance


    We have 2 node mysql cluster. Both node connected to HAProxy at front. HAProxy is set as round robin.

    The problem is, when query more than 1000 transaction error lost connection to MySQL come out.

    Please give some advice.


  2. #2

    I also had that problem with HAproxy and I haven't been able to fix it no matter how high I have set the maxconn value.

    I suggest to try out mysqlproxy or some other load balancing solutions. I can also recommend pfsense.

Similar Threads

  1. what is the difference between cluster and load balance ?
    By ttgt in forum Hosting Security and Technology
    Replies: 1
    Last Post: 04-11-2012, 01:31 PM
  2. Replies: 0
    Last Post: 06-14-2010, 08:43 AM
  3. Replies: 0
    Last Post: 05-25-2010, 03:35 AM
  4. How long to setup a load balance cluster
    By registercheaper in forum Dedicated Server
    Replies: 1
    Last Post: 04-08-2006, 12:00 AM
  5. Replies: 0
    Last Post: 08-17-2004, 11:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts