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

mysql is not picked up in proxysql on the basis of priority with equal weight

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.10
    • Component/s: None
    • Labels:
      None
    • Environment:

      Proxysql with PXC

      Description

      High priority node is not picking up as a "ONLINE" writer node, instead marked as "OFFLINE_SOFT"

       

      SET GLOBAL pxc_maint_transition_period=3;
      SET GLOBAL PXC_MAINT_MODE='MAINTENANCE';SET GLOBAL PXC_MAINT_MODE='DISABLED';
      

      This makes the scheduler change the write node at each run:

       

      mysql> SELECT * FROM mysql_servers;
      +--------------+--------------+------+--------------+---------+-------------+-----------------+---------------------+---------+----------------+---------+
      | hostgroup_id | hostname    | port | status      | weight  | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
      +--------------+--------------+------+--------------+---------+-------------+-----------------+---------------------+---------+----------------+---------+
      | 11          | 172.16.1.188 | 3306 | ONLINE      | 1000    | 0          | 1000            | 0                  | 0      | 0              | READ    |
      | 10          | 172.16.1.54  | 3306 | OFFLINE_SOFT | 1000000 | 0          | 1000            | 0                  | 0      | 0              | WRITE  |
      | 10          | 172.16.0.218 | 3306 | ONLINE      | 1000000 | 0          | 1000            | 0                  | 0      | 0              | WRITE  |
      +--------------+--------------+------+--------------+---------+-------------+-----------------+---------------------+---------+----------------+---------+
      3 rows in set (0.00 sec)
      
      mysql> SELECT * FROM mysql_servers;
      +--------------+--------------+------+--------------+---------+-------------+-----------------+---------------------+---------+----------------+---------+
      | hostgroup_id | hostname    | port | status      | weight  | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
      +--------------+--------------+------+--------------+---------+-------------+-----------------+---------------------+---------+----------------+---------+
      | 10          | 172.16.1.188 | 3306 | OFFLINE_SOFT | 1000000 | 0          | 1000            | 0                  | 0      | 0              | WRITE  |
      | 11          | 172.16.1.54  | 3306 | ONLINE      | 1000    | 0          | 1000            | 0                  | 0      | 0              | READ    |
      | 10          | 172.16.0.218 | 3306 | ONLINE      | 1000000 | 0          | 1000            | 0                  | 0      | 0              | WRITE  |
      +--------------+--------------+------+--------------+---------+-------------+-----------------+---------------------+---------+----------------+---------+ 
      

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kenn.takara Kenn Takara
                Reporter:
                aayushi.mangal Aayushi Mangal
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: