MySQL Forums :: General :: MySQL settings for multiple server setup

Advanced Search

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

Subject Written By Posted
MySQL settings for multiple server setup Mike Maddison 03/18/2009 01:38PM
Re: MySQL settings for multiple server setup Rick James 03/19/2009 11:25PM

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.