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
--- Intercosmos Media Group, Inc. ---
www.intercosmos.comwww.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
