/
Database - backing up and restoring it on Amazon EC2

Database - backing up and restoring it on Amazon EC2

Database Backups

Install backup manager to take regular backups of the Mifos X databases onto Amazon S3 buckets

Commands:

 

//Install Backup Manager

sudo apt-get install backup-manager

sudo apt-get install libnet-amazon-s3-perl 


//Modify Backup manager configuration file

sudo nano /etc/backup-manager.conf


//Locate and change the following properties with you actual S3 credentials

Make the following changes to it

export BM_ARCHIVE_METHOD=”mysql”

export BM_MYSQL_DATABASES=”mifostenant-default

export BM_MYSQL_ADMINLOGIN="root"

export BM_MYSQL_ADMINPASS=”password

export BM_UPLOAD_METHOD=”s3"

export BM_UPLOAD_S3_DESTINATION=”s3bucketname

export BM_UPLOAD_S3_ACCESS_KEY=”s3accesskey

export BM_UPLOAD_S3_SECRET_KEY=”s3secretkey

Note: - Yellow marked fields should be updated with respect to your settings.  


Automating the process can be as simple as adding a cron job for the mysqldump command. 

Cron Job for backups

Scheduling a cron job for taking periodic backups

Command:

 

sudo crontab -e


//select nano editor (easiest to work with)

//Schedule the job to run daily at 4 am in the morning

4 2 * * * /usr/sbin/backup-manager

 

 

Filter by label

There are no items with the selected labels at this time.

Related content

Mifos X Amazon EC2 Install Guide
Mifos X Amazon EC2 Install Guide
More like this
Configure Operational Structure of Group Methodologies
Configure Operational Structure of Group Methodologies
Read with this
Mifos X Database Backup and Restore
Mifos X Database Backup and Restore
More like this
Using REST client for passing api requests
Using REST client for passing api requests
Read with this
How to collect disbursement fee from savings account and disburse loan amount to savings account
How to collect disbursement fee from savings account and disburse loan amount to savings account
Read with this
How to Setup New Trail Instance
How to Setup New Trail Instance
Read with this