Replications need to be transactional

elliotchance / mbzdb

🎵 Port of the MusicBrainz database to run on other RDBMSs with replication (previously named MB_MySQL.)

88 stars 33 forks source link

Replications need to be transactional #29

Open chancemedia opened 13 years ago

chancemedia commented 13 years ago

If the update script is killed in between applying the replicated SQL and deleting it from dbmirror_Pending then the next time update.pl runs it will apply the replicated SQL twice, usually ending up in a unique violation.