S3SQL: Linux User Guide

Welcome

S3SQL is a secure and automatic remote backup service for one or more MySQL databases and application files for Amazon S3. It's simple to install and configure. Simply download and install the S3SQL client, select the database you need to back up, and you're set to go!

Get your Online Storage Account at Amazon.com™

The first step is to get your Amazon.com&trade online storage account for the Community Edition of the product. Use your existing Amazon.com account (that you use for books and electronics!) to speedup the signup and simplify billing. SecoVault LLC and Amazon.com™ have partnered to offer you this service. Please select the appropriate type of account below:

Get Online Storage Account for
S3SQL: MySQL Database Backup



Get Online Storage Account for
SecoBackup: PC & Server Backup


Once you have completed the signup, you are ready to download the appropriate version below and get going in just a few minutes.

Installation

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

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

Installation step-by-step

Once you have downloaded s3sql RPM or DEB file from the link above, 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" and install the downloaded file using "rpm -i".
Note: On Debian and Ubuntu run the equivalent dpkg commands on the .DEB file.

Welcome

Learning to use command line help

Action: "s3sql --help"

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 S3SQL is able to connect to your Amazon S3 remote storage.


Enter Encryption Key

Action: Enter an encryption key that S3SQL 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 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.



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