API tools faq
paste
Advertisement
zentavr

Proxysql Log

zentavr
Dec 9th, 2020
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 74.46 KB | None | 0 0
raw download clone embed print report
  1. 2020-12-10 03:21:07 [INFO] Shutdown angel process
  2. 2020-12-10 03:21:07 [INFO] ProxySQL version 2.0.15-percona-1.1
  3. 2020-12-10 03:21:07 [INFO] Detected OS: Linux db-arbiter01.ha.local 5.4.0-53-generic #59-Ubuntu SMP Wed Oct 21 09:38:44 UTC 2020 x86_64
  4. 2020-12-10 03:21:07 [INFO] ProxySQL SHA1 checksum: 5c3671bf028297c60e27edb311215b63c5eeaf9c
  5. 2020-12-10 03:21:07 [INFO] Starting ProxySQL
  6. 2020-12-10 03:21:07 [INFO] Sucessfully started
  7. 2020-12-10 03:21:07 [INFO] Angel process started ProxySQL process 76135
  8. Standard ProxySQL MySQL Logger rev. 2.0.0714 -- MySQL_Logger.cpp -- Fri Nov 13 11:13:22 2020
  9. Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Fri Nov 13 11:13:22 2020
  10. Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Fri Nov 13 11:13:22 2020
  11. Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Fri Nov 13 11:13:22 2020
  12. Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Fri Nov 13 11:13:22 2020
  13. 2020-12-10 03:21:07 [INFO] ProxySQL SHA1 checksum: 5c3671bf028297c60e27edb311215b63c5eeaf9c
  14. Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Fri Nov 13 11:13:22 2020
  15. Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Fri Nov 13 11:13:22 2020
  16. 2020-12-10 03:21:07 [INFO] Dumping mysql_servers_incoming
  17. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  18. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  19. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  20. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  21. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  22. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  23. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  24. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  25. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  26. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  27. 2020-12-10 03:21:07 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
  28. +-------------+--------------+----------+------+
  29. | mem_pointer | hostgroup_id | hostname | port |
  30. +-------------+--------------+----------+------+
  31. +-------------+--------------+----------+------+
  32. 2020-12-10 03:21:07 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
  33. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  34. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  35. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  36. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 0 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  37. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  38. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  39. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 0 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  40. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 0 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  41. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  42. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  43. 2020-12-10 03:21:07 [INFO] Creating new server in HG 0 : 10.95.190.24:3306 , gtid_port=0, weight=1, status=2
  44. 2020-12-10 03:21:07 [INFO] Creating new server in HG 1 : 10.95.190.24:3306 , gtid_port=0, weight=1, status=0
  45. 2020-12-10 03:21:07 [INFO] Creating new server in HG 1 : 10.95.190.23:3306 , gtid_port=0, weight=1, status=0
  46. 2020-12-10 03:21:07 [INFO] Creating new server in HG 0 : 10.95.190.22:3306 , gtid_port=0, weight=1, status=2
  47. 2020-12-10 03:21:07 [INFO] Creating new server in HG 0 : 10.95.190.23:3306 , gtid_port=0, weight=1, status=2
  48. 2020-12-10 03:21:07 [INFO] Creating new server in HG 1 : 10.95.190.22:3306 , gtid_port=0, weight=1, status=0
  49. 2020-12-10 03:21:07 [INFO] New mysql_group_replication_hostgroups table
  50. 2020-12-10 03:21:07 [INFO] New mysql_galera_hostgroups table
  51. 2020-12-10 03:21:07 [INFO] New mysql_aws_aurora_hostgroups table
  52. 2020-12-10 03:21:07 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
  53. Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Fri Nov 13 11:13:22 2020
  54. In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Fri Nov 13 11:13:22 2020
  55. Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Fri Nov 13 11:13:22 2020
  56. 2020-12-10 03:21:09 [INFO] Latest ProxySQL version available: 2.0.15-20-g32bb92c
  57.  
  58. 2020-12-10 03:21:49 [INFO] Received SAVE MYSQL SERVERS TO DISK command
  59. 2020-12-10 03:21:53 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
  60. 2020-12-10 03:21:53 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  61. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_SOFT , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  62. HID: 0 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_SOFT , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  63. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_SOFT , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  64. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  65. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  66. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  67. 2020-12-10 03:21:53 [INFO] Dumping mysql_servers: ALL
  68. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  69. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  70. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  71. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 140513134506592 |
  72. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 140513134506752 |
  73. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 140513134507232 |
  74. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 140513134507872 |
  75. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 140513134507072 |
  76. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 140513134506912 |
  77. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  78. 2020-12-10 03:21:53 [INFO] Dumping mysql_servers_incoming
  79. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  80. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  81. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  82. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  83. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  84. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  85. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  86. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  87. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  88. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  89. 2020-12-10 03:21:53 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
  90. +-------------+--------------+----------+------+
  91. | mem_pointer | hostgroup_id | hostname | port |
  92. +-------------+--------------+----------+------+
  93. +-------------+--------------+----------+------+
  94. 2020-12-10 03:21:53 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
  95. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  96. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  97. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  98. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 140513134506592 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  99. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 140513134507072 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  100. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 2 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 140513134506912 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  101. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  102. 2020-12-10 03:21:53 [INFO] Changing status for server 0:10.95.190.24:3306 (10.95.190.24:3306) from 2 (2) to 0
  103. 2020-12-10 03:21:53 [INFO] Changing status for server 0:10.95.190.23:3306 (10.95.190.23:3306) from 2 (2) to 0
  104. 2020-12-10 03:21:53 [INFO] Changing status for server 0:10.95.190.22:3306 (10.95.190.22:3306) from 2 (2) to 0
  105. 2020-12-10 03:21:53 [INFO] New mysql_replication_hostgroups table
  106. writer_hostgroup: 0 , reader_hostgroup: 1, check_type read_only, comment: PB HA Reader/Writer host group
  107. 2020-12-10 03:21:53 [INFO] New mysql_group_replication_hostgroups table
  108. 2020-12-10 03:21:53 [INFO] New mysql_galera_hostgroups table
  109. 2020-12-10 03:21:53 [INFO] New mysql_aws_aurora_hostgroups table
  110. 2020-12-10 03:21:53 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  111. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  112. HID: 0 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  113. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  114. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  115. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  116. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  117. 2020-12-10 03:21:53 [INFO] Dumping mysql_servers: ALL
  118. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  119. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  120. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  121. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 140513134506592 |
  122. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 140513134506752 |
  123. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 140513134507232 |
  124. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 140513134507872 |
  125. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 140513134507072 |
  126. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 140513134506912 |
  127. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  128. 2020-12-10 03:21:53 [INFO] MySQL_HostGroups_Manager::commit() locked for 5ms
  129. 2020-12-10 03:21:53 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  130. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  131. HID: 0 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  132. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  133. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  134. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  135. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  136. 2020-12-10 03:21:53 [INFO] Dumping mysql_servers: ALL
  137. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  138. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  139. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  140. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 140513134506592 |
  141. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 140513134506752 |
  142. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 140513134507232 |
  143. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 140513134507872 |
  144. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 140513134507072 |
  145. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 140513134506912 |
  146. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  147. 2020-12-10 03:30:41 [INFO] Received SAVE MYSQL SERVERS TO DISK command
  148. 2020-12-10 03:31:57 ProxySQL_GloVars.cpp:9:term_handler(): [WARNING] Received TERM signal: shutdown in progress...
  149. 2020-12-10 03:31:57 [INFO] Starting shutdown...
  150. 2020-12-10 03:31:57 [INFO] Shutdown completed!
  151. 2020-12-10 03:31:57 [INFO] Exiting...
  152. 2020-12-10 03:31:57 [INFO] Shutdown angel process
  153. 2020-12-10 03:31:57 [INFO] ProxySQL version 2.0.15-percona-1.1
  154. 2020-12-10 03:31:57 [INFO] Detected OS: Linux db-arbiter01.ha.local 5.4.0-53-generic #59-Ubuntu SMP Wed Oct 21 09:38:44 UTC 2020 x86_64
  155. 2020-12-10 03:31:57 [INFO] ProxySQL SHA1 checksum: 5c3671bf028297c60e27edb311215b63c5eeaf9c
  156. 2020-12-10 03:31:57 [INFO] Starting ProxySQL
  157. 2020-12-10 03:31:57 [INFO] Sucessfully started
  158. 2020-12-10 03:31:57 [INFO] Angel process started ProxySQL process 76233
  159. Standard ProxySQL MySQL Logger rev. 2.0.0714 -- MySQL_Logger.cpp -- Fri Nov 13 11:13:22 2020
  160. Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Fri Nov 13 11:13:22 2020
  161. Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Fri Nov 13 11:13:22 2020
  162. Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Fri Nov 13 11:13:22 2020
  163. Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Fri Nov 13 11:13:22 2020
  164. 2020-12-10 03:31:57 [INFO] ProxySQL SHA1 checksum: 5c3671bf028297c60e27edb311215b63c5eeaf9c
  165. Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Fri Nov 13 11:13:22 2020
  166. Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Fri Nov 13 11:13:22 2020
  167. 2020-12-10 03:31:57 [INFO] Dumping mysql_servers_incoming
  168. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  169. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  170. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  171. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  172. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  173. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  174. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  175. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  176. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  177. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  178. 2020-12-10 03:31:57 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
  179. +-------------+--------------+----------+------+
  180. | mem_pointer | hostgroup_id | hostname | port |
  181. +-------------+--------------+----------+------+
  182. +-------------+--------------+----------+------+
  183. 2020-12-10 03:31:57 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
  184. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  185. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  186. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  187. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 0 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  188. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  189. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  190. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 0 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  191. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 0 | 0 | 1 | 3 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  192. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  193. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  194. 2020-12-10 03:31:57 [INFO] Creating new server in HG 0 : 10.95.190.24:3306 , gtid_port=0, weight=1, status=3
  195. 2020-12-10 03:31:57 [INFO] Creating new server in HG 1 : 10.95.190.24:3306 , gtid_port=0, weight=1, status=0
  196. 2020-12-10 03:31:57 [INFO] Creating new server in HG 1 : 10.95.190.23:3306 , gtid_port=0, weight=1, status=0
  197. 2020-12-10 03:31:57 [INFO] Creating new server in HG 0 : 10.95.190.22:3306 , gtid_port=0, weight=1, status=3
  198. 2020-12-10 03:31:57 [INFO] Creating new server in HG 0 : 10.95.190.23:3306 , gtid_port=0, weight=1, status=3
  199. 2020-12-10 03:31:57 [INFO] Creating new server in HG 1 : 10.95.190.22:3306 , gtid_port=0, weight=1, status=0
  200. 2020-12-10 03:31:57 [INFO] New mysql_group_replication_hostgroups table
  201. 2020-12-10 03:31:57 [INFO] New mysql_galera_hostgroups table
  202. 2020-12-10 03:31:57 [INFO] New mysql_aws_aurora_hostgroups table
  203. 2020-12-10 03:31:57 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
  204. Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Fri Nov 13 11:13:22 2020
  205. In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Fri Nov 13 11:13:22 2020
  206. Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Fri Nov 13 11:13:22 2020
  207. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 1 : Dumping mysql_servers for 10.95.190.23:3306
  208. +--------------+--------------+------+-----------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  209. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  210. +--------------+--------------+------+-----------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  211. | 1 | 10.95.190.23 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  212. | 0 | 10.95.190.23 | 3306 | 0 | OFFLINE_HARD | 1 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  213. +--------------+--------------+------+-----------+--------------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  214. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  215. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  216. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  217. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  218. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  219. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  220. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  221. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  222. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  223. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  224. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  225. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  226. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 2 : Dumping mysql_servers for 10.95.190.23:3306
  227. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  228. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  229. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  230. | 1 | 10.95.190.23 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  231. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  232. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 3 : Dumping mysql_servers for 10.95.190.23:3306
  233. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  234. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  235. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  236. | 0 | 10.95.190.23 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  237. | 1 | 10.95.190.23 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  238. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  239. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  240. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  241. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  242. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  243. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  244. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  245. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  246. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  247. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  248. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  249. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  250. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  251. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers_incoming
  252. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  253. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  254. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  255. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  256. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  257. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  258. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  259. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  260. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
  261. +-------------+--------------+----------+------+
  262. | mem_pointer | hostgroup_id | hostname | port |
  263. +-------------+--------------+----------+------+
  264. +-------------+--------------+----------+------+
  265. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
  266. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  267. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  268. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  269. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  270. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  271. 2020-12-10 03:32:00 [INFO] Creating new server in HG 0 : 10.95.190.23:3306 , gtid_port=0, weight=1, status=0
  272. 2020-12-10 03:32:00 [INFO] New mysql_replication_hostgroups table
  273. writer_hostgroup: 0 , reader_hostgroup: 1, check_type read_only, comment: PB HA Reader/Writer host group
  274. 2020-12-10 03:32:00 [INFO] New mysql_group_replication_hostgroups table
  275. 2020-12-10 03:32:00 [INFO] New mysql_galera_hostgroups table
  276. 2020-12-10 03:32:00 [INFO] New mysql_aws_aurora_hostgroups table
  277. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  278. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  279. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  280. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  281. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  282. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  283. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  284. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  285. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  286. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  287. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  288. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  289. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  290. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  291. 2020-12-10 03:32:00 [INFO] MySQL_HostGroups_Manager::commit() locked for 3ms
  292. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  293. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  294. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  295. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  296. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  297. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  298. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  299. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  300. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  301. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  302. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  303. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  304. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  305. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  306. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 1 : Dumping mysql_servers for 10.95.190.24:3306
  307. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  308. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  309. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  310. | 1 | 10.95.190.24 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  311. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  312. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  313. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  314. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  315. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  316. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  317. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  318. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  319. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  320. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  321. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  322. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  323. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  324. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  325. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  326. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 2 : Dumping mysql_servers for 10.95.190.24:3306
  327. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  328. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  329. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  330. | 1 | 10.95.190.24 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  331. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  332. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 3 : Dumping mysql_servers for 10.95.190.24:3306
  333. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  334. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  335. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  336. | 0 | 10.95.190.24 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  337. | 1 | 10.95.190.24 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  338. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  339. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  340. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  341. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  342. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  343. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  344. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  345. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  346. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  347. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  348. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  349. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  350. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  351. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  352. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  353. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers_incoming
  354. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  355. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  356. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  357. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  358. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  359. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  360. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  361. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  362. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  363. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
  364. +-------------+--------------+----------+------+
  365. | mem_pointer | hostgroup_id | hostname | port |
  366. +-------------+--------------+----------+------+
  367. +-------------+--------------+----------+------+
  368. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
  369. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  370. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  371. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  372. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  373. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  374. 2020-12-10 03:32:00 [INFO] Creating new server in HG 0 : 10.95.190.24:3306 , gtid_port=0, weight=1, status=0
  375. 2020-12-10 03:32:00 [INFO] New mysql_replication_hostgroups table
  376. writer_hostgroup: 0 , reader_hostgroup: 1, check_type read_only, comment: PB HA Reader/Writer host group
  377. 2020-12-10 03:32:00 [INFO] New mysql_group_replication_hostgroups table
  378. 2020-12-10 03:32:00 [INFO] New mysql_galera_hostgroups table
  379. 2020-12-10 03:32:00 [INFO] New mysql_aws_aurora_hostgroups table
  380. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  381. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  382. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  383. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  384. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  385. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  386. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  387. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  388. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  389. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  390. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  391. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  392. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  393. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  394. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729440077120 |
  395. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  396. 2020-12-10 03:32:00 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
  397. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  398. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  399. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  400. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  401. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  402. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  403. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  404. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  405. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  406. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  407. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  408. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  409. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  410. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  411. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729440077120 |
  412. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  413. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 1 : Dumping mysql_servers for 10.95.190.22:3306
  414. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  415. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  416. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  417. | 1 | 10.95.190.22 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  418. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  419. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  420. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  421. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  422. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  423. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  424. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  425. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  426. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  427. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  428. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  429. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  430. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  431. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  432. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  433. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729440077120 |
  434. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  435. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 2 : Dumping mysql_servers for 10.95.190.22:3306
  436. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  437. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  438. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  439. | 1 | 10.95.190.22 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  440. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  441. 2020-12-10 03:32:00 [INFO] read_only_action RO=0 phase 3 : Dumping mysql_servers for 10.95.190.22:3306
  442. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  443. | hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  444. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  445. | 0 | 10.95.190.22 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  446. | 1 | 10.95.190.22 | 3306 | 0 | ONLINE | 1 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  447. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  448. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  449. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  450. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  451. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  452. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  453. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  454. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  455. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  456. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  457. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  458. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  459. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  460. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  461. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  462. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729440077120 |
  463. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  464. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers_incoming
  465. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  466. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  467. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  468. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  469. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  470. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local |
  471. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  472. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local |
  473. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  474. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  475. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
  476. +-------------+--------------+----------+------+
  477. | mem_pointer | hostgroup_id | hostname | port |
  478. +-------------+--------------+----------+------+
  479. +-------------+--------------+----------+------+
  480. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
  481. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  482. | hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
  483. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  484. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 0 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local |
  485. +--------------+--------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------------+
  486. 2020-12-10 03:32:00 [INFO] Creating new server in HG 0 : 10.95.190.22:3306 , gtid_port=0, weight=1, status=0
  487. 2020-12-10 03:32:00 [INFO] New mysql_replication_hostgroups table
  488. writer_hostgroup: 0 , reader_hostgroup: 1, check_type read_only, comment: PB HA Reader/Writer host group
  489. 2020-12-10 03:32:00 [INFO] New mysql_group_replication_hostgroups table
  490. 2020-12-10 03:32:00 [INFO] New mysql_galera_hostgroups table
  491. 2020-12-10 03:32:00 [INFO] New mysql_aws_aurora_hostgroups table
  492. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  493. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  494. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  495. HID: 0 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  496. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  497. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  498. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  499. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  500. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  501. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  502. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  503. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  504. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  505. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  506. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  507. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729440077280 |
  508. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729440077120 |
  509. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  510. 2020-12-10 03:32:00 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
  511. 2020-12-10 03:32:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
  512. HID: 0 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  513. HID: 0 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  514. HID: 0 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  515. HID: 1 , address: 10.95.190.24 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db03.ha.local
  516. HID: 1 , address: 10.95.190.23 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db02.ha.local
  517. HID: 1 , address: 10.95.190.22 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 2000 , max_replication_lag: 1 , use_ssl: 1 , max_latency_ms: 0 , comment: db01.ha.local
  518. 2020-12-10 03:32:00 [INFO] Dumping mysql_servers: ALL
  519. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  520. | hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
  521. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  522. | 0 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729442168992 |
  523. | 1 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729699336960 |
  524. | 1 | 10.95.190.23 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db02.ha.local | 139729699337440 |
  525. | 1 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729699338080 |
  526. | 0 | 10.95.190.22 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db01.ha.local | 139729440077280 |
  527. | 0 | 10.95.190.24 | 3306 | 0 | 1 | 0 | 0 | 2000 | 1 | 1 | 0 | db03.ha.local | 139729440077120 |
  528. +-----+--------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------------+-----------------+
  529. 2020-12-10 03:32:00 [INFO] Latest ProxySQL version available: 2.0.15-20-g32bb92c
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!