Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-551

Provide a way to ignore the load balancing in AWS Aurora while retaining failover

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: configuration
    • Labels:
      None

      Description

      When using AWS Aurora with a read replica and the load balancing provided by the driver, you're faced with potential inconsistency because of the replica lag (an insert is not instantly reflected on the read replicas). This means that you can insert an object, immediately retrieve it on a readOnly=true connection and get null.

      I understand that in some cases this lag is acceptable and the load balancing advantages outweigh the consistency. However, there should be an option so that all queries, regarless of the status of the readOnly flag, are routed to the master instance while retaining the failover capabilities of the driver.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              diego dupin Diego Dupin
              Reporter:
              jebeaudet Jacques-Etienne Beaudet
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.