Use Cases
X-LOG provides diverse use cases across industries, from real-time data replication to system integration.
Zero-Downtime Migration Using IDL and CDC
1. Purpose of Implementation
- Zero-downtime migration for systems that cannot afford service interruption
- Minimize service downtime during server replacement, OS upgrades, or DB version updates
2. System Architecture
- Initial data is loaded based on the TSN value of the source DB, followed by replication of changed data using CDC
- Ensures fast and accurate data consistency verification within minimal service downtime
Real-Time Data Integration Use Case
Real-time linkage between remote DBs and file replication
- Integrated ~50 overseas DBs with the HQ DB in Korea using an N:M setup
- Switched from a 3-day-delayed backup/restore system to real-time replication for faster decision-making
- Achieved real-time replication over 20–30 Mbps networks by compressing changed transactions
- Built with 100% domestic technology, allowing flexible, environment-specific customization
Integrated Data Warehouse (DW) Construction
- Consolidated multiple DBMS systems distributed by business function
- Synchronized real-time data to ODS for big data analytics
Real-Time Data Replication Across different types of DBMS
1. Purpose of Implementation
- Reduce licensing and maintenance costs by migrating from expensive Oracle systems to PostgreSQL for analytics
- Manage data across various DBMSs within the same organization
2. System Architecture
- Real-time synchronization between different operating systems and different DBMS platforms
Remote DR System Implementation
- Real-time disaster recovery setup with live synchronization of DB and file data
- Enabled rapid service switchover to the remote DR site in case of a fire at the main data center
Load Balancing Implementation for Operational Systems
1. Purpose of Implementation
- Real-time replication separates query services to reduce load as data volume grows
- Query operations run on the replicated target system, allowing immediate switchover in case of main system failure
- Load balancing and DR system established simultaneously
