Is there in *nix an implementation of GUIDs? If the MS math is too 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 ----- 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
