database backup
Pirate Praveen
Public
Seen by 293
We need to back up database and Nitesh had volunteered to set it up.
Pirate Praveen Mon 14 Mar 2016 6:56AM
@manukrishnantv I think it is better to get a cheap scaleway vps at 2.99 euros. We can backup diasp.in as well there.
Manu Krishnan T V Mon 14 Mar 2016 7:18AM
I haven't tried Online.net's services yet, but they have been there for a while and offer cheaper servers.
The 2.99 euro server comes with a 50GB SSD. Additional volumes can be mounted at 1 Euro per 50GB, which seems cheap.
Meanwhile, a 100GB on Amazon S3, will cost just above 2$, on pay as you go. So, there are alternatives.
Pirate Praveen Mon 14 Mar 2016 7:21AM
@manukrishnantv but Amazon is US based, it doesn't make sense to backup in US when we specifically chose non-US provider for main service.
Pirate Praveen Sun 20 Mar 2016 1:47PM
Finally after a whole day's effort we have full backup of poddery.com
- backup.poddery.com is running on a Scaleway.com C1 VPS (arm soc).
- /var/lib/diaspora is a 50GB encrypted disk
- mysql replication uses an ssh tunnel to poddery.com so replication is encrypted. sshtunnel user is created on both servers. Can someone create a systemd service to start this tunnel automatically before mysql?
- an hourly cron job will rsync diaspora/public/uploads to /var/lib/diaspora/uploads.
http://fosscommunity.in/index.php?title=Poddery has some initial documentation. Someone please verify the backup is working and ask me if the docs are not clear on any point.
Manu Krishnan T V · Tue 16 Feb 2016 2:34PM
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.