Data migration from embedded to external databases in HUMMIX On-Premises: customized utility

You can migrate data from databases within a Kubernetes cluster to external storages using:

The main steps of data migration using hummix-Backupper utility:

  1. Back up databases.
  2. Update HUMMIX application parameters.
  3. Restore databases.

Attention

After migrating databases to external storages, system reactivation is required.

Step 1: Back up databases

  1. Install the hummix-Backupper utility and set up its configuration. Read more about it in the Back up and recover databases article.
  2. Back up the HUMMIX application databases:

hummix-backupper backup <<db-type>>

Where <<db-type>> is the name of the database that you want to back up. Value options:

  • mongo specifies MongoDB.
  • postgres specifies PostgreSQL.
  • s3 specifies S3 storage.
  • all specifies all databases (MongoDB, PostgreSQL, S3).
     
    To specify two databases, you can combine the mongo, postgres, and s3 values by separating them with commas. For example, postgres,s3 or mongo,postgres.

Step 2: Update HUMMIX application parameters

  1. Since the hummix-Backupper utility gets the database path settings from the values-hummix.yaml configuration file, specify the values of external storages in this file.
  2. Update the HUMMIX application parameters using the values-hummix.yaml configuration file.

Updating parameters via the Internet

  1. Identify the version of the chart from which the HUMMIX application was installed or updated:

helm show chart hummix/hummix

 
Example of how to execute the command:

root@hummix-node1:~#
root@hummix-node1:~# helm show chart hummix/hummix
apiVersion: v2
appVersion: 2023.6.7
description: Hummix full application chart
name: hummix
type: application
version: 2023.6.7

 

The chart version will be specified in the version string. Save this value for the next step.

  1. Update the HUMMIX application parameters using the values-hummix.yaml configuration file. To do this, use the following command, specifying the installed chart version for the --version key instead of <hummix-chart-version>:

helm upgrade --install hummix hummix/hummix -f values-hummix.yaml --version <hummix-chart-version> --timeout=30m --wait [-n namespace]

 

Updating parameters without the Internet connection

 
Go to the folder with the downloaded HUMMIX chart and run the command:

helm upgrade --install hummix ./hummix -f values-hummix.yaml --timeout=30m --wait [-n namespace]

 
The parameter upgrade takes 10-30 minutes. Wait for it to complete.

 

Step 3: Restore databases

  1. Restoring from backup should be done to empty databases and S3 storage. So clean them with the --cleanup-databases key.
  2. Restore the databases from the last backup:

hummix-backupper restore <<db-type>>

Where <<db-type>> is the name of the database for which you want to get a list of backups. Value options:

  • mongo specifies MongoDB.
  • postgres specifies PostgreSQL.
  • s3 specifies S3 storage.
  • all specifies all databases (MongoDB, PostgreSQL, S3).
     
    To specify two databases, you can combine the mongo, postgres, and s3 values by separating them with commas. For example, postgres,s3 or mongo,postgres.
  1. Reactivate the system.

 

dump_db.html embedded-to-external-database-enterprise.html