PHP Connection Strings
- by Campo
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
