[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: MySQL database synchronization
From:       "Ananda Kumar" <anandkl () gmail ! com>
Date:       2008-01-29 4:59:34
Message-ID: 829b199c0801282059pd1a5136v72db3c7f49d6c050 () mail ! gmail ! com
[Download RAW message or body]


Hi,
If you have 256Kbps should not be a problem as long as it used most for
mysql, if there are too may other user accessing net then it would be too
slow.

When you say, you want to access from both the sites, does it mean there
would be read and write from both sites or just read from from one site and
write from other sites.

If its just read from one site and read and write from other site then, you
can setup a master  where read and write happen and slave where only read
happens. Also, the slave can be used as a backup.

There are many third party software available where you can manually apply
bin-logs from one site to other, but this is little complicated and need
precise scripting taking care of all the bin-log position.

regards
anandkl




On Jan 25, 2008 4:17 AM, C K <shreeseva.it@gmail.com> wrote:

> I have a problem related with 2 mysql database synchronization. We are
> using
> a 256kbps internet at our mfg. site and a 2mbps internet connection at our
> HO. We are using MySQL5.0.45 for our ERP application. We want to work from
> both locations at a time through ERP software. For this we are trying to
> synchronize both servers are site and at HO. what will be the best
> solution
> for this?
> 1. Replication, (is it possible over 256kbps connection?)
> 2. Manual synchronization (using Navicat/SQLyog like software)
> 3. Using Binlogs (applying binlog to the another db)
> 4. any other
>
> We need urgent help regarding this.
> Thanks in advance and regards
> CPK
>
> --
> Keep your Environment clean and green.
>


[prev in list] [next in list] [prev in thread] [next in thread]