Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-43873

Support SQL Server AlwaysOn Availability Groups with Microsoft JDBC driver

    XMLWordPrintable

    Details

    • UIS:
      5
    • Support reference count:
      27
    • Current Status:
      Hide
      Atlassian Update – 14 February 2018

      Hi everyone,

      The suggestion is now resolved. Please take the following notes to consideration when relying on the Availability groups while using Jira:

      • Jira 7.5.0 and later is shipped with the Microsoft jdbc driver 6.2.1 and is compatible with Microsoft AlwaysOn availability groups.
      • We can not test Microsoft AlwaysOn availability groups because our testing is limited to Jira's operating in standard conditions with Microsoft databases.
      • Some of our customers successfully use the availability group though we are not officially supporting this configuration.

      Hope this clarifies the status, please don't hesitate to share your feedback in issue comments.

      Cheers,
      Ignat Alexeyenko
      Jira Bugmaster

      Show
      Atlassian Update – 14 February 2018 Hi everyone, The suggestion is now resolved. Please take the following notes to consideration when relying on the Availability groups while using Jira: Jira 7.5.0 and later is shipped with the Microsoft jdbc driver 6.2.1 and is compatible with Microsoft AlwaysOn availability groups. We can not test Microsoft AlwaysOn availability groups because our testing is limited to Jira's operating in standard conditions with Microsoft databases. Some of our customers successfully use the availability group though we are not officially supporting this configuration. Hope this clarifies the status, please don't hesitate to share your feedback in issue comments. Cheers, Ignat Alexeyenko Jira Bugmaster
    • Feedback Policy:
      We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Description

      Summary

      As per JIRA 7.4 Supported Platforms, JIRA supports Microsoft SQL Server databases using the latest JTDS JDBC driver. This driver however doesn't support SQL Server AlwaysOn Availability Groups.

      Microsoft JDBC driver, on the other hand, supports AlwaysOn Availability Groups but is not mentioned in the Supported Platforms. 

      Thus, it's unclear whether AlwaysOn Availability Groups is not supported or Microsoft JDBC driver is not supported.

       This may be related to the fact that Clustered Databases are not officially supported.

      Suggestion

      It should be well documented whether Microsoft JDBC driver is supported or not, regardless of whether AlwaysOn Availability Groups is supported. For example Bamboo currently supports Microsoft JDBC driver.

      Moreover, since Clustered Databases are being used more popularly nowadays, and we offer Data Center solutions for a similar objective of High Availability, it would be great that Clustered Databases are supported by JIRA (and other Atlassian products).

       JIRA currently works well with SQL Server AlwaysOn when using Microsoft JDBC driver, however this is not officially tested by Atlassian.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              wthompson Wazza
              Reporter:
              ckimloong Chin Kim Loong (Inactive)
              Votes:
              21 Vote for this issue
              Watchers:
              31 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: