Hi Everyone,

We migrated a database from MySql to Sqlserver 2008. The application is php and apache is in use. The migration was successfull, but when I setup mirroring for that database, Apache started to crash with following error message:

child pid 2059 exit signal Segmentation fault (11)

After I killed the mirroring, the apache started to work normally. Is there any conflict between Apache and Sql mirroring?Is there any setting that I should apply on my connection s

This may help you.

Hi Mourmansk,

According to my knowledge, there is no conflict between Apache and SQL Server mirroring.

When using SQL Server database mirroring, in addition to the initial partner name and database name,  the failover partner name (which identify the current mirror server instance) should also be specified in the connection string. In this case, when a database mirroring failover occurs, the application will redirect connections.

Besides, regarding to the issue that Apache crashes, I would recommend you post the question in the Apache forum. It is appropriate and more experts will assist you.

For  more details about database mirroring, please review the following articles.
Using Database Mirroring
SQL Server 2008 connection strings

Thanks,
Lydia Zhang