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
of course you would have to start out with two identical tables before you started replication. but could you do this all on the same table? Thanks, Garrett Marone In the last episode (Thursday 27 December 2001 10:40 am), adam nelson wrote: Perhaps, reconsider you're layout. Even with mssql, you are not talking about an easy or cheap situation (you would need to get the advanced version of mssql I believe, which is mucho dinero x 2). Why can't both computers be at the same location (and even run off the same machine, leaving the other machine as a pure web server, no database). Just suggestions. Beyond that, if you really want the synchronicity, go for Oracle, MSSQL won't run on suse and at least you'll be in the same general technology as what you're using currently if you select oracle. -----Original Message----- From: whiskyworld.de [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 5:08 AM To: [EMAIL PROTECTED] Subject: WG: Why I will stay with Microsoft SQL Server > Hi All, > > well, since the discussion of the benefits Mysql vs. MSSQL has i've come > across a real Problem. Even if its a little bit off-topic (but only a little > bit...) - perhaps s.b. knows a solution: > > Ok, here we are: > > I'm the webmaster of www.whiskyworld.de - an online Store that sells whisky > (over 1600 products in common) - its running now on a LAMPS system based on > SuSE 7.2 - really fine - > > last week we received a new Local Server (Dell 1500SC) - (local here in our > small Company) - so now ive got the problem: How can i hold the data on the > server (located in another part of Germany) up-to-date ? at least the thing > is that there are some Products Tables that are newer here local while some > other tables are newer on the server (orders and costumer informations) - > i've read about REPLICATION in MySQL but this is only if 1 server is always > the more up-to-date one - and i need a via versa solution - > -> new whisky is in - > local is newer than server > -> new order is in -> server is newer than local > > i thought first of a selfprogrammed PHP solution because it then could > connect via SSL - in my opinion a secure solution - or ist there a ,well, > more comfortable possibility for this problem ? > > Greetings > > Korbinian Bachl > www.whiskyworld.de --------------------------------------------------------------------- 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 -- ------------------------------------------------------------------------ Things equal to nothing else are equal to each other. ------------------------------------------------------------------------ ------------------------------------------------------- --------------------------------------------------------------------- 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