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!
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:
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_..."
Learning to use command line help
Action: "yes | s3sql --help | more"
On the last page of the help output, you will find example of commonly used commands:
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.
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:
Launch the web browser by running -
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.
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
Deleting a backup set
Action: $seco --do-restore
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