locked
Sql Server Mirroring and apache web server RRS feed

  • Question

  • 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 string.


    A.G

    Sunday, June 21, 2015 4:09 PM

Answers

  • 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


    Lydia Zhang
    TechNet Community Support


    Monday, June 22, 2015 7:17 AM

All replies

  • This may help you.


    Please Mark Answer if it solved your issue, Vote As Helpful if it helps to solve your issue

    Monday, June 22, 2015 1:09 AM
  • 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


    Lydia Zhang
    TechNet Community Support


    Monday, June 22, 2015 7:17 AM
  • Hi. 

    Thanks for your reply.

    We added Failover_Partner in our connection string and still had the same problem. interestingly even when the mirroring is not setup and we have Failover_Partner  in connection string, we receieve the same error message.


    A.G

    Thursday, July 16, 2015 1:28 AM
  • Are you using the Microsoft Drivers for PHP?


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Friday, July 17, 2015 1:06 AM