I am about to setup the following server layout using all Windows 2000
Server and XP Pro machines.
Master Server-----|
|------Branch Office Server -----|
| |- Machine 1
| | ...
| |- Machine N
|
|------Second Branch Office -----|
|- Machine 1
| ....
|- Machine N
Objective: Client needs to have read access to the data even if the
local lan goes down, so we
Are going to put a local copy of mysql on each desktop machine that is a
slave to the branch office
Server. Updates will always go to the master server when the Master
server is available. (We have
A way to deal with saving when the Master is not available)
Baically the branch offices are slaves to the master and the
workstations will slave to the branch office server.
I have the choice right now of using either MySQL 3.23 series or MySQL
4.0x series.
This will be deployed in just over a week so the path with the least
replication issues is the best
One for me. Keep in mind that the workstations may be shutdown nightly.
Can't control all the users;-)
Thanks in advance
Ross
PS the link from the master to the branch offices is a 10MB/Second
wireless link that is just being installed
And hopefully reliable.
---------------------------------------------------------------------
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
