Hi, > Regarding this situation, is it possible to setup a replication on > the same table between two servers, two way? > as in > i modify server a and server b replicates the table change > i then modify server b and server a replicates the table change
If you're talking about 2 different tables, e.g.: i modify table a on server a and server b replicates the change i then modify table b on server b and server a replicates the change then it's a piece of cake. Two-way replication of the same table however has some gotchas, mainly the indices - since there is a (in most cases we're talking about milliseconds, but still) tiny lag between the servers catch up to date again, there is a possibility of inserting conflicting entries on both sides at the same time and replication really can't decide which one to keep. Especially when you use auto_increment ID fields. If you're serious about replication and advanced MySQL use, you should consider participating in a MySQL training. The next one in Germany is 11-15.02 at Hamburg so you yet have time :-) Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Indrek Siitan <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia <___/ www.mysql.com --------------------------------------------------------------------- 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
