RelocateMetricData

Overview

The Unified Assurance Relocate Metric Data Tool is a basic threaded application for moving metric data for a single device from one zone or shard to another in the Influx metrics database.

Prerequisites

Telegraf is configured to write to the raw retention policy only and requires additional configuration to write to the additional retention policies hourly and daily. The application sets a tag called rp, to daily or hourly, for data not in the default retention policy. Therefore, prior to running the tool some additional configuration is required to process the data written to the hourly and daily retention policies.

  1. A new configuration file, migrate.conf, should be created in $A1BASEDIR/etc/telegraf.d/ on each database server with the following configuration:

      ###############################################################################
      [[outputs.influxdb]]
              urls                   = ["https://$METRICHOSTFQDN:8086"]
              database               = "Metric"
              skip_database_creation = true
              retention_policy       = "hourly"
              tagexclude             = ["rp"]
              write_consistency      = "any"
              timeout                = "30s"
              tls_ca                 = "$A1BASEDIR/etc/ssl/BundleCA.crt"
              tls_cert               = "$A1BASEDIR/etc/ssl/User-assure1.crt"
              tls_key                = "$A1BASEDIR/etc/ssl/User-assure1.key"
    
              [outputs.influxdb.tagpass]
                      rp    = ["hourly"]
    
      ###############################################################################
      [[outputs.influxdb]]
              urls                   = ["https://$METRICHOSTFQDN:8086"]
              database               = "Metric"
              skip_database_creation = true
              retention_policy       = "daily"
              tagexclude             = ["rp"]
              write_consistency      = "any"
              timeout                = "30s"
              tls_ca                 = "$A1BASEDIR/etc/ssl/BundleCA.crt"
              tls_cert               = "$A1BASEDIR/etc/ssl/User-assure1.crt"
              tls_key                = "$A1BASEDIR/etc/ssl/User-assure1.key"
    
              [outputs.influxdb.tagpass]
                      rp     = ["daily"]
    
      ###############################################################################
    

    Note:

    Replace $A1BASEDIR with the appropriate installation directory (usually /opt/assure1) and $METRICHOSTFQDN with the appropriate server FQDN (e.g. hostname.example.com).

  2. Restart the telegraf service for the change to take effect.

  3. Run the RelocateMetricData tool.

  4. Once completed remove the migrate.conf configuration file.

  5. Restart the telegraf service for the changes to be reversed.

Administration Details

The following list shows the technical details needed for advanced administration of the application: