Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

A failure with that parameter will only cause transactions committed in the last second to be lost. The DB won't require manual fixes.


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: