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.
