MySQL database synchronization

------=_Part_453_10769143.1201263595653
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

--
Keep your Environment clean and green.

------=_Part_453_10769143.1201263595653--

MySQL database synchronization

Obviously the best answer depends on your expected use.
I assume the two sites are supposed to use the "same" data.
Is there any reason not to use only one database and let one site
use it remotely? If one site requires much more bandwidth to the
DB than the other then put the DB at that site. Normally high
bandwidth is needed mainly for retrieving large sets of data.

C K writes:
> 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

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL database synchronization

On Fri, 2008-01-25 at 17:49 +0530, C K 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?)

If you're not doing lots of updates / inserts, then this should be more
than sufficient.

> 2. Manual synchronization (using Navicat/SQLyog like software)

I'd avoid this if possible. You want to have the data synchronised in
real-time, don't you?

> 3. Using Binlogs (applying binlog to the another db)

Same as above.

> 4. any other

Depending on the ERP software you're using, you may not need to have 2
servers. ie you may be able to have your remote office query the MySQL
server at your head office. This will only work if your software is
intelligent about how it selects stuff ( eg doesn't try to drag the
whole table across the network etc ).

As an example, I do development & testing of our in-house CRM package
from home. Until recently, this was connecting through a 512k DSL
connection, and it had remarkably good performance. Now I'm on DSL2+,
and it's pretty much like I'm at the office :)

> Keep your Environment clean and green.

True, that.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org