Ask HN: DevOps guides for HA SQL, load balancer, backups, on rented hardware?
I'm decent with Windows/Linux server management but would need to sink some good time into understanding how to glue everything together to have reliable, field tested hardware deployments.
I'm aware of AWS/Azure/Heroku and how they offer these bits of glue and take care of it for you.
As a devops/software developer/startup owner, I'm interested in understanding how to: 1) Deploy a highly available database (say Pg/MySQL) that has a simple master and slave
Looking at PgSql, there are tools like repmgr (http://www.repmgr.org) to handle replication, and other tools to then handle backups, but these aren't trivial. There's still complexity overhead.
How do I then automate moving a Virtual IP (VIP) so that app servers always point to the same IP for a database (so failover is transparent as possible)?
2) Automated backups of the database This seems to be easier, there are tools available that do log shipping to S3 etc.
3) Implementation of a load balancer I can rent hardware at Hetzner for handling web servers, but I can't easily load balance requests across the machines unless I setup a load balancer of some kind.
4) Firewalling/VPNing infrastructure so database servers etc are not publicly accessible (similar to Amazon security groups).
--
I'm interested in hearing any battle-tested deployment strategies anyone can offer insight into for these kinds of scenarios.
Is anyone able to share any resources, insights, experiences, or come up with other glue pieces that you need to roll on your own when not using a PaaS/IaaS provider?