Wsrep_received_bytes is less on restored node - pxc 8.0

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Hi there,
I have configured 3 node cluster(pxc 8.0) ,all the nodes are online.
I am restoring a backup on node2 i.e pxc2 (executed),but the wsrep_received_bytes is less on node 2 when compared to node 1 & 3.
I believe when executed or restored, it should restore on node2 initially and execute on the other nodes i.e 1& 3.

Is anything wrong?

mysql@pxc1 > show status  like 'wsrep_received_bytes%';
+----------------------+-----------+
| Variable_name        | Value     |
+----------------------+-----------+
| wsrep_received_bytes | 804386321 |
+----------------------+-----------+
1 row in set (0.00 sec)


mysql@pxc2 > show status  like 'wsrep_received_bytes%';
+----------------------+--------+
| Variable_name        | Value  |
+----------------------+--------+
| wsrep_received_bytes | 329680 |
+----------------------+--------+
1 row in set (0.00 sec)


mysql@pxc3 > show status  like 'wsrep_received_bytes%';
+----------------------+-----------+
| Variable_name        | Value     |
+----------------------+-----------+
| wsrep_received_bytes | 804882043 |
+----------------------+-----------+
1 row in set (0.00 sec)
2 Likes
2

Hi @ca1990 - thanks for posting!
How did you restore a backup on node2, was this a logical backup that you took using mysqldump or mydumper? That means a restore uses INSERT statements, which will execute on node2 and then be replicated to node1, node3. This will be recorded in wsrep_received_bytes on node1, node3 because they are the two nodes receiving the wsrep traffic. You’ll find wsrep_sent_bytes is significantly higher on node2 vs node1, node3.

1 Like
3

@Michael_Coburn
this is a physical backup ,which includes database structure and data …etc

1 Like