High Performance II - Automatic Load Balance&RW Splitting

    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