4 ms·
What are they doing during those 20 minutes? Define "maintenance window" - the DB becomes read-only? Or unreachable? This sounds insane to me.
by acchow 9y ago
What are they doing during those 20 minutes?
Define "maintenance window" - the DB becomes read-only? Or unreachable? This sounds insane to me.
- matt_wulfeck 9y agoNot usually, but it sometimes will go offline for 5 or 10 minutes or more. It fails over essentially.
- ReidZB 9y agoActions 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.
- falcolas 9y agoThat 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.
- snoman 9y ago> 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).
- deleted 9y ago[deleted]