Migrate Ambari Metrics Data

Use the following steps to migrate data from the previous AMS schema to the new AMS schema.

1. Ensure the Ambari Metrics System is started. If it is not, in the Ambari Web UI, click Ambari Metrics, then select Actions > Start.
2. SSH into a host that is running a Metrics Collector. You can locate this host by going to the Ambari Web UI and clicking Hosts. Click on the Filter icon and type in "Metrics Collector: All" to find each host that has a Metrics Collector installed on it.
3. SU to the Ambari Metrics user. This is 'ams' by default, but if you don’t know which user is configured in your cluster go to the Ambari Web UI and click Cluster Admin > Service Accounts, and then look for "Ambari Metrics User".

   # su ams

4. Run the command to migrate data from the old Ambari Metrics schema to the new.

   $ /usr/sbin/ambari-metrics-collector --config /etc/ambari-metrics-collector/conf/upgrade_start /etc/ambari-metrics-collector/conf/metrics_whitelist

   Note

   The default time period for data migration is one month (2592000000 milli seconds), which can be overwritten if required. For overwriting the data migration to more than one month, you must provide the timeframe upto which data need to be migrated along with the command. /usr/sbin/ambari-metrics-collector --config /etc/ambari-metrics-collector/conf/ upgrade_start /etc/ambari-metrics-collector/conf/metrics_whitelist "31556952000" "31556952000" is the amount of days in milliseconds to be preserved and 31556952000 stands for 1 year.

5. Once the upgrade process has started, logs are available in the <ams-log-dir>/ambari-metrics-migration.log file.