There is a 3 node cluster(
pcx 8.0),say A,B and C.If
1000 insert statements has been executed at
1.How would i know the lag in other nodes i.e
B,C, like lag by
Seconds_Behind_Master in replication or log sequence no if any ?
1000 insert statements executed parallel at all the nodes .?
3.how much time does it take to execute at other nodes i.e
You can look at
wsrep_local_send_queue along with comparing
wsrep_last_committed between two nodes. There is no time-based equivalent like S-b-m.
No, the 1000 statements would go through certification and apply in async fashion on nodes B and C. They may be parallelized within each node, but that is at the node level, not the cluster level.
It depends. Is the hardware the same? Config the same? In theory, as fast as possible. Remember that PXC is synchronous replication, async apply.