3 ms·
Please at least use a managed database. Treat that linode box like it might disappear at any moment. It is so easy to shoot yourself in the foot with a database
by cdoxsey 8y ago
Please at least use a managed database. Treat that linode box like it might disappear at any moment. It is so easy to shoot yourself in the foot with a database and lose everything.
Also FWIW configuring Linux machines manually over SSH and building and deploying your code too it, isn't always easier. Make sure you write everything you did down, because in 6 months you will completely forget how you built this thing, where it was deployed, etc...
- mark_l_watson 8y agoI have not done this for a number of years, but in the past for my own and customer projects I would just run Postgres on the same VPS as the web app but use a cronjob to write incremental backups every few hours to S3. As other people here have said, agreeing with you, paying for multiple availability zone RDS or paying Heroku is also a good plan.
- Cthulhu_ 8y agoAnd whatever you choose, TEST YOUR BACKUPS. Spin up a new instance and practice recovery. This needs to be done at least quarterly, both to test your backups and train yourself and/or your people in this process.
- mcshaggins 8y agoPlease write everything down and be kind to 'Future You'. I am very anti-spending money on software that isn't directly related to a project but a $10 confluence wiki lifetime license is one of the best purchases I have ever made.