on 2021 Nov 23 4:03 AM
Hi,
we plan to to install a read only scale out system. Is there any experiences what are the performance effect on the root node when I execute a large statement on the copy node ? If a table on the copy node is blocked during a transaction, changes on the root node that affect a corresponding table are blocked ?
thank you
Andreas
Request clarification before answering.
Read-only scale-out is particularly meant to separate long-running (and "heavy-locking") queries on copy nodes from OLTP on the root node. AFAIK, the root node works somewhat as in asynchronous mirror mode of a mirror-setup, i.e. it does not wait for the copy nodes to acknowledge the successful transmission of the sent log pages to the copy node's transaction log.
Therefore, a query on the copy nodes should not at all block any transaction on the root node.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Many thanks
"The root node does not wait for the copy nodes to acknowledge the successful transmission". This is what I was looking for.
thank you
User | Count |
---|---|
76 | |
30 | |
10 | |
8 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.