How radonDB implement Snapshot Isolation about radon HOT 3 CLOSED

Hi @louishust,

radon has a commit lock to make snapshot isolation:
1, when 'xa commit' is in committing phase, it acquires a commit-lock at:

2, At the same time, if a read query executing, it will try to acquire the same lock at:

This is the key to support snapshot isolation.
And, the backend MySQL must be in REPEATABLE-READ isolation level.

from radon.

Thanks for your reply.

So the performance is like one thread?

If deploy two radondb in one cluster, how to maintain the lock?

from radon.

1, As the case we talked above,, its YES.
2, The lock only works for one node, otherwise we cannot guaranteec the snapshot isolation.

from radon.