Switch to the standby database

This topic describes how to switch to the standby database and retain complete data in the primary database when the primary database fails.

Procedure

1. Run the following command to enter the Docker container.

   docker exec -it ${CONTAINER_NAME} bash
   

   Note

   CONTAINER_NAME specifies the name of the container.

2. Execute the following script in the root directory:

   sh docker_update_meta_db.sh
   

3. In the step of modifying the configurations of the MetaDB, enter the IP address, port, username, and password of the MetaDB as prompted.

   You can modify the configurations of the MetaDB for a MySQL database or a MySQL tenant of OceanBase Database to store the metadata generated during the running of OMS Community Edition.

4. Wait for the automatic completion of the step to modify the configuration file of links to component libraries of OMS.

5. Make a choice in the step of determining whether to initialize tables in the MetaDB.

   • You can enter y and press Enter to automatically create tables required for metadata of OMS Community Edition in the standby database.

   • You can enter n and press Enter to choose not to create tables, if the tables required by OMS Community Edition already exist in the standby database.

6. Wait for the components to restart.