They needed a solution that would help them be better-positioned to handle future growth and maintain their competitive edge in the payment processing industry.
Gaining a competitive edge: 2C2P's strategic database upgrade with OceanBase
90%data compression
68%reduced storage
0%error rates
33.3%CPU performance
Founded in 2003, headquartered in Singapore and operates across Southeast Asia and Hong Kong, 2C2P is a global payments platform helping businesses securely accept payments across online, mobile and in-store channels.
Background
As 2C2P experienced rapid growth, their existing MySQL infrastructure began to pose certain challenges.
Challenges
-
Scalability Limitations:
-
Their database engine had difficulty scaling up or down vertically without service interruptions.
-
-
Storage Constraints:
-
Due to storage size limitations, frequent archiving was necessary, especially before sales promotions. This proved to be time-consuming with significant manhours.
-
-
Operational Complexity:
-
Managing a large number of database instances made operations and maintenance extremely challenging.
-
-
Data Synchronization Costs:
-
High expenses for data synchronization between Singapore and Tokyo regions for disaster recovery purposes.
-
Benefits
<meta charset="UTF-8" />
-
Seamless Migration:
-
Utilized OceanBase Migration Service which provided ample support throughout the transition with minimal SQL changes.
-
-
Disaster Recovery Optimisation:
-
Successfully tested DR functionality using a manually built OceanBase cluster in Japan.
-
-
Improved Scalability:
-
Achieved zero-downtime scaling through tenant and horizontal scaling methods, crucial for handling promotion periods.
-
-
Expert Support:
-
Assigned dedicated OceanBase Technical Account Manager to provide daily support on database performance tuning and issue resolution.
-
-
Cost Transparency & Savings with Superior Data Compression:
-
Realized transparent storage and workload costs. Benefited from up to 90% data compression. Reduced storage needs by 69%, thus eliminating the need for frequent archiving.
-
-
Simplified Operations Within A Unified Engine:
-
Consolidated databases as tenants within a large managed OceanBase cluster. This greatly simplified day-to-day maintenance operations and reduced operational overhead.
-
-
Enhanced Performance:
-
Observed a significant boost in performance with zero error rates during high transaction tests. OceanBase outperformed legacy MySQL infrastructure in stress tests, maintaining 0% error rates at various transaction levels. Estimated 33.3% CPU performance improvement.
-
