PHP Connection Strings
Posted
by Campo
on Server Fault
See other posts from Server Fault
or by Campo
Published on 2010-04-21T16:52:42Z
Indexed on
2010/04/21
17:03 UTC
Read the original article
Hit count: 415
I have setup mirroring on my MSSQL server it is an automatic fail over.
Lets say the SQL server goes down. I have found connection strings to reconnect the site to the mirror database for MSSQL 2008
Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;
OR
Provider=SQLNCLI10;Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;
OR
Driver={SQL Server Native Client 10.0};Server=myServerAddress;Failover_Partner=myMirrorServerAddress;Database=myDataBase; Trusted_Connection=yes;
Is there something similar I can use for PHP to do the same sort of thing. This way if only the database goes down the site instantly fails over to the mirror database as soon as it is online.
Thoughts/Suggestions/Comments All appreciated.
I checked connectionstring.com but did not find a section for PHP
© Server Fault or respective owner