LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-14-2013, 08:19 PM   #1
Vishal Koul
LQ Newbie
 
Registered: Jun 2013
Posts: 2

Rep: Reputation: Disabled
Setting up a mysql redundancy/cluster in Linux


I found some real good articles on Mysql load balancing on web but being a new bee could conclude nothing

I have this requirement where my webapplication running on a tomcat is behind a loadbalancer and I am planning to deploy this application on multiple servers.
This webapp though needs a database ( mysql ) for managing profile and other similar stuff, now i can only have a single master database to which all my FE servers connect and I want all my front end servers to talk to this database. obviously if I do this it becomes my single point of failure , hence the need to run a cluster/redundancy

please guide me on same. my requirement though becomes a little more complicated something which i couldnt find in any articles is because i need a single IP to make connection. Below is the example of how the server.xml is configured in my environment when it talks to single DB
==================================================================================================== =====================
<Resource name="jdbc/master" auth="Container" type="javax.sql.DataSource" maxActive="10"
maxIdle="10" validationQuery="SELECT 1" testOnBorrow="false" testWhileIdle="true" validationQueryTimeout="5"
timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000" maxWait="10000"
username="XXXX" password="XXXXX" driverClassName="com.mysql.jdbc.Driver" removeAbandoned="true"
removeAbandonedTimeout="60" logAbandoned="true" url="jdbc:mysql://localhost:53306/master?autoReconnect=true" />
==================================================================================================== =====================
Now only thing I can replace is the URL but how is the question. and what should be the localhost pointing to.
Really appreciate any reposnse from this forum. please feel free to ask me any information you feel i havent suplied , I dont mind anyone suggesting me an alternative approach to my problem but please note i can't change the webapp as it is a 3rd party application.

Last edited by Vishal Koul; 07-14-2013 at 08:54 PM.
 
Old 07-15-2013, 02:15 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,985

Rep: Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315Reputation: 4315
Quote:
Originally Posted by Vishal Koul View Post
I found some real good articles on Mysql load balancing on web but being a new bee could conclude nothing

I have this requirement where my webapplication running on a tomcat is behind a loadbalancer and I am planning to deploy this application on multiple servers.
This webapp though needs a database ( mysql ) for managing profile and other similar stuff, now i can only have a single master database to which all my FE servers connect and I want all my front end servers to talk to this database. obviously if I do this it becomes my single point of failure , hence the need to run a cluster/redundancy

please guide me on same. my requirement though becomes a little more complicated something which i couldnt find in any articles is because i need a single IP to make connection. Below is the example of how the server.xml is configured in my environment when it talks to single DB
==================================================================================================== =====================
<Resource name="jdbc/master" auth="Container" type="javax.sql.DataSource" maxActive="10"
maxIdle="10" validationQuery="SELECT 1" testOnBorrow="false" testWhileIdle="true" validationQueryTimeout="5"
timeBetweenEvictionRunsMillis="10000" minEvictableIdleTimeMillis="60000" maxWait="10000"
username="XXXX" password="XXXXX" driverClassName="com.mysql.jdbc.Driver" removeAbandoned="true"
removeAbandonedTimeout="60" logAbandoned="true" url="jdbc:mysql://localhost:53306/master?autoReconnect=true" />
==================================================================================================== =====================
Now only thing I can replace is the URL but how is the question. and what should be the localhost pointing to.
Really appreciate any reposnse from this forum. please feel free to ask me any information you feel i havent suplied , I dont mind anyone suggesting me an alternative approach to my problem but please note i can't change the webapp as it is a 3rd party application.
The first place to start is by reading/following the MySQL Cluster Instructions:
http://dev.mysql.com/doc/refman/5.1/...iguration.html

...which tells you how to configure a MySQL cluster, complete with explanations and examples. Since you have a 3rd party application, it would also be a good idea to ask your vendor how THEY like to have such things configured, to make sure you're doing what's best for this particular setup.
 
  


Reply

Tags
cluster, loadbalancing, mysql, rhel5


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
help setting up a second server for redundancy steve51184 Linux - Server 3 04-23-2012 08:29 AM
LXer: Setting up a MySQL cluster 7.0 in Redhat based linux LXer Syndicated Linux News 0 03-08-2010 02:20 PM
LXer: Setting up a MySQL Cluster for your Linux desktop LXer Syndicated Linux News 0 11-03-2009 10:50 AM
Internet switch redundancy for high availability cluster charrois Linux - Networking 6 06-17-2008 03:06 PM
MySQL cluster - advice for setting up deadeyes Linux - Server 1 10-27-2007 05:00 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:33 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration