database backup
Pirate Praveen
Public
Seen by 26
We need to back up database and Nitesh had volunteered to set it up.
Poll Created Mon 14 Mar 2016 7:00AM
Buy a cheap vps for backup Closed Sun 20 Mar 2016 6:37AM
Going ahead with creating backup on a scaleway vps.
We can get one for 2.99 euro per month https://www.scaleway.com/pricing/ This way we will have full control over the backup system as well. We can share it with diasp.in as well.
Results
| Results | Option | % of points | Voters | |
|---|---|---|---|---|
|
|
Agree | 100.0% | 1 |
|
| Abstain | 0.0% | 0 | ||
| Disagree | 0.0% | 0 | ||
| Block | 0.0% | 0 | ||
| Undecided | 0% | 40 |
|
1 of 41 people have participated (2%)
Pirate Praveen
Mon 14 Mar 2016 7:00AM
We've been dragging this for long, lets do it
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 · 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.