On Thu, Jan 31, 2002 at 10:46:39PM +0100, m.korse wrote: > I know abouts MySQL's Replication, but i don't think this will help me > > This is the situation: > > I'm working for a (small) company with 4 offices in different parts > of the country. I've constructed a database in mysql and made an > interface in PHP that should be accessible for all 4 offices. I > don't want to do this with a central server, becauz if the internet > connection fails, people can't work. So i'm gonna provide each > office with their own server, all with a copy of the > database. However, during the day i wan't to synchronise those > servers a few times with each other. > > I thought of doing this by making a cron job that will dump all the > data in a file and upload it to a central server. The data they work > with is office-specific; each office can read all the data from the > other offices, but only alter/update the data from it's own > office. So, the data/dumpfile being uploaded from a specific office > is only the data that that particular office can update. Once this > central server is updated by all four offices again with a cronjob, > i will upload the whole database (a dumpfile ofcourse) back to each > of the four offices.
That should work. > I've also thought about keeping track of the data that's being > inserted/updated by duplicating the database, so i'll have one > filled with data and one empty one, in which i can keep track of all > the insert/update queries (by writing some extra php-code that will > actually keep track of this, using the second database). I thought > this might be faster, since the dump file will be smaller, however i > can also see a lot of extra problems arise, doing it this way... Actually, you don't even need to dump the tables, if they're office-specific. You could rsync the raw tables between servers (provided you first flush them) without much trouble. > I hope you can understand it, i find it difficult to explain and > english is not my native language. Your english is quite good! Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 29 days, processed 657,775,483 queries (258/sec. avg) --------------------------------------------------------------------- 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
