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

Support SQL Server AlwaysOn Availability Groups with Microsoft JDBC driver

    XMLWordPrintable

Details

    • 5
    • 27
    • 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
    • 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

          incorporates

          Suggestion - JRASERVER-21690 Add clustered databases as supported platforms for Jira

          • Closed
          relates to

          Suggestion - JRACLOUD-43873 Support SQL Server 2012 or 2014 AlwaysOn Availability Groups

          • Closed

          Suggestion - JRASERVER-61639 Include support to SQL Server Microsoft JDBC Driver 6.0

          • Closed

          RUM-631 Loading...

          mentioned in

          Page Loading...

          Activity

            People

              wthompson Wazza
              ckimloong John Chin
              Votes:
              21 Vote for this issue
              Watchers:
              33 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: