MySQL database synchronization
[email protected] (Don Cohen)
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
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/[email protected]