I really miss a feature how to set up multiple masters...here my thoughts about it:
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? (sql,query ...sorry, only to bypass the spamfilter) --------------------------------------------------------------------- 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
