Hello,

A lot of resources teach about how to set up MySQL replication, how to
use it ect.

But not many of them teach how to fail over instead of incident,
especially when master failed, how to promote slave into master -
automatically or minimize the delay, data inconsistency etc.

Are there any books/articles I should read for learning fail over
techniques (especially common enterprise practices)?

Thanks.