database backup

@praveenarimbrathod @shafeek I believe a Master/Slave setup will be best option to backup the database, which is the most important part of a pod. Poddery database was around 5GB when we migrated to Knightswarm. So, dumping it all the time and moving to a different location doesn't seems to be a viable option.

Also, files can be backed up using tools like duplicity, which supports incremental backups through rsync and other protocols.

@shafeeqk we should ensure the data is encrypted on transport (mysql replication has that option) as well as storage (replication server should store its data on an encrypted partition.

steps for setting up an ssh tunnel is given here http://www.networkcomputing.com/servers-storage/how-to-set-up-ssh-encrypted-mysql-replic/229501820

@praveenarimbrathod I see. I backed up my pod database using mysqldump. I'll try setting up a slave for it and using SSH Tunnel. But for encrypted storage, don't we need a host that allows full disk encryption? Also, @manukrishnantv , should we detach the slave after it is set up to make sure that the data stays intact?

@shafeeqk , Sooraj has one server with full disk encryption setup. Manu has the access details.

@shafeeqk I'll be sitting with Sooraj today for fixing up few things in that server. Will share the details after that.

Lets create a script to detach the server for a while to create a SQL dump and reattach again.

Its high time we look into this seriously, as we are taking some decisions which might not be agreed by the governmental bodies, like the take on Islamic State creating an account in our pod (Still on voting).

@manukrishnantv we have to revisit it. What is the status of Sooraj's server?

The server is still up and running, but hosts Varnam build using Jenkins, and its log eats up lot of space. Last time when I checked, it had around 20GB free out of 80.

@manukrishnantv I think it is better to get a cheap scaleway vps at 2.99 euros. We can backup diasp.in as well there.