beautypg.com

1 backing up sentral server and sentral console, 2 backing up sentral database schema, 3 backing up virtual machines and snapshots – ClearCube Sentral 6.9.3 User Manual

Page 31: 14 basic operations, Backing up sentral server and sentral console, Backing up sentral database schema, Backing up virtual machines and snapshots

background image

Sentral Quick Start Guide

24

Rev F 2.2.08.06.2014

13.1 Backing up Sentral Server and Sentral Console

ClearCube recommends backing up Sentral Server and console after making all configurations.

From the C:\Program Files\ClearCube Sentral\ directory, back up the directories shown below:

ClearCube Sentral Console

Tomcat

13.2 Backing up Sentral Database Schema

ClearCube recommends creating an automated daily or weekly backup of the database schema.

You can create a batch file that gracefully stops the console and server, backs up the database, and then
restarts the Apache Tomcat service.

The example below is a script you can use with Windows Scheduler that backs up a MySQL database.

Example 1. A script to back up MySQL database

echo OFF

TASKKILL /F /IM "javaw.exe"

NET STOP "tomcat7"

"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump" –u

-p --result-file="\\NETWORK-LOCATION\FILE%date:/=%.sql" cms

NET START "tomcat7"

Save the script above as a .bat file and schedule it to run using Task Scheduler, included with Windows
operating systems.

You can then use MySQL restore commands to restore the database if needed:

mysql --verbose --user=USERNAME --password=PASSWORD CMS < /PATH/TO/backupfilename.SQL>

13.3 Backing up Virtual Machines and Snapshots

When Sentral is installed on a virtual machine, it is a best practice to create a snapshot after completing all
Sentral configurations. The snapshot enables you to return to a known instance if it is ever necessary.
Additionally, it is a best practice to create backups of the Sentral Server virtual machine on a regular basis.

14 Basic Operations

The sections below provide instructions for basic Sentral tasks and explain how to install the Sentral
Host Agent on hosts (physical and virtual compute devices) that Sentral manages.