charles-001 / dolphie

Your single pane of glass for real-time analytics into MySQL/MariaDB & ProxySQL
https://pypi.org/project/dolphie/
GNU General Public License v3.0
589 stars 36 forks source link

Add support for Percona XtraDB Cluster #22

Closed bds-congnguyen closed 1 year ago

bds-congnguyen commented 1 year ago

The Percona Multi-source replication means that you can write to any node and be sure that the write will be consistent for all nodes in the cluster. https://docs.percona.com/percona-xtradb-cluster/5.7/features/highavailability.html it doesn't use master-slave show run command

show slave status;

will return empty and it cause No data to display! This host is not a replica and has no replicas connected show I suggest add feature to get cluster status by wsrep_local_state_comment

mysql> SHOW STATUS LIKE 'wsrep_local_state_comment';
+---------------------------+--------+
| Variable_name             | Value  |
+---------------------------+--------+
| wsrep_local_state_comment | Synced |
+---------------------------+--------+
1 row in set (0.00 sec)
charles-001 commented 1 year ago

Hey @bds-congnguyen - there's probably a lot that can be displayed for clustering besides that... I just don't have an environment setup/knowledge background to support it. If you want the replication panel to just simply display that, that's fine.

charles-001 commented 1 year ago

This is in v3.0.8