Read-only Transaction
A read-only participant need only respond to phase one. It doesn’t care what the decision is.
It responds Prepared-Read-Only to Request-to-Prepare, to tell the coordinator not to send the decision
Limitation - All other participants must be fully terminated, since the read-only participant will release locks after voting.
- No more testing of SQL integrity constraints
- No more evaluation of SQL triggers