3.7 Set Up Oracle Database as Data Store
Create a data store for MicroTx to store the transaction logs. You can use either etcd or Oracle Database as the data store.
Skip this section if you want to set up etcd as data store. See Set Up etcd as Data Store.
Before installing MicroTx, you must install and configure a data store. Ensure that you set up the required networking rules to allow communication between the transaction coordinator and the data store.
For details about setting up the Oracle Database, refer to the documentation that is specific to the database that you want to set up.
Ensure that you have the required permissions to create tables in the database. When you install MicroTx, the service creates the required tables in the database. So MicroTx requires certain details about the database.
Topics:
- Grant Privilege to Run Stored Procedures
The MicroTx coordinator creates a stored procedure when the service starts. If the Oracle Database user does not have the permission to create and run stored procedures, the service does not start. - Get Autonomous Database Client Credentials
MicroTx supports using Oracle Database as a persistent store to keep track of the transaction information. - Create Tables in Oracle Database
Create the tables and schema required by MicroTx in Oracle Database using a SQL script only if the Oracle Database user does not have the required privileges, such asALTERandDELETE. MicroTx creates tables automatically if the user hasALTERandDELETEprivileges. - Create a Kubernetes Secret for Oracle Database Credentials
MicroTx supports using Oracle Database as a persistent store to keep track of the transaction information.
Parent topic: Prepare