Data Store and Backup Strategy

Nintex Solutions are based on micro-services design approach that uses several data storage solutions. This page will give you many different options for storing your data, and it will provide details, and explain the process, about how to backup and protect your data.

Data Storage Solutions

Data Storage Solution

Purpose

Store Type

MSSQL

RPA Main Data Store

SAN / Local Disks on Running Machines

RabbitMQ

RPA Queue Solution

Local Disks on Running Machines contain two types of data: definitions (metadata, schema/topology) and message store data

Seq

RPA Central Logging Solution

ClusterFS/NFS/Local Disks on Running Machines Seq contain two types of data:configuration and logs

Server Runtime OS

RPA Servers Runtime & Deployment OS

Local Disks on Running Machines

Robots (Clients) Runtime OS

RPA Robots Runtime & Deployment OS

Local Disks on Running Machines

Backup Strategy

Backing up your data, running test restore procedures on your backups, and storing copies of backups in a safe, offsite location protects you from potentially catastrophic data loss.

Backing up is the ONLY way to protect your data.

Data Storage Solution

Backup Details

Restore

MSSQL

Using MSSQL Backup Solution

Recommendation : Daily incremental backup and full weekly backup. Customers need to define a recovery model and act accordingly with the backups - full, incremental, snapshots, etc..

BACKUP DATABASE [KryonDB]
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\KryonDB.bak'
WITH NOFORMAT, NOINIT, 
NAME = N'KryonDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

USE [master]
RESTORE DATABASE [KryonDB]
FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\KryonDB.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 5
GO

RabbitMQ

Backup Rabbitmq data

Recommendation: Daily backup

rabbitmqctl export_definitions /path/to/definitions.file.jso

Backup messages using file system directory copy

All message data is combined in the msg_stores/vhosts directory and stored in a subdirectory per vhost.

restore definitions:

rabbitmqctl import_definitions /path/to/definitions.file.json

restore messages: using file system directory copy - restore the content of msg_stores/vhosts

Seq

Recommendation : Continue backup

Configuration:

Seq will automatically back up the configuration on a daily basis. The .seqbac files that are created are stored in the \Backups directory under the Storage root path.

Backups can be retrieved directly from disk, or downloaded from the web UI in Settings > Backups.

Logs Data:

Export in real-time using Seq.App.JsonArchive : https://github.com/datalust/seq-app-jsonarchive

Restore Configuration :

seq service stop
seq restore --secret-key="1234567abcdef=" --backup="C:\Data\seq_20150101.seqbac"
seq service start

Logs Data:

seqcli ingest --json -i <glob>.

Server Runtime OS

Regular OS Snapshot backup