RE: [PHP] mysql replication + mysql_pconnect
| From: | Dan Rossi | Date: | Sun, 02 Mar 2003 08:57:43 +0000 |
| Subject: | RE: [PHP] mysql replication + mysql_pconnect | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-137769@lists.php.net to get a copy of this message | ||
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:rich@f1central.net]
Sent: Sunday, March 02, 2003 12:34 PM
To: electroteque; php-general@lists.php.net
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