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:

• AWS Database Blog: How to set up a single pgpool endpoint for reads and writes with Amazon Aurora PostgreSQL