Or you could (if the two db servers are on the same lan) place a load ballancer before them and the php connection wouldn't really care because the two will look like one...;) Or you could write a connector script that checks the 'health' of each server and then return the connect for that one. cheers, mikel Anna wrote: > ---- Original Message ----- > From: "MB" <[EMAIL PROTECTED]> > > > Hi all, > > I use replication on MySQL. One of my ideas is to generate HTML pages > > using PHP. > > Will I have any troubles using PHP and connecting simultaneously to both > > servers? > > Thanks in advance for any comments. > > > > Mariusz Brzezinski > > No. > As long as you give them different names. :-) > $connectionLocal=mysql_connect(bleah, bleah, bleah); > $connectionOther=mysql_connect(bleah, bleah, bleah); > > Then in any mysql_query you must, of course, specify > which connection you are using. > > Anna > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
