Chainbase has migrated its core system database to OceanBase as part of a technical collaboration announced at the Singapore Fintech Festival.
Initial results show a 40% reduction in database costs and a 30% improvement in query performance, according to Chainbase.
The company operates a hosted multi-chain data warehouse with indexing APIs.
This allows developers to query blockchain data across networks without running their own indexers.
Its services require storing and querying large volumes of on-chain data by address and block, while continuously ingesting new data.
As on-chain data volumes grew, the scale and cost of its database rose with them.
The legacy system could no longer meet the company’s requirements for cost efficiency and storage capacity.
After evaluating several database options, Chainbase selected OceanBase for its cost efficiency, query performance and migration execution.
It then optimised table structures, indexes and hot-data caching based on real query scenarios.
The migration covered more than 10 TB of existing data while the platform continued to ingest new on-chain data.
Using OceanBase Migration Service (OMS), Chainbase completed the process with minimal impact on live services, the companies said.
Chainbase attributed the cost reduction to a 50% increase in storage compression.
According to the announcement, the new data foundation is expected to help control long-term costs, support multi-dimensional queries and provide a more scalable base for future growth.
“Chainbase needed a database solution that could support long-term data expansion while keeping costs under control,”
said Cong, Chief Technology Officer at Chainbase.
OceanBase said it will continue to provide database and technical support to Chainbase.
Featured image: Edited by Fintech News Singapore, based on image by rawpixel.com via Magnific.



