On Mon, 18 Feb 2002 11:33:06 +0100 [EMAIL PROTECTED] wrote: > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > > I think the main problem with multiple masters are autoincrement values. > > The masters have to know each other. With the number of master it's easy > > to implement an extended autoincrement that uses the following formula: > > next_autoincrement_value=3Dlast_autoincrement_value + number_of_masters > > The start value could easily be dertermined by the sequnce of startup in > > combination of last_autoincrement_value of "coordinating master". > > In this way you can be sure not to have duplicated autoincrement values. > > Nevertheless the masters have to replicate among each other. > > > > Have i oversaw anything? Whats your opinion? > Don't forget that InnoDB for example supports foreign key statement and > transactions, which makes it much more complicated. What will happen if for > example one master host adds a record to the child table, and the other > deletes its master record? Rafal > -- > _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- > _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl > _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 > _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- >
-- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- --------------------------------------------------------------------- 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