Taiping Insurance

Overview

Taiping Insurance
Country: China (Hong Kong SAR)
Industry: Insurance
Solution: i2Stream

Taiping Insurance (Hong Kong) sought to enhance the performance and security of its database synchronization system. The existing replication tool suffered from frequent interruptions, a lack of DDL support, and performance limitations that could not meet the real-time transactional requirements of critical business systems.

Customer Challenge

• Insufficient performance for real-time transactional replication.
• Manual intervention required when synchronization was interrupted.
• Agent installation on source databases raised performance and security concerns.
• Replication required primary keys and lacked DDL support.
• Frequent manual operations were needed for schema changes and failure recovery.

I2 Solution

Info2soft delivered a cluster-based deployment using i2Stream, installing all synchronization components on two middleware servers in high-availability (HA) mode. Key features included:

• Agentless architecture connecting directly to source TDSQL and Oracle clusters, and target TDSQL databases.
• Real-time asynchronous replication of both DML and DDL to designated target tables.
• Visualized management interface for link configuration and monitoring, eliminating reliance on command-line tools.
• Breakpoint recovery mechanism to automatically resume replication after disruptions.

Result

• Over 30% improvement in replication performance through multi-threaded synchronization.
• Full DDL replication support, eliminating manual intervention during schema changes.
• Enhanced system stability with high-availability deployment and automatic recovery.
• Improved data security and efficiency by removing agents from source databases.