Backend MySQL database server

Question

I'm writing a web application where the load is distributed across multiple servers that handle requests, by doing CRUD requests on database tables on a single seperate MySQL database server. One of the requirements of my application is that we want to be able to add a new server dynamically to the network of request handling server. To do this, do I need to make the database server aware of the new server or is simply giving the new server the ip address and port number sufficient?

I'm working with java servlets at the moment and I have a properties file containing the necessary information (ip, port, username, pass, dbname) to connect to a local mysql database. Do I simply change those to point to the remote db server?

madi · Accepted Answer · 2012-02-29 13:22:16Z

1

You can do a load balancing to servers. When one request is sent, the server is load balanced. Try to search for them online.

answered Feb 29, 2012 at 13:22

madi

5,6725 gold badges40 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Backend MySQL database server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related