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.