We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
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

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

      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.

            Loading...
            IMPORTANT: JAC is a Public system and anyone on the internet will be able to view the data in the created JAC tickets. Please don’t include Customer or Sensitive data in the JAC ticket.
            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

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

                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.

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

                          Created:
                          Updated:
                          Resolved:

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

                              Created:
                              Updated:
                              Resolved: