Background

As 2C2P experienced rapid growth, their existing MySQL infrastructure began to pose certain challenges.

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.

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

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.