RE: Database Synchronisation Methods

["Rajesh Mehrotra" <rmehrotra@xxxxxxxx>]

Hi Paul,

You need to set up replication. Check
http://dev.mysql.com/doc/refman/5.0/en/replication.html

-Raj.

 

-----Original Message-----
From: Paul Ikanza [mailto:PIkanza@xxxxxxxxxxxxxxx] 
Sent: Tuesday, April 08, 2008 1:05 PM
To: 'mysql@xxxxxxxxxxxxxxx'
Subject: Database Synchronisation Methods

Hi All,
 
I am trying to figure out the best way to do database synchronisation. I
have my database at the head office and the application runs, partly at
remote/branch office. I am considering having a copy of the database
there but how can I have it synchronise in real time so that the
information is consistent when viewed from either side of the link at
all times?
 
Paul.


o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~o~
o
				DISCLAIMER
THE INFORMATION CONTAINED IN THIS COMMUNICATION IS CONFIDENTIAL AND 
MAY BE LEGALLY PRIVILEGED.IT IS INTENDED SOLELY FOR USE OF THE
INDIVIDUAL
 OR ENTITY TO WHOM IT IS ADDRESSED AND OTHERS AUTHORIZED TO RECEIVE IT.
 IF YOU ARE NOT THE INTENDED RECIPIENT YOU ARE HEREBY NOTIFIED THAT ANY 
DISCLOSURE, COPYING, DISTRIBUTION OR TAKING ACTION IN RELIANCE OF THE 
CONTENTS OF THIS INFORMATION IS STRICTLY PROHIBITED AND MAY BE UNLAWFUL
. NEW VISION PRINTING AND PUBLISHING LIMITED IS NEITHER LIABLE FOR THE 
PROPER, COMPLETE TRANSMISSION OF THE INFORMATION CONTAINED IN THIS 
COMMUNICATION, ANY DELAY IN ITS RECEIPT OR THAT THE MAIL IS VIRUS-FREE

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx