3 ms·
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 wo
by thspimpolds 12y ago
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.
- freework 12y agoIn my experience, any kind of DB replication is a bitch to set up. Definitely not worth the time for a one time thing.
- thspimpolds 12y agoI 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/setting_up_replication.html http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/set...
- IgorPartola 12y agoAutoincrements are only a small part of the problem. Unless, your database is append-only, alternating auto-increments are not going to help.