This topic introduces transactional instances in OceanBase Cloud, including their definition, key advantages, and main use cases.
What is a transactional instance?
A transactional instance is a specialized database instance type optimized for handling transactional workloads. These instances are designed for applications that require high-volume concurrent transaction processing, such as online trading systems, banking applications, and inventory management systems. Transactional instances prioritize ACID properties (Atomicity, Consistency, Isolation, Durability) to ensure data integrity and consistency.
Transactional instances of OceanBase Cloud focus on transaction processing, delivering high-performance and low-latency transaction capabilities.
Key features:
- High availability: Implements multi-replica mechanism for high availability and disaster recovery.
- High performance: Supports high-concurrency read and write operations, ideal for large-scale online transaction systems.
- Elastic scalability: Dynamically adjusts resources based on business needs to ensure stable performance.
- Full lifecycle management: Provides comprehensive data management features from creation and monitoring to backup and restore.
Core advantages
Native distribution
Implements data consistency through comprehensive data validation, ensuring zero data loss. Features an innovative "Five IDCs Across Three Regions" disaster recovery architecture, setting new standards for the financial industry. Supports both local and geo-distributed disaster recovery with multi-active deployment capabilities, meeting financial industry level-6 disaster recovery standards (RPO=0, RTO<8s) with zero data loss.
Hybrid transactional and analytical processing (HTAP)
Based on "One Data Copy, One Engine" architecture, simultaneously supports both real-time transaction processing and real-time analytics. Multiple replicas of the same dataset can be stored in different formats for various workloads while maintaining fundamental data consistency. HTAP capabilities enable both transactional processing and real-time analytics on the same data, expanding possibilities for your applications.
High compatibility
Highly compatible with both Oracle and MySQL, covering most common features including advanced capabilities like stored procedures and triggers. Supports migration assessment and reverse synchronization to ensure safe data migration with minimal application changes.
Advanced compression technology
Utilizes LSM-Tree based compression engine, reducing storage costs by 70% - 90%.
Native multi-tenancy
Built-in support for multi-tenant architecture, allowing multiple independent business services within the same instance. Features complete tenant isolation with on-demand resource allocation and flexible management.
Multi-cloud and cross-cloud capabilities
Designed as a Database-as-a-Service (DBaaS) with an integrated data management platform supporting cross-cloud disaster recovery while maintaining consistent user experience across clouds. Eliminates vendor lock-in with current support for AWS, GCP,Tencent Cloud, Alibaba Cloud, and Huawei Cloud.