On Thu, 27 Dec 2001 11:08:26 +0100, "whiskyworld.de" <[EMAIL PROTECTED]> wrote: | > 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
Set-up ring replication, but in your case it would be a very short ring with only 2 nodes. Both computers would act as master and as slaves. You'll have a problem with auto-increment and maybe race conditions, so you need to be careful with it. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 <? Special Projects Programming Manager ?> --- Intercosmos Media Group, Inc. --- www.intercosmos.com www.directnic.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