Maintaining a database

You can perform maintenance on a database, like reindexing, without stopping AS4 Microservice.

About this task

This task disconnects the data grid of an installation of AS4 Microservice from the database. Both the data grid and database store the same configuration information for AS4 Microservice. When the database is disconnected from the data grid, AS4 Microservice can save configuration information to the data grid but that information is not written to the database.

Enter all commands from the install_dir\Members\bin directory of the installation of AS4 Microservice>.

Procedure

  1. Enter the following command to see if the container member is running on the node where you are performing maintenance on the connected database:
    execute member list

    If the container member is not running, enter one of the following commands to start the member:

    • (Linux® and Windows) execute member start container
    • (Windows only) execute member start_service container
  2. Enter the following command to disconnect the data grid from the database:
    execute maint_mode enable <domainName>
    Use the domainName parameter to specify the domain that includes two or more data grids.
  3. Optional: Enter the following command to verify the maintenance mode status:
    execute maint_mode status
    If maintenance mode is enabled, the status shows as true.
  4. Perform the maintenance on the database.
  5. If necessary, start the database.
  6. Enter the following command to reconnect the data grid to the database:
    execute maint_mode disable <domainName>
    Use the domainName parameter to specify the domain that includes two or more data grids.
    The operation of AS4 Microservice with both the data grid and the database resumes. If any information was changed in the data grid while the database was being maintained, the changes are written to the database within 1 minute after the database is reconnected.
  7. Optional: Enter the following command to verify the maintenance mode status:
    execute maint_mode status
    If maintenance mode is disabled, the status shows as false.