AnsweredAssumed Answered

Best Practices for syncing two very large DBs

Question asked by Noah Hall on Sep 7, 2015
Latest reply on Sep 9, 2016 by peeter@cloudbee.com
We are currently syncing a number of tables in our production DB with sugarcrm (1 way):

  • about 5 tables
  • about 300K records
In the near future  the total records will grow to about 1 million records, and we will expand the to bi-directional syncing of data

This setup is currently being handled by a number of cronjobs (1 per table), and was a quick but not scalable solution to get our sugarcrm up and running.

Are they any ideas about syncing (in real time, or near-time) the two DBs? 

Outcomes