Uploaded image for project: 'ProxySQL Admin Scripts'
  1. ProxySQL Admin Scripts
  2. PSQLADM-107

include-slaves - do not move slaves into write hostgroup even if the whole cluster went down.

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.4.9
    • Fix Version/s: 1.4.12
    • Component/s: None
    • Labels:
      None

      Description

      --include-slaves=host_name:port Add specified slave node(s) to ProxySQL, these nodes will go into the reader hostgroup and will only be put into
       the writer hostgroup if all cluster nodes are down.
       Slaves must be read only. Can accept a comma delimited list.
       If this is used make sure 'read_only=1' is in the slave's

      Even if the whole cluster went down do not move the async slaves into write hostgroup because that can be dangerous. 

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kenn.takara Kenn Takara
                Reporter:
                tibor.korocz Tibor Korocz
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days
                  2d