Hi, ok, when im right now it would work with replication if I use different tables ? -> thats already done so, we have 3 Tables where new orders are stored (and costumerdates etc...) - and 12 tavles where products are in - but how could I connect them ? IN MySQL's replication FAQ and Manual its only talking about whole servers....
Wich benefits could Oracle (or PostgreSQL) offer in this problem ? Korbinian Bachl www.whiskyworld.de PS: the locations cant be the same - the server with the newest Product dates is a Workgroup server while the Internetserver is the one where costumers order on. -----Ursprüngliche Nachricht----- Von: indrek siitan [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 27. Dezember 2001 21:24 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: Why I will stay with Microsoft SQL Server 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 --------------------------------------------------------------------- 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
