News for hackers. Stuff that matters.
Re:When should I not kill -9 a process? by seunosewa on Saturday May 24, 2014 @10:50AM (#7793424)
A failure with that parameter will only cause transactions committed in the last second to be lost. The DB won't require manual fixes.
Re:When should I not kill -9 a process? by spudlyo on Saturday May 24, 2014 @11:29AM (#7793503)
The DB won't require manual fixes.

Losing a transaction that was committed upstream can lead to a bunch of manual fixes in replicated database clusters. What happens if rows inserted in that lost transaction are eventually updated? Replication breaks, you get paged, and now you're faced with either manually fixing the DB consistency error or by rebuilding the whole slave. Woe be unto you if this host is a replication hub with a bunch of slaves hanging off it.