Sample Header Ad - 728x90

How can i replicate many database into one, by avoid primary key collision?

0 votes
1 answer
89 views
I have n number of databases and I have to collect data from those into one database. The databases has some specific value (e.g. currencies) which I want to update from the collector database(of course I want this to update for all databases). So in the first case I need to avoid primary key collision because i don't want to loose data. I think that setting up auto_increment.increment and auto_increment.offset, can do the trick, but in the second case i have to identify specific rows in all databases. What kind of technology and topology can I use?
Asked by Sarcasm (3 rep)
Jul 2, 2019, 09:19 AM
Last activity: Jul 2, 2019, 09:51 AM