have a look into replication...might be what you realy need
http://dev.mysql.com/doc/mysql/en/replication.html
bastien
From: "Andri" <andri@xxxxxxxxxx> To: "PHP DB List" <php-db@xxxxxxxxxxxxx> Subject: database synchronization Date: Thu, 12 May 2005 14:09:51 +0700
Hello all, anyone can help me?
I have web based application running on php and mysql and installed on multiple sites. The data on those sites need to be synchronized (to have same data on every site after insert/update/delete action in each site). Currently im using an ftp server to handle synchronization, im using batch script to export and import data running on each site to the ftp server. but it still is a tedious job that requires constant monitoring, i need to have some kind of synchronization agent that can be installed on each site. Is there any tools for that?
Andri Junardi Ahmad IT Assistant Manager Tauzia International Management Wisma Adi Graha 17th floor Jl. Jend. Gatot Subroto Kav. 56 Jakarta 12950, Indonesia t. +62 21 5296 0490 f. +62 21 5296 0491 andri@xxxxxxxxxx
<http://www.tauzia.com>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
