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: 410

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

Related posts about php

Related posts about sql-server-2008