Announcement

Collapse
No announcement yet.

Failover to the Mirrored Mirth Database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Failover to the Mirrored Mirth Database

    Hi,

    Is there a way for the Mirth Connect server to failover to a mirrored Mirth database?

    I've tried the following Mirth Database string without success.
    In Mirth Connect Server Manager under the Database tab (See Attachment):
    URL
    jdbc:jtds:sqlserver://PrimaryServer:1433;DatabaseName=mirthdb;failover Partner=MirrorServer:1433

    Mirth version 3.4.2.8129
    Java ver: 1.8.0_111

    Cheers
    Attached Files

  • #2
    I don't know about that specific SQL Server connection URL setting. I do know that our appliances satisfy this. We support PostgreSQL replication and automatic failover with a database virtual IP. But it's something that the appliance does, not Mirth Connect per se.
    Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

    Nicholas Rupley
    Work: 949-237-6069
    Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


    - How do I foo?
    - You just bar.

    Comment


    • #3
      Does jtds support the use of "failover Partner=MirrorServer:" in the connection string?
      Best,

      Kirby

      Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

      Appliance Version 3.11.4
      Mirth Connect Version 3.8.0
      Java Version 1.6.0_45-b06
      Java (64 bit) Version 1.6.0_45-b06
      Java 7 (64 bit) Version 1.7.0_151-b15
      Java 8 (64 bit) Version 1.8.0_181-b13
      PostgreSQL Version 9.6.8

      Comment


      • #4
        Originally posted by kirbykn2 View Post
        Does jtds support the use of "failover Partner=MirrorServer:" in the connection string?
        I would guess not. But I'd imagine the official Microsoft driver supports it: https://technet.microsoft.com/en-us/...=sql.105).aspx

        You can download their driver here: https://www.microsoft.com/en-us/down....aspx?id=11774
        Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

        Nicholas Rupley
        Work: 949-237-6069
        Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


        - How do I foo?
        - You just bar.

        Comment


        • #5
          FYI

          http://www.mirthcorp.com/community/f...highlight=arun
          HL7v2.7 Certified Control Specialist!

          Comment


          • #6
            Seems like you'd have to build a HA postgresql cluster, and connect to the VIP of that...

            https://github.com/smbambling/pgsql_...greSQL-Cluster

            Comment


            • #7
              Thanks for all the replies.
              In regards to using the Microsoft driver, where do I put the code to detect if the Mirror SQL has changed its role to Principal?
              The Mirth Connect Server sits on a different server to the SQL servers. If the MirthDB (stores channels, transformers,HL7 messages...) is not reachable, Mirth freezes. I cannot find other sections in the Connect Server Manager to add more code to try a different SQL server with a backup copy of MirthDB.
              Please let me know otherwise.

              Comment

              Working...
              X