All clients connect to the VIP on the DBTwin Main Gateway(abbr as GW). The GW does the function of automatic(without any source code modification) read-write splitting and load balance. Through automatic check, the read/select queries will be transferred to the secondary node which is the read-only node of the cluster, thus improving the performance of the entire database system, which is very helpfull and effective for the separation of OLTP and OLAP.
The GW can also do some optimaztion work through syntactically-equivalent transformation.
DBTwin Active-Active Database Cluster Diagram