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

Support for Writer and Reader Endpoints in Amazon Aurora

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Data Center - Database
    • None
    • 2
    • 13
    • 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.

      Amazon Aurora provides endpoints for the primary DB instance (the cluster endpoint) and for Read Replicas (the reader endpoint).
      Aurora updates the cluster endpoint automatically so that it always points to the primary instance. The reader endpoint load balances read operations across all available Read Replicas.

      This suggestion is to add the functionality to read and write on different endpoints to improve database performance using a database cluster.

      Workaround

      Jira 9.10+, and Jira LTS 9.4.9+, added support for pgpool. The AWS blog below has a guide on how to use pgpool with Amazon Aurora PostgreSQL to load balance between read replicas:

              Unassigned Unassigned
              2e696d0b504b Marcel Sokolovsky (Inactive)
              Votes:
              32 Vote for this issue
              Watchers:
              15 Start watching this issue

                Created:
                Updated: