i'll explain i need a fallbak method where if the master server is down it will goto the slave i assumed the connection could do this automatically but it doesnt therefore requires it setup in the php connection script ,
part of my db class $this->connection = @mysql_pconnect($host,$user,$pass); say host is localhost:3308 it will still connect to the master on 3306 , or even localhost:3307 which is the slave it will still get the master server , i turn off the master server and i get this localhost:3307Can't connect to local MySQL server through socket '/usr/local/etc/mysqlmaster/tmp/mysql.sock' (2) where 3307 is the slave , one thing though , i have this in my php configure '--with-mysql=/usr/local/etc/mysqlmaster' ' is that a problem ? -----Original Message----- From: Rich Gray [mailto:[EMAIL PROTECTED] Sent: Sunday, March 02, 2003 12:34 PM To: electroteque; [EMAIL PROTECTED] Subject: RE: [PHP] mysql replication + mysql_pconnect > hi there i am setting up a test replication slave server as a mysql db > master backup if it fails , i would like to know how to > dynamically connect > to the slave if the master fails , something really strange i have set the > host like localhost:3307 for the slave but is still connecting to > the master > , and if i shut down the master it wont goto the slave :| > > Not sure I understand ... are you saying that mysql_connect('localhost:3307','user','password') connects to the master server? Can you describe the problem in more detail? Rich -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
