Hacker News Reader

Call me crazy but why didn't you just do MySQL dual master auto increment numbers (one on even, one on odd) and then setup replication from old to new?

That would have solved everything in one step.

View on HN

Autoincrements are only a small part of the problem. Unless, your database is append-only, alternating auto-increments are not going to help.

In my experience, any kind of DB replication is a bitch to set up. Definitely not worth the time for a one time thing.

I can set that up in about 10 steps including dumping db, setting up the offset, importing the db, and setting up reverse replication if you desire. Its super super easy.

This is 6 of the steps: http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/set...

Reply on news.ycombinator.com