MySQL Table Primary Key Clashes
Here’s an interesting scenario I happened across the other day. What if you had a distributed system that used twenty MySQL databases, each one located in one of 20 US cities. Same database on each server, but each server has a different set of data. Now, what if you wanted to merge all of the data from all of the servers into one database? You’d have a problem with primary key clashes....