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

Aurora failover based on read replica priority

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: aurora, Failover
    • Labels:

      Description

      Aurora read replicas can be set up with different failover priorities (Tier0 – Tier9 ...).
      Can the failover logic in the driver be modified to detect the read replica with higher priority (Tier0 over Tier 1 over Tier 2 ....) and switch writes to that read node.
      In our initial tests we are seeing that to be up faster than when the failover is reported as complete on the cluster (seconds instead of 10s of seconds) - so there might be some value there but we need more tests to confirm.
      That way the effective failover time might be faster than what is reported by Aurora.
      If there are multiple read nodes with the same priority we might have to cycle through them - so it might be slightly more complex.


      This might be a custom code on our side and not a generic fix.
      However, it will be good to know if someone else have tried anything along these lines.

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            OrtimusPrime Sumitro Palit
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration