Working at same time on different nodes

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

H eveyone, i have a doubt:

  • Suppose 2 different nodes

  • 2 people working:1 people in node A and 1 people in node B

  • Its possible that if node A start a transaction, node B wait until node A transaction finish? Similar to whether they both work on the same node

Regards!

2

Hi,

Not sure what exactly transaction you mean, but no, it doesn’t work like on the same node. Nodes are not aware of their peer’s ongoing transactions until they are committed.
You may find these articles interesting:
[URL]https://www.percona.com/blog/2012/08/17/percona-xtradb-cluster-multi-node-writing-and-unexpected-deadlocks/[/URL]
[URL]https://www.percona.com/blog/2012/11/20/understanding-multi-node-writing-conflict-metrics-in-percona-xtradb-cluster-and-galera/[/URL]