I’m exploring syncing contacts from our proprietary database into Mautic. This will be a one-way sync, from our database into Mautic, not the other way around. The database has over 300,000 unique users and that number is growing quickly. What’s the recommended architecture for doing something like this?
- We run our internal system on PHP and MySQL so it would be easy to make additions/updates to the mt_leads table directly (our Mautic database is hosted on AWS RDS) but, while performant, that doesn’t seem right for a bunch of other reasons.
- I could use the Mautic API to check over the entire listing of contacts but it seems like it would be relatively slow and inefficient to check for changes on this many records via a REST API.
- I could try to make updates to Mautic in real-time as we make updates in our system but I don’t want to slow down our production system at all for this.
- I could run a cron job on our main system that uses the Mautic API to sync only records that have changes since the last cron job ran.
Option 4 is currently my best option but I don’t know if there are other options out there or someone has tackled this type of thing before and can offer some insight? What do you guys recommend?