On 6/1/06, Neeraj <[EMAIL PROTECTED]> wrote:
Hi all..
Hi, try not to put 8 line breaks on each paragraph please ;-)
I have a scenario of many client databases and one central database..
Implemented or project?
Is there any way to get a unique ids across all databases (by any way) , because records from all the databases are finally get stored on a central database. And the ids of transaction (a record) must remain unique in central database.
MySQL Cluster does this (I'm almost sure), but has some limitations in references and foreign keys, so, it depends on how your app will use the database, not long ago someone posted an intersting link: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html That explains how to avoid auto_increment field inconsistency with multiple slave/masters servers accross a network in an environment of replication. -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]