SecoBackup/S3SQL: Linux File System & Database Backup User Guide

Welcome

SecoBackup and S3SQL products have been unified. Now SecoBackup/S3SQL is a single product that provides automatic, scheduled and secure remote backup service for file systems (application and user files/directories) as well as MySQL databases to Amazon S3.

It's simple to install and configure. Simply download and install the SecoBackup client, select the directory or database you need to back up, and you will be set - all in less than 2 minutes!

Installation

To install, you'll need to download the latest version of the software. You can always download the latest version of the SecoBackup/S3SQL client software from this link:

http://www.secobackup.com/downloads3.html

Installation step-by-step

Once you have downloaded RPM or DEB file from the link above for your version of Windows/Linux, you will be prompted for the following steps. You will need to have root privileges in order to install the client, so make sure you are logged in as root/sudo first.

Installing the client software

Action: Uninstall the previous version using "rpm -e s3sql" and install the downloaded file using "rpm -i".
Note: On Debian and Ubuntu run the equivalent dpkg commands on the .deb file: "dpkg -i --force-architecture s3sql_..."

Welcome

Learning to use command line help

Action: "yes | s3sql --help | more"

Welcome

On the last page of the help output, you will find example of commonly used commands:

Welcome

Configure network and select software edition

Action: Choose 1 for Enterprise Edition (with support) or 2 otherwise. You may need to set the HTTP proxy, if necessary

Enable the account at Amazon S3

Action: You will be asked to get the activation key from Amazon AWS to activate your Amazon S3 account and this software. Use the URL below to get the activation key. You will need to log into Amazon.com or create a new account.


http://www.secobackup.com/activate.html





Sign-up and get the activation key from Amazon S3

Action: Once you sign up for Amazon S3 and S3SQL, you will see a page like the one below, copy the activation key on the right side and paste it in the command line window as shown below.




Action: Verify that you see the message "Successfully connected to Amazon S3." after entering the activation key. This is a confirmation that your activation process is complete and that SecoBackup is able to connect to your Amazon S3 remote storage.


Enter Encryption Key

Action: Leave blank to skip encryption. Enter an encryption key that SecoBackup will use to encrypt all data before it is remotely backed up. Note that this encryption is in addition to 128-bit SSL encryption which used for all communication with Amazon S3. You can skip by pressing Enter. If you choose an encryption key, please ensure that you dont forget it. If lost, it is not possible to decrypt your data.

Setup Filesystem Directories for Backup

Action: Add directories to the list of directories that SecoBackup keeps backed up at Amazon S3. Future updates or new files in those directories will automatically be backed up to Amazon S3.


By default, SecoBackup will look for changes to the directories every 300 seconds (5 minutes). Press enter to use this default. Then enter "0" to add a new directory to the list of directories being backed up.

Enter the name the directory you would like to be backed up to Amazon S3. We use a local directory "/root/backup" to save files we want to be backed up. You can set up any directory you would like to backup - say the directory that contains your applications web pages or Java code.

Use command "seco --status" to check for the status of your backup. It may take a few minutes for the files to be picked up by SecoBackup for backup.

If you are running X on your Linux server, you may launch the GUI interface for SecoBackup/S3SQL to monitor the upload of he files in the backup directory. This is the same interface that you may be familiar from our Windows SecoBackup product.

You could start or stop the SecoBackup service from your own script as follows:

/etc/init.d/s3sqld.init stop

/etc/init.d/s3sqld.init start

Launch the web browser by running -
$firefox http://127.0.0.1:9464/pages/searchs3.html

SecoBackup GUI web interface

Thats it. Configuration for directory backup is complete. You may go back and add more directories to be backed up using "seco --configure-directory"

Now see how simple it is to setup MySQL Backup

Setup MySQL for Backup

Action: Create a Backup Set to backup a MySQL database. Pick a name for the backup set (something that describes your database, blogDB, for example), enter the username, password and the schedule of how frequently backup should be performed. Please verify that the username, password and the hostname or IP address are all valid. You may run "mysql -u -p -h " and confirm that you are using the correct information for MySQL.


Perform a Test Backup to validate the settings

Action: Press Enter to continue on to running a test backup to verify the configuration.


Congratulations!

Action: Your setup for MySQL backup is complete. Your database will be automatically be backed up on the schedule that you selected. Congratulations and enjoy the peace of mind of top-notch High Availability of your data.


List all Backup Sets and the status of their last backup

Launching the GUI interface

If you are running X windows on the Linux server, you may want to monitor and configure Backup Sets. The GUI interface is available only when the URL is accessed from the local machine (as root or non-root accounts). Remote access is disabled for security reasons.



Restoring a database

Action: $seco --do-restore

Welcome

Deleting a backup set

Action: $seco --do-restore

Welcome Welcome

You are done! Enjoy the Security of S3SQL

There are many powerful capabilities of S3SQL that we have not convered in this installation tutorial. Use command line help to learn more about S3SQL capabilities or use the GUI to browse multiple Linux hosts and restore other databases


Need Help? Contact via email at support@secobackup.com