Hacker News new | comments | ask | show | jobs | submit login

Is Amazon AWS the new reality distortion field? Gosh, just rent two dedicated boxes, one master, one slave, switch over to slave manually in the extreme rare case if the master fails and be done. This entire article screams "right tool for the job and this is not the right tool".

RDS with reserved instances / VPC and some security rules. A LOT of maintenance goes away.

Who is managing these two dedicated boxes at OS and app level. Who is managing the networking of these boxes, including a non-internet accessible network subnet and a an internet gateway to let a white listed developer host box connect to a dev instance of database with some sample data?

Using secrets manager, which handles key rotation seems to work great on AWS, how does this work on the rented boxes.

Who sets up the slave, confirms replication is current to slave etc.

Who does the backups of all of this (in case of a DROP table).

I used to do things the harder way with rented boxes. BUT every-time someone tells me oh - just rent some boxes and you could do X much cheaper I roll my eyes. X is always a massive subset on security, durability with a massive uncounted overhead in other areas (waste of time).

While I agree with you, "switch over to slave manually" just doesn't seem right. Who would monitor when to switch? Why would somebody want to monitor that? Having said that - there're probably solutions that allow switching when database is waiting for I/O

RDS doesn't fail over to a slave anyway. You would need to do that manually.

If you mean 'I ticked the multi-az box' that is only in the even that the AWS datacenter crashes - it will move RDS for you to another zone. If you have services that cache ip addresses from DNS, you will need to rediscover the database.

They probably don't mean "manually" just "explicitly", as part of an automated failure detection process.

I think it's also about that things grow. It's easy to set up one thing anywhere but then you may want more things connected to that thing. All of a sudden you want to focus on your app and not infrastructure problems.

AWS is expensive but for a company it's very cheap for the problems they avoid completely.

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | Legal | Apply to YC | Contact