Major upgrade:
You know, our product is exclusive to the market and has never been done by anyone before, so every major innovation requires a long time to be verified from theory to practice. The recent major improvement explains this point exactly.
As we all know, the getdate() function often appears in many sql statements including a large number of SELECT statements. Previously, due to cautious considerations, our AA database cluster did not handle these kind of SELECT statements with load balancing by default and could only execute them on the primary node like DML statements. Now, we have finally found the correct solution to fully automate this situation, allowing most of these statements to be load balanced and transferred to the secondary node for execution. In this way,the resource consumption pressure on the primary node has been greatly reduced and so the performance has been transparently improved a lot, which has been verified by our clients.
That is to say, the unique load balancing effect of our AA cluster has been significantly upgraded once again.