Backup strategies

This page covers most popular backup strategies for Navixy platform. It is assumed that all components are running on one server, and the database is running either on the same server or on the separate one.

The platform consists of the following components, listed by their default install path:

If your Navixy platform runs on a VM or AWS instance, you can make a periodic snapshots of the machine, and additionally perform a MySQL dump. Creating a dump is required to maintain database consistency. You can find more information on MySQL dump below:

https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html

Both “google” and “tracking” databases should be backed up.
You can create MySQL dump on a runnig database without locking tables and interrupting the service by using –single-transaction option.

If you run Navixy on a physical server, you can backup the components only once after installation, and then once after each platform update, so you always have a latest backup of the backend and frontend components. Then, you only need to make a periodic database backups using MySQL dump.

Below is an example bash script that creates a MySQL dumps of both databases, passes it through gzip to reduce size, then deletes all backups in the backup directory older than 1 year. Feel free to modify the script according to your needs.

License key backup

When you planning backups for Navixy platform, and important thing to take into account is the license key. The key (also known as fingerprint) is updated against our license server approximately once a week. That means if you restore a backup which was made before the latest key update, the platform will not work and you will need to contact our tech support to get the new key.

To avoid this, we recommend backing up the license key separately from the main backup. They key can be selected from database using the following SQL query:

SELECT value FROM google.variables WHERE var='fingerprint';

The result is a simple text string which can be saved in a file, or in another database. We recommend backing up the key at least 2-3 times a day.

If you had to restore the platform from backup, you only need to write the key back into database, restart the services and the platform should start working:

UPDATE google.variables SET value='<your_key>' WHERE var='fingerprint';

Log in

Username

Password

Remember Me

Login

[clean-login]

Register

[clean-login-register]

Loading...

Loading...

We use сookies to improve our website, products and related services, analyze site traffic, and serve targeted advertisements. If you continue to use our services, you consent to our use of сookies. Read more