Re: MySQL database synchronization
Daniel Kasak <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Organization | NUS Consulting |
| Message-ID | <[email protected]> |
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: [email protected] website: http://www.nusconsulting.com.au -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]