Hello, sorry for my English, there is such a problem, I configured Percona XtraDB Cluster on 3 servers, everything is working fine now, but how do I look at the time delay of the slave from the master? If I’m watching now
PXC uses completely different replication technology then normal MySQL, hence “show slave status\G” is not supposed to give any output here.
If you want to check the replication status, take a look at
show status like 'ws%';
Check our documentation for more details: [url]Redirecting
Thanks for the answer, I understand it, but what parameter is responsible for the delay between the slave of the master? wsrep_flow_control_paused_ns or wsrep_flow_control_paused ? Or in general another parameter?
The wsrep_flow_control_paused_ns is rather to monitor total time when cluster is paused due to Flow Control. To find out which node is “lagging” you should check it’s wsrep_local_recv_queue and wsrep_flow_control_sent.
Replicaiton delay in Galera is not really measured in seconds but in number of transactions waiting to be applied.
Whether it is possible somehow to monitor these parameters wsrep_local_recv_queue and wsrep_flow_control_sent through a zabbix, I adjusted monitoring under this documentation [URL]Percona Monitoring Plugins
But to which value should these parameters be wsrep_local_recv_queue and wsrep_flow_control_sent?
Prompt if under this documentation [URL]Percona Monitoring Plugins there is an item MySQL.slave-lag this that that is necessary for me? Or you still have to watch wsrep_local_recv_queue and wsrep_flow_control_sent?
Parameters and graphs in zabbix I can configure myself, but I need to understand what to set up? If Percona XtraDB Cluster does not have the Seconds_Behind_Master parameter, then I need to take the parameters wsrep_local_recv_queue and wsrep_flow_control_sent, but how can you tell by these parameters that there is a delay?