Not a lot in fact! It works perfectly under perfect operational circumstances. The problem is that few operational databases are perfect either in their schema design or configuration, often for pragmatic reasons like cost and performance.  General Issues Primary Keys: Ongoing replication requires a primary…