MySQL Forums
Forum List  »  General

MySQL settings for multiple server setup
Posted by: Mike Maddison
Date: March 18, 2009 01:38PM


I think I've seen information on this before but I'm not sure what the right combination is to find it in the documents.

I am setting up Master-Master replication (already know how to do this part fine) for 2 dedicated MySQL Servers.

I am also setting up 2 dedicated apache/PHP webservers.

I'm looking to find the easiest way to set up the webservers to automatically query either of the MySQL servers.

IE, normally PHP scripts have a config file that says
Database = localhost;
username = whatever;
password = somepass;

Is it possible to setup a MySQL connection from the webservers that will automatically pass the "localhost" queries onto the mysql servers?

Also, if either of the 2 MySQL servers are unavailable, will this be seamless to the webservers?

If anyone can point me to the correct documentation or at least give me the proper terminology for this so I can find it myself that would be luscious.


Options: ReplyQuote

Written By
MySQL settings for multiple server setup
March 18, 2009 01:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.