Skip to main content

HA Proxy's Configuration For Mysql Load Balancing and Fail Over

Today Due to one of my Client Requirement i supposed to install and configure a High Availability, Proxying, Application Load Balancer for Mysql ,in the current scenario we are having two Mysql server(Both were running As Multi-Master Replication nodes) and we needed all the traffic coming from Applications should be load balance to both the Mysql server and there should be Fail-over Facility too. To achieve the goal i used an Opensource tool named HA proxy and after using it all goals seems to be achived now .

So i m sharing the steps pls go though below .

What basically HA Proxy is ??

HAProxy is an opensource free, very fast and reliable solution offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It is particularly suited for web sites,databases and Application crawling under very high loads.

Steps of Installation And configuration :-

root@linuz-akhil:~# wget -c http://haproxy.1wt.eu/download/1.2/src/haproxy-1.2.17.tar.gz

root@linuz-akhil:~# tar -zxf haproxy-1.2.17.tar.gz

root@linuz-akhil:~# cd haproxy-1.2.17

root@linuz-akhil:~# make

root@linuz-akhil:~# cp haproxy /usr/sbin/haproxy

root@linuz-akhil:~# wget -c http://layer1.rack911.com/haproxy/haproxy.init -O /etc/init.d/haproxy ## Download its script file

Create a HA Proxy config file using vim  /etc/haproxy.cfg and add below setting .

root@linuz-akhil:~# vim /etc/haproxy.cfg

###

Changes Done by tuxamit

global

maxconn     4096 # Total Max Connections. This is dependent on ulimit

daemon

nbproc      4 # Number of processing cores.

defaults

mode     http

clitimeout  60000

srvtimeout  30000

contimeout  4000

option      httpclose # Disable Keepalive

##Ip and port in which HA proxy will bind, All the Mysql traffic will be hooked to below ip and port and then HA proxy will share the traffic in round robin algo to given Mysql Servers ####

listen Mysql_proxy 10.x.x.74:3306 ##

mode tcp

balance roundrobin

###### Add you Mysql Server below ##

 server Mysql_db1 10.x.x.72:3306 check

 server Mysql_db2 10.x.x.73:3306 check

######Config Completed

root@linuz-akhil:~# service haproxy start ; chkconfig --add haproxy ; chkconfig haproxy on

All Done! Load Balancing and fail-over though HA Proxy on host 10.x.x.74 is now working fine for Mysql service listening on 3306 port at hosts 10.x.x.72 and 10.x.x.73.

Comments

Post a Comment

Popular posts from this blog

Troubleshooting Tomcat using Catalina log

Troubleshooting Tomcat using Catalina log We can get the  catalina  logs in  $CATALINA_HOME/logs Here we'll have a  catalina.out We can see some huge info in that log file. If we want to what exactly happens since the start of tomcat then we need to log that into a new file. By default we have log rotation enabled on this logs. For now let us stop tomcat and nullify the catalina.out file and then start tomcat to have some new info in the catalina.out # service tomcat stop # cd $CATALINA_HOME/logs # :> catalina.out (or) cat /dev/null > catalina.out # ll catalina.out -rw-r----- 1 root root 0 Feb 18 16:19 catalina.out # service tomcat start # ll catalina.out -rw-r----- 1 root root 17341 Feb 18 16:21 catalina.out We can see the log being written after the start of tomcat. Now we can notice the instance giving some information about the starting of tomcat, about the configuration for the startup, path of the servlet instance for which the log is re...
Post a Comment
Read more

Red Hat Enterprise Virtualization Manager RHEL 7 – Part 2

I have just published  what is RHEV  is the first article to understand RHEV Better. In order to maintain multiple RHEV-Hosts from central place RHEV-Manager is required. RHEV-M will be used as central place to manage all RHEV-Hosts. In this Article We are going to see HowTo Install RHEV-M Red Hat Enterprise Virtualization Manager RHEL 7. Red Hat Enterprise Virtualization Management (RHEV-M) is a virtual management console built on Red Hat Enterprise Linux (RHEL). It interacts with individual RHEV-Hosts using the Virtual Desktop Server Manager (VDSM). A VDSM agent is running on each of the RHEV-H nodes. RHEV-M allows administrators to manage/control number of data centers and their network, compute and storage resources. In addition RHEV-M provides a central repository for storing virtual machines, disks, images and virtual machine snapshots. Install RHEV-M Hardware Requirements Hard Disk Space Minimum 50GB RAM Minimum 4GB – Max 2TB Dual Core or High Processor 1Gb...
Post a Comment
Read more

RHVH 4.1 Installation Steps for Red Hat Virtualization Host

Red Hat Virtualization Host (RHVH 4.1) is installed using a special build ( Download Link )of Red Hat Enterprise Linux with only the packages required to host virtual machines. It uses an Anaconda installation interface based on the one used by Red Hat Enterprise Linux hosts, and can be updated through the Red Hat Virtualization Manager or via yum. Using the yum command is the only way to install additional packages and have them persist after an upgrade. In this article we are going to see RHVH 4.1 installation RHVH features a Web interface for monitoring the host’s resources and performing administrative tasks. Direct access to RHVH via SSH or console is not supported, so the Cockpit user interface provides a graphical user interface for tasks that are performed before the host is added to the Red Hat Virtualization Manager, such as configuring networking and deploying a self-hosted engine, and can also be used to run terminal commands via the  Tools > Terminal. Access t...
Post a Comment
Read more