Deploy a time-series database (Optional)

If you need OceanBase Migration Service (OMS) to collect and display historical monitoring data, deploy a time-series database (TSDB). This topic describes how to deploy a TSDB and the limits.

Limitations

• A TSDB can be deployed in OMS V2.1.0 and later. Currently, InfluxDB 1.8 is deployed as a TSDB.

• You need to use port 8086 to deploy a TSDB.

• A time series database (TSDB) supports only one-node deployment and does not support high availability. You need to deploy only one TSDB. You can deploy the TSDB and OMS on the same host. When the service fails, monitoring data becomes unavailable.

Procedure

1. Log in to the host where the TSDB is to be deployed.

2. Load the image of InfluxDB 1.8.

   Click here to download the InfluxDB image, and upload it to the host where the time-series database is to be deployed.

   sudo docker load -i ${influxdb_image}
   

3. Start the Docker container and ensure that data can be written to the mounted data disk.

   sudo docker run  -dit -p 8086:8086 -p 14444:14444 \
   -v {Mounted data disk}:/var/lib/influxdb \
   --env INFLUXDB_BIND_ADDRESS=127.0.0.1:14444 \
   --env INFLUXDB_HTTP_AUTH_ENABLED=true \
   --env INFLUXDB_HTTP_PING_AUTH_ENABLED=true \
   --name=oms-influxdb \
   influxdb:1.8
   

4. To enable authentication for the InfluxDB service, create an account and set the password.

   1. Go to the InfluxDB container.

      docker exec -it ${INFLUXDB_NAME} bash
      

   2. Go to the InfluxDB console.

      cd /usr/bin
      ./influx
      

   3. Create an account, set the password, and grant the admin permissions to the account.

      create user "${USER_NAME}" with password '${PASSWORD}' with all privileges
      

      Notice

      • You must first create the admin user in InfluxDB before you enable authentication.

      • Save the account and password for the configuration of the config.yaml file.

   4. Run the auth command.

   5. Run the show users command.

      To view the database, run the show databases command.

5. Exit the container where the TSDB resides.