Database Reliability Engineering by Laine Campbell

Author:Laine Campbell
Language: eng
Format: epub
Publisher: O'Reilly Media
Published: 2017-11-02T04:00:00+00:00

Number of rows impacted is greater than N

Alters on tables with a certain dataset size

Alters on tables stored in metadata as too busy to have live alters on them

New columns with defaults

Certain datatypes in create/alter statements such as BLOB (Binary Large Object) files

Foreign keys without indexes

Operations on particularly sensitive tables

The more flags and safeguards you put in place to enable safety in production for everyone, the more confidence you create in all teams. This results in development velocity. Now, let’s assume that our intrepid SWE who has checked in changeset 456 has had his change flagged due to an alter that is deemed to be impactful. At this point, he can use a migration pattern for that operation if it has been applied and documented. Otherwise, he should create one in collaboration with the DBRE team.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.