Dna database installation

Open Options built the V7 indexing utility so that it can be run from within the install smaller sites and as a stand-alone utility so that larger customer sites can perform this upgrade in a separate step prior to the main upgrade or as a scheduled task during off hours.

During the upgrade process of existing DNA Fusion servers, you will see the " Version 7 Upgrade Notice " dialog like the one shown here if your database contains more than 10 million records.

If your database contains less than 10 million transactions the upgrade will proceed and indexing will be automatic. No further action is required. If you do see this dialog, it is recommended that the DNA Fusion Indexing Utility be run prior to upgrade or scheduled as a task to run off peak hours.

This is adequate for the majority of sites and works well. The Aggressive scheme can provide much better performance, however that comes at a cost of disk space and indexing time. See below for more information. The utility shows the version of SQL the DNAFusion database is running under, current space used by database tables and indexes, and how many rows are currently in the Transactions table.

Time to index is dependent on numerous factors including version of SQL Server, current load, type and speed of the computer SQL Server resides on, memory allocations, etc. The following benchmark test was performed using SQL Server with 1. The Linux rsync utility must be installed. The C. UTF-8 locale must be installed. To confirm whether C. UTF-8 is installed, enter: localectl list-locales grep -i c. Have read and write permissions on the NFS export directory.

Have the C. UTF-8 locale installed. Rsync storage is the only available destination type for automation data backups. This procedure shows you how to set up both servers. Server Path Path to the folder on the server where the backup files are saved. Username Username used to protect the encrypted backup.

Password Password used to protect the encrypted backup. Encryption Passphrase Passphrase used to encrypt the security-sensitive components of the backup. Click Apply. Step 4 Click Apply. Both automation and Assurance data. Note If you have not yet configured a backup server, Cisco DNA Center requires that you configure one before proceeding.

Step 2 Click Add. The Create Backup pane appears. Step 3 In the Backup Name field, enter a unique name for the backup. Step 4 Click Create now to perform the backup immediately.

Step 6 Click Create. Note You can view the current backup status and the history of previous backups in the Activity tab. You can create a new backup only when there is no backup job in progress. Note If the backup process fails, there is no impact to the appliance or its database. Schedule Data Backups You can schedule recurring backups and define the day of the week and the time of day when they will occur.

The Schedule window appears. Step 4 Click Schedule weekly. Step 5 Choose the days and time for scheduling the backup. Step 7 Click Schedule.

Note You can view the scheduled backup jobs in the Schedule tab. Restore Data from Backups When you restore data from a backup file, Cisco DNA Center removes and replaces the existing database and files with the backup database and files.

The data that is restored depends on what is on the backup: Automation data backup: Cisco DNA Center restores the full automation data. You have backups from which to restore data. Step 2 In the Backup Name column, locate the backup that you want to restore. Step 3 In the Actions column, choose Restore. During a restore, the backup files remove and replace the current database.

Step 4 Click the Backups tab to view the results of a successful restore. Was this Document Helpful? Yes No Feedback. Enable and start the NFS server. Enter the following commands to add firewall rules to allow NFS: sudo ufw allow portmapper sudo ufw allow nfs sudo ufw allow mountd. Add the mountd port to services and to nfs. Enter the following command to restart the NFS services and firewall: sudo systemctl restart nfs-server rpcbind nfs-mountd.

IP address of the remote server that you can SSH into. SSH Port. Port address of the remote server that you can SSH into. Server Path. Path to the folder on the server where the backup files are saved. If you use a Mac or other type of operating system, DNA Master can be installed and run on an emulator like Virtual Box within a Windows virtual machine.

This guide can help you get your Mac set up with a Windows virtual machine. Follow the appropriate instructions in this Installation Guide. Once DNA Master is installed, you can follow the instructions in the Quick Start Guide on our Documents page to perform and explore a draft annotation.