News for hackers. Stuff that matters.
Re:Cloud Spanner is now production-ready by MichaelRenor on Tuesday May 16, 2017 @01:06PM (#14351229)
Especially considering that all of AWS database solutions require a 20 minute maintenance window per week!
Re:Cloud Spanner is now production-ready by Androider on Tuesday May 16, 2017 @01:52PM (#14351685)
The RDS service is literally scripted EC2 instances running MySQL/Postgres/SQL Server etc. Anything you do in the RDS console/API runs (or schedules) scripts on EC2 instances. If you would have downtime on any maintenance of your self-managed DB instance (say, upgrading the DB engine), so will RDS.

Some people get disillusioned at this fact, thinking RDS was something more magical. But AWS does offer the Multi-AZ option, which does the maintenance on the standby, fails over, and then performs the same on the main instance. It's effectively transparent. RDS also makes backups, restores (including point in time), encryption using KMS etc. really easy. If you don't have a full-time DBA, RDS provides for a very easy to use DB with virtually no maintenance required, but Multi-AZ is absolutely required for any kind of production deployment.

AWS's answer to Cloud Spanner is much more likely to be a future cross-region replicating version of DynamoDB or Aurora, not RDS.

Re:Cloud Spanner is now production-ready by snoman on Tuesday May 16, 2017 @03:07PM (#14352344)
As far as Multi-AZ is concerned, it's a bit of a wash. A month ago when the east coast had its issues, Multi-AZ didn't do anything. Every time I need to reboot an instance, with failover it is down/inaccessible for the same amount of time as if I had just rebooted it plainly.

I'm sure there's scenarios where it's worked well for people, but I've never seen it happen.

Re:Cloud Spanner is now production-ready by brianwawok on Thursday May 18, 2017 @08:23AM (#14366609)
I see multi region saves many disasters. Multi AZ seems a waste. What percent of failures only hit 1 AZ? Your loss is for sure (higher latency, bandwidth cost).... unclear what the real world gain is of multi AZ.
Re:Cloud Spanner is now production-ready by acchow on Tuesday May 16, 2017 @01:10PM (#14351265)
What are they doing during those 20 minutes?

Define "maintenance window" - the DB becomes read-only? Or unreachable? This sounds insane to me.

Re:Cloud Spanner is now production-ready by ReidZB on Tuesday May 16, 2017 @01:16PM (#14351332)
Actions that require database downtime/restarts can happen during the maintenance window. For example, if you change a DB parameter that requires a database restart, you can tell AWS to restart the DB during the next maintenance window. Same goes for DB engine upgrades and the like.

If you're running anything production-worthy, you'll be using one of AWS's multi-AZ/failover solutions for your production RDS instances. In that case, the database will perform a failover in those instances so there isn't downtime.

Re:Cloud Spanner is now production-ready by falcolas on Tuesday May 16, 2017 @01:36PM (#14351529)
That depends on the parameter being changed; not all parameter changes are compatible with block level replication. Such as the MySQL InnoDB log file size, something that needs to be changed on every instance.
Re:Cloud Spanner is now production-ready by snoman on Tuesday May 16, 2017 @03:09PM (#14352358)
> In that case, the database will perform a failover in those instances so there isn't downtime.

Have you done that? I have and there's been downtime every time (~5m).

Re:Cloud Spanner is now production-ready by matt_wulfeck on Tuesday May 16, 2017 @01:12PM (#14351278)
Not usually, but it sometimes will go offline for 5 or 10 minutes or more. It fails over essentially.
Re:Cloud Spanner is now production-ready by ReidZB on Tuesday May 16, 2017 @01:11PM (#14351275)
That doesn't mean they're unavailable for 20 minutes weekly, probably because of the nature of AWS's multi-AZ RDS setup.

At our shop, we haven't had any problems with RDS maintenance at all -- and we would indeed get paged for even 1 minute of database downtime, much less 20 (!). That said, we don't have that sort of monitoring in place for any of the test/staging DBs (which are not multi-AZ).

Re:Cloud Spanner is now production-ready by BillinghamJ on Tuesday May 16, 2017 @01:13PM (#14351299)
That's a window when they _can_ do maintenance, it's pretty rare for them to actually do it.
Re:Cloud Spanner is now production-ready by gtirloni on Tuesday May 16, 2017 @01:15PM (#14351326)
The SLA document [0] says 99.95% so perhaps you meant per month?

0 - https://aws.amazon.com/rds/sla/

Re:Cloud Spanner is now production-ready by MichaelRenor on Tuesday May 16, 2017 @01:31PM (#14351488)
You see the trick here, that's 99.95% outside of their regularly scheduled maintenance!
Re:Cloud Spanner is now production-ready by gtirloni on Tuesday May 16, 2017 @03:35PM (#14352549)
Oh! Now I see. I haven't used RDS for anything critical yet but thought it'd be a no-brainer.

insert mind expanding gif

Re:Cloud Spanner is now production-ready by MichaelRenor on Tuesday May 16, 2017 @04:38PM (#14353104)
In practice it works just fine. They just make you give them permission to blow your app up for twenty minutes a week (and wink and say maybe they won't actually do it this week).
Re:Cloud Spanner is now production-ready by d4rti on Wednesday May 17, 2017 @10:56AM (#14359015)
With respect to SLA's the two important things in my opinion are:

* How precisely is it measured? * What happens if it is not met?

As observed by the other posters, scheduled maintenance doesn't count.