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

proxysql_galera_checker script should consider user's custom max_connections setting

    Details

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

      ProxySQL v 1.4.12

      Description

      So let's say that max_connections=1000 is not optimal and the user wants to update mysql_servers to use max_connections > 1000 (eg 5000), each time the node is removed and then added back in as READ or WRITE node the max_connections is set back to 1000. The user then has to manually run

      UPDATE mysql_servers SET max_connections=5000;

      statement to change the max_connections value.

      https://github.com/percona/proxysql-admin-tool/blob/master/proxysql_galera_checker#L590-L592

      https://github.com/percona/proxysql-admin-tool/blob/master/proxysql_galera_checker#L965

      https://github.com/percona/proxysql-admin-tool/blob/master/proxysql_galera_checker#L1104-L1105

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kenn.takara Kenn Takara
                Reporter:
                jericho.rivera Jericho Rivera
              • Votes:
                0 Vote for this issue
                Watchers:
                4 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, 5 hours
                  2d 5h