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

JIRA to support Percona DB

XMLWordPrintable

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

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Percona DB (http://www.percona.com/software) is a flavor of MySQL, however is not yet supported by JIRA. Based on earlier support cases and tests, JIRA does not work well with this database type yet.

            [JRASERVER-42012] JIRA to support Percona DB

            Nik Ambrosch added a comment -

            To be clear, percona distributes the mysql code base, so it is a mysql distribution, not a mysql flavor.  I have Jira datacenter using a three-cluster multi-master percona cluster for it's database with a copy of haproxy running locally to fool Jira into thinking there's something running locally.  It load balances the three nodes and maintains persistence.  There are better ways to do this, one of which is proxysql, but the haproxy method is easy.  If/when the JDBC connector properly supports multiple database servers along with failover I wouldn't need this middleware.

            Nik Ambrosch added a comment - To be clear, percona distributes the mysql code base, so it is a mysql distribution, not a mysql flavor.  I have Jira datacenter using a three-cluster multi-master percona cluster for it's database with a copy of haproxy running locally to fool Jira into thinking there's something running locally.  It load balances the three nodes and maintains persistence.  There are better ways to do this, one of which is proxysql, but the haproxy method is easy.  If/when the JDBC connector properly supports multiple database servers along with failover I wouldn't need this middleware.

            Roberto Martignano added a comment -

            Hello!

            Is there anyone out there still using Percona in 2024 with Jira 9.12.x ?

            Any particular issues to report? Does it work smoothly? 

            Thank you!

            Roberto

            Roberto Martignano added a comment - Hello! Is there anyone out there still using Percona in 2024 with Jira 9.12.x ? Any particular issues to report? Does it work smoothly?  Thank you! Roberto

            Nik Ambrosch added a comment -

            I've run Jira and Confluence on both Percona Server and Percona XtraDB 5.7 and 8.0 with no major issues.

            Nik Ambrosch added a comment - I've run Jira and Confluence on both Percona Server and Percona XtraDB 5.7 and 8.0 with no major issues.

            Martin Poirier added a comment -

            I will honestly say we are running percona (right now 5.6) since more then 5 years on all atlassian products (confluence/jira) without any problem. We have DB size of more then 100g for confluence and never had any corruption or problem with 15k users.

            We might switch to mssql for data center product.

            Martin
            Ubisoft

            Martin Poirier added a comment - I will honestly say we are running percona (right now 5.6) since more then 5 years on all atlassian products (confluence/jira) without any problem. We have DB size of more then 100g for confluence and never had any corruption or problem with 15k users. We might switch to mssql for data center product. Martin Ubisoft

            Christopher Biel added a comment -

            Is this still a problem or is it possible to run JIRA on percona without issues?

            Christopher Biel added a comment - Is this still a problem or is it possible to run JIRA on percona without issues?

              Unassigned Unassigned
              pkoczan Peter Koczan (Inactive)
              Votes:
              27 Vote for this issue
              Watchers:
              27 Start watching this issue

                Created:
                Updated: