Pilot Project for Migrating Zhongtai Securities Business Systems to an Independently Developed IT Ecosystem

Zhongtai Securities Co., Ltd. (formerly Qilu Securities Co., Ltd.) is a large, comprehensive listed securities firm in China. With 44 branches and over 280 securities offices across 28 provinces, municipalities and autonomous regions, it has more than 9,000 employees. The company holds controlling stakes in Zhongtai Futures, Zhongtai Capital, Zhongtai International, Zhongtai Asset Management, Zhongtai Venture Capital, Qilu Equity Exchange, Wanjia Fund Management, and Zhongtai Property, forming a diversified business portfolio that spans securities, futures, fund management, investment and more—all advancing in tandem.

Driven by rapid fintech evolution and intensifying market competition, Zhongtai Securities urgently needed to modernize its business systems through innovative IT transformation—strengthening risk defenses and enhancing service quality and system performance. The firm selected two business platforms as pilot projects, aiming to handle transaction data for 8 million users while ensuring stable, uninterrupted 7×24 operation.

The project built a general-purpose management platform based on the GBase database. System A is deployed with one primary and one standby node, while System B uses one primary and two standby nodes. Logical replication is supported between primary and standby nodes, synchronizing data by transferring logical logs or the SQL statements derived from them. Both configurations are set up with a virtual IP (VIP) and heartbeat detection. Heartbeat detection threads continuously poll the primary node; if a timeout occurs, a fast failover is triggered. Application clients connect to the database via the VIP, so even if a primary-standby switchover happens, the VIP is automatically bound to the new primary without manual IP changes, making the failover transparent to upper-layer applications.

Additionally, backed by GBase’s visual management tool for distributed databases, both database systems (and more) can be managed simultaneously. This simplifies technically demanding DBA operations such as cluster management, log auditing, backup and recovery, scaling, upgrade management, performance diagnostics and analysis, and resource management.

Using GBase's distributed database, the customer completed the system transformation smoothly and efficiently, achieving the same processing power as high-end hardware on locally manufactured chips and servers — fully meeting business requirements.

High availability and virtual IP capabilities effectively prevent single-point-of-failure outages, enhancing user experience and ensuring system stability and continuity.

GBase's distributed database supports standard SQL and is highly compatible with mainstream database syntax, enabling near-zero-code-change migration.