ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
latest (15.4.0) 15.3.0 15.2.0 15.1.0 14.5.x 13.9.x 13.8.x 13.7.x 13.6.x 13.5.0 13.4.x 13.3.x 13.2.x
User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Metadata Backup

This article describes how to create database snapshots in ONE and how to restore data from a previous backup.

A data snapshot contains the complete contents of the MMM database. This includes:

  • The MMD schema.

  • All metadata, including configuration of rules and monitoring projects.

It does not include data from outside the MMM database, for example, ONE Object Storage files, job metadata, or the AI database.

A data snapshot is an emergency metadata backup solution primarily meant to restore the MMM database after failed upgrades and schema changes. It is not recommended for long-term backup because it only enables you to restore a portion of the system.

When you restore metadata from a previous backup in ONE, you lose all changes made to the MMM database since the backup. No data outside of the MMM database is affected.

Create a snapshot

To do this, the application must be in one of the maintenance modes: No Model, MD Mode, or MMD Mode. See Application Modes.

To create a backup, do the following:

  1. Go to Global Settings > System Changes > Database Backups.

    Database backups no model mode

  2. In Live database, select Create a snapshot.

  3. Enter a snapshot description and select Proceed.

    Create snapshot

  4. Wait for the snapshot to be created. How long this takes depends on the size of the data that is being stored. After the backup is created, it is available in Database snapshots:

    Backup created

Restore from a snapshot

To perform a full restore procedure the following access rights are required:

  1. Access to the MMM configuration. Typically, this is done through the Configuration Service User Guide.

  2. Access to the server.

    1. pg_signal_backend: For more information, see the official PostgreSQL documentation on SQL Command CREATE ROLE.

    2. createdb: For more information, see the official PostgreSQL documentation on Default Database Roles.

If you do not have the rights listed under 1 and 2, contact Atacama Support team.

To restore a backup:

  1. Go to Global Settings > System Changes > Database Backups.

  2. In Database snapshot, select Restore from snapshot.

  3. Enter a description and select Proceed.

    Restore from snapshot

  4. Wait for the data restore to complete. How long this takes depends on the size of the data that is being restored.

    After the data is restored, the Live database widget states that it was restored from a snapshot:

    Database restored from snapshot
    Any changes that were made after creating the snapshot are reverted after the database restore.

  5. Restore the Search Index. See Configure Full-text Search.

  6. Restore the Term Suggestions database. To do that, follow these steps:

    1. Open the MMM configuration. In this guide, configuration is handled using the Configuration Service User Guide.

      If you are not using the Configuration Service, the application.properties configuration file is usually found in be/etc directory. If this is the case, make sure to stop the MMM BE, Anomaly Detection, NLP Search, Term Suggestions, and MMM FE services before modifying the configuration. In addition, the MMM service also needs to be restarted after completing the step d.

    2. In the Configuration Service, edit the MMM (mmm-be) deployment and set the following properties:

      1. ataccama.one.term-suggestions.datasource.drop-first=true: Deletes the whole Term Suggestions database, including settings about learning strategies, learned knowledge about thresholds, and currently unprocessed feedbacks.

        If you want to preserve this, the following tables need to be backed up before continuing with the procedure and later restored: similarity_thresholds, learning_strategies, feedbacks.

      2. plugin.term-suggestions.ataccama.one.aicore.term-suggestions.init.recovery.data=true: Resends all the correct data from MMM to Term Suggestions database.

        metadata backup term suggestion database

    3. Click Deploy Property and wait until the configuration changes are applied.

    4. Remove the added properties and click Deploy Property again. This is required to avoid repeating restoring the data every time MMM is restarted.

    5. On your server, start the neighbors, recommender, and feedback microservices. The higher the number of profiled attributes, the longer it can take to refresh all suggestions.

Was this page useful?