On Mon, 30 Dec 2002, Arthur Fuller wrote: > Is there in *nix an implementation of GUIDs? If the MS math is to be > believed, GUIDs are guaranteed unique for the next century. No matter how > many monkeys are at the typewriters. Supposing a) that there is a *nix GUID > implementation, what's the right column type to use within MyISAM and > InnoDB? Assuming that anyone besides me finds this interesting, will MySQL > ever support GUID column types? > Arthur
Would it be possible to create a "limited" GUID for the purpose of our networks fitting into a BIGINT UNSIGNED 8 Bytes? Something like 4 bytes taken from the IP number and 4 bytes INTEGER UNSIGNED for counting? This would still be good for 4294967295 objects. Or restrict the mechanism from "global" to the internal (B or C) network and use 2 bytes for the host and 6 bytes for counting. 281474976710656 different items generated from each host would be sufficient for most applications. Any host generating those Network Unique ID's at a pace of 1000 per second could keep on doing so for nearly 9000 years ... Thomas Spahni > ----- Original Message ----- > From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > To: "Maxime LEMAIRE" <[EMAIL PROTECTED]> > Cc: "Mysql" <[EMAIL PROTECTED]> > Sent: Monday, December 30, 2002 10:56 AM > Subject: Re: replication > > > > On Mon, Dec 30, 2002 at 08:37:13AM +0100, Maxime LEMAIRE wrote: > > > Hi, > > > > > > I would like to know how mySQL manage the identity (auto increment > > > counter) in a replication environment when 2 servers are both master > > > on the same database. > > > > In that situation, you really need to generate your own primary keys. > > Using auto-increment with a dual-master setup is asking for trouble. > > It'll fail sooner or later, leaving you two servers that no longer > > agree on primary keys. > > > > Jeremy > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 3.23.51: up 15 days, processed 549,176,147 queries (411/sec. avg) > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
