2.4 Supported Data Stores

MicroTx uses a data store to persist transaction records, service logs, and metadata.

Supported Data Store for MicroTx Workflows

MicroTx Workflows supports Oracle Database 19c and later as the data store.

Supported Data Store for MicroTx Distributed Transactions

MicroTx Distributed Transactions coordinator supports the following data stores.

• Oracle Database 19c and later
• etcd
• embedded LevelDB-based local storage
• in-memory storage

Oracle Database and etcd are centralized data stores. They provide shared, durable storage that can be accessed by all coordinator replicas. Use these storage types when you need a common external store for transaction state, recovery, and coordination across replicas.

The embedded LevelDB-based local storage type uses an embedded LevelDB-based store on the coordinator instance. When session affinity is enabled, requests for a transaction are routed to the same coordinator replica, allowing the embedded database to act as local persistent storage. This avoids the network hop and contention associated with centralized stores such as Oracle Database or etcd, and can improve transaction processing performance. The embedded database is suitable for production deployments that use session affinity and are designed around local coordinator storage.

The in-memory storage type stores transaction data only in memory. Use it for local development, testing, and samples. It is not intended for production because data is lost when the coordinator restarts.

For Oracle Database, you can connect to an on-premises Oracle Database or to an Oracle Cloud Infrastructure Database service. Supported Oracle Database environments include:

• Oracle On-Premises Database
• Autonomous Database for Transaction Processing and Mixed Workloads, shared or dedicated
• Bare Metal and Virtual Machine DB Systems in Oracle Cloud Infrastructure
• Oracle Exadata Cloud Service
• Oracle Exadata Cloud@Customer
• Oracle Real Application Clusters (RAC) 19c