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

Add support for aurora protocol without load balancing

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • aurora
    • None

    Description

      We have several use cases that would be ideal for an aurora mode without load balancing - say aurora-sequential.

      We have non-global replicating clusters in various regions that we use sequential connections in case of regional outage. However, these connections cannot be load balanced because of latency between regions. We can tolerate the increased latency in emergency situations but not under normal conditions. However, because we use sequential connections, we cannot handle failover in the same region as well. An aurora without load balancing would be ideal for this.

      Also, we have writing standby clusters for a regional outage as well but given the access patterns of this code, we cannot tolerate load balancing for writes either. Essentially, aurora with multiple hosts for writing is a split brain scenario.

      To handle aurora failover or adding new nodes in the same region with sequential connections, we have connections that expire every minute but this aurora mode without load balancing would allow us to not expire connections either.

      I'm opening as a feature request since as recommended in CONTRIBUTING.md and what what I can tell, this is a new feature. I would be happy to contribute this change as removing the host list shuffling doesn't appear to be that complicated. Most of the code is basically the same for AuroraListener and AuroraProtocol.

      Attachments

        Activity

          diego dupin Diego Dupin added a comment -

          No new feature for aurora will be implemented.

          (Specific support for aurora has even not been implemented in new 3.0 version, since it relies on pipelining and Aurora is not compatible with pipelining)

          Issues for Aurora were piling up without the community proposing any PR for them and without access for us to test those modifications. 2.x version has a 5 years support, so it won't be a breaking support.

          diego dupin Diego Dupin added a comment - No new feature for aurora will be implemented. (Specific support for aurora has even not been implemented in new 3.0 version, since it relies on pipelining and Aurora is not compatible with pipelining) Issues for Aurora were piling up without the community proposing any PR for them and without access for us to test those modifications. 2.x version has a 5 years support, so it won't be a breaking support.
          jbedalov John Bedalov added a comment -

          (Specific support for aurora has even not been implemented in new 3.0 version, since it relies on pipelining and Aurora is not compatible with pipelining)

          Thanks for the response and the information. I noticed that 3.0 didn't have aurora. All of this make sense. We'll continue to tune our approach to work with sequential then.

          jbedalov John Bedalov added a comment - (Specific support for aurora has even not been implemented in new 3.0 version, since it relies on pipelining and Aurora is not compatible with pipelining) Thanks for the response and the information. I noticed that 3.0 didn't have aurora. All of this make sense. We'll continue to tune our approach to work with sequential then.

          People

            diego dupin Diego Dupin
            jbedalov John Bedalov
            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.