Results 1 to 2 of 2
-
04-28-2014, 08:14 AM #1Web Hosting Master
- Join Date
- May 2009
- Location
- Greece
- Posts
- 1,047
Load balancing Mysql servers using Haproxy
Hello
I just install haproxy in front of mysql cluster servers and the only working config (as it is not the same as the balancing on web servers) is this:
Code:global log 127.0.0.1 local0 chroot /var/lib/haproxy pidfile /var/run/haproxy.pid maxconn 4000 user haproxy group haproxy daemon listen stats serverownip:1936 mode http log global maxconn 10 clitimeout 100s srvtimeout 100s contimeout 100s timeout queue 100s stats enable stats hide-version stats refresh 30s stats show-node stats auth admin:password stats uri /stats listen MySQL 0.0.0.0:3306 timeout connect 10s timeout client 1m timeout server 1m mode tcp server database1 ipofserver1:3306 check server database2 ipofserver2:3306 check
Can you please post your config (ONLY if you use it for mysql balancing) please or comment on my config?
Thank you
-
04-28-2014, 02:48 PM #2Disabled
- Join Date
- Feb 2005
- Posts
- 37
Hello,
have used haproxy as frontend to mysql but it was not the best solution since it was not sending every query to the nodes. Especially on writes. I would use something else. Maybe mysqlproxy or some other load balancing solution.
Similar Threads
-
Load Balancing 2 Web servers and 2 MySQL Servers
By YYamagishi in forum Hosting Security and TechnologyReplies: 11Last Post: 03-30-2008, 03:46 AM -
HAproxy - Quick and Dirty HTTP Load balancing Tutorial on Redhat/Centos
By Steven in forum Hosting Security and Technology TutorialsReplies: 0Last Post: 08-14-2007, 02:03 AM -
Need: Linux, Apache, Load Balancing, MySQL Genuis to Help Admin High Traffic Servers
By roygbiv in forum Employment / Job OffersReplies: 5Last Post: 03-04-2006, 01:26 PM -
Need: Linux, Apache, Load Balancing, MySQL Genuis to Help Admin High Traffic Servers
By roygbiv in forum Employment / Job OffersReplies: 5Last Post: 10-13-2005, 01:45 PM -
Need: Linux, Apache, Load Balancing, MySQL Genuis to Help Admin High Traffic Servers
By floogy in forum Employment / Job OffersReplies: 4Last Post: 07-08-2005, 07:25 PM