Skip to main content

How to migrate Virtuozzo Automator Management Node database

  • Updated
Applies to:
  • Virtuozzo Server 7.x

 

Information

Virtual Automation uses MySQL database (on Linux) to store task logs, events, and alerts. In some cases, it is necessary to either migrate the data to another machine, or back up and restore the database on the local machine.

This article provides instructions on how to back up and restore a VA Management Node database.

NOTE: in case of migration the version to a new VA MN, both servers should be installed with exactly the same the version of Virtuozzo Automator.

To migrate/upgrade to Virtuozzo Automator 7, use the instructions from the upgrade guide.

Resolution

Backup (on source node)

  1. Stop VA services:

    ~# systemctl stop va-mn

  2. Dump tables data only:

    ~# mysqldump --skip-opt VZAgentDB | grep ^INSERT > inserts.sql

  3. Get the list of tables and views:

    ~# echo 'show tables' | mysql VZAgentDB | tail -n +2 > tables.txt

  4. Dump create statements:

    ~# for TABLE in `cat tables.txt` ; do echo "SHOW CREATE TABLE $TABLE" | mysql VZAgentDB | tail -n +2 | sed -e 's/^\w\+\s\+//i; s/\\n/ /g; s/$/;/;'; done > creates.sql

  5. Download attached script for sorting these statements, upload it to the server.

  6. Sort create statements:

    ~# perl sqldump_sort.pl creates.sql > sorted_creates.sql

  7. for migration only Pack data into archive:

    ~# tar -cvzf backup_pvamn.tgz sorted_creates.sql inserts.sql

  8. for migration only Copy data to destination server

Restore (on destination node)

  1. Stop MySQL service:

    ~# systemctl stop mariadb

  2. Back up all MySQL data:

    ~# tar -cvzf backup_mysql.tgz /var/lib/mysql

  3. Start MySQL service:

    ~# systemctl start mariadb

  4. for migration only Unpack data from archive:

    ~# tar -xvzf backup_pvamn.tgz

  5. Stop PVA services:

    ~# systemctl stop va-mn

  6. Drop VZAgentDB database:

    ~# mysql -NBe "DROP DATABASE VZAgentDB"

  7. Recreate it:

    ~# mysql -e 'CREATE DATABASE `VZAgentDB` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin'

  8. Restore database structure:

    ~# mysql VZAgentDB < sorted_creates.sql
  9. In case encounter a compatible error on p. 8 run the command and go back to p.6 
    ~# sed -i 's/utf8\tutf8_general_ci//g' sorted_creates.sql

  10. Restore database contents (it may take a while):

    ~# (echo "SET FOREIGN_KEY_CHECKS=0;" ; cat inserts.sql ) | mysql VZAgentDB

  11. Copy the whole /var/opt/pva/mn/etc/ directory from the old PVA Management Node installation to the new server in order to save previous settings.

  12. Start VA services:

    ~# systemctl start va-mn

Related articles