VISULOX database backup, restore and performance
Backup and restore
The database backup is always encrypted. The key is the VISULOX cluster key.
This means, that a new environment, where the backup should be restored needs the same cluster key.
Available commands of database.tcl:
| Command | Description |
|---|---|
| backup | Backup database to file (possible during operation) |
| compare | Compare table between nodes |
| fields | Display name of columns in table |
| integrity | Clean database |
| list | Stats about the database |
| query | Direct database query |
| restore | Restore file to database (VISULOX service has to be stopped) |
| -name <value> | A mask for the matching tables <*> |
| -info | Shows column names in tables |
| -node <value> | Node to connect database<> |
| -timeout <value> | Timeout <10> |
For example:
Backup
visulox database backupThe file will be extended with the time stamp and copied to the /tmp directory.
Restore
visulox database restore -path <path to file>It is possible to do the backup on node1 and restore the database on node2. All host related references will be converted to the new host. After restore the configuration is reloaded automatically (loadconfig).
If -force has to be used to backup and restore a database, the VISULOX Support should be involved.
Restore will overwrite the existing database.
Running (recorded) sessions will not be available in the VISULOX Cockpit after the database has been restored.
For restoring the database, VISULOX must be offline.
Database performance
The database status of a node or all nodes can be checked with:
visulox database integrity (only status)
visulox database integrity -repair (with confirmation)
visulox database integrity -repair -force (without confirmation)