RE: [PHP] mysql replication + mysql_pconnect
i have worked out the issue , here is my dynamic connection to the slave , port does not work i suggest this is a bug ? localhost:/usr/local/etc/mysqlslave/tmp/mysql.sock this connected to the slave on 3307 fine -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
RE: [PHP] mysql replication + mysql_pconnect
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
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
[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 :| -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL replication
Andi, No personal experience (yet), but there's a good article on phpbuilder that you might want to take a look at if you haven't already: http://www.phpbuilder.com/columns/tanoviceanu2912.php3 Regards, Sean -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] MySQL replication
Hey, Have any of you guys worked with the latest and greatest MySQL replication? Does it work? What are its ups and downs? Andi -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]