Question 1

Which Front objects accept writes from MySQL?

Accepted Answer

Accounts and contacts, and nothing else. Create and update, create only, and update only are all supported. Deletes are not, so a record dropping out of your MySQL model will not cause anything to be removed from Front.

Question 2

What identifies an existing Front record?

Accepted Answer

Accounts on Front's ID, external ID or domains. Contacts on Front's ID or email address. Matching is equality or array membership against a cached snapshot of Front, so a non unique identity that happens to match several records can end up updating all of them.

Question 3

Which Front fields can the model set?

Accepted Answer

On accounts: name, which is required, plus description, domains, external ID at creation time, and custom fields. On contacts: name, description, spammer status, links, group names, emails and handles, and custom fields. Existing Front custom fields are discovered dynamically and typed for you.

Question 4

Are unmapped custom fields preserved?

Accepted Answer

No. Account updates merge the custom fields you mapped with the values already present, so anything unmapped survives untouched. If account custom fields are not appearing in the mapping at all, that is usually a permissions issue on the Front side rather than a problem with the sync.

Question 5

Why does the row count not predict the runtime?

Accepted Answer

Because Front's rate limit governs the pace, not your database. Polytomic reads Front's own rate limit header and throttles to eighty percent of it, writing in batches of two hundred and fifty with at most two concurrent jobs per connection, and retryable failures honour Retry After for up to a hundred attempts. The practical consequence is that a narrow model of five thousand rich rows finishes sooner than twenty thousand thin ones, so aggregate in MySQL before you write.

Sync MySQL to Front

Sync MySQL to Front with Polytomic

Accounts and contacts

Custom fields merged

Throttled to eighty percent

Or sync Front to MySQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect MySQL in Polytomic

Connect Front in Polytomic

Create a sync between MySQL and Front

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect MySQL with Front?