Unsupported Features: MySQL

Here's a breakdown of what Unito's MySQL integration can't do yet — and a few other considerations.

In this article:

• MySQL limitations
• Other MySQL considerations

MySQL limitations

• Table selection: Only tables with primary keys can be synced with this integration.
• Foreign keys: Foreign keys references are not normalized.
• Maximum rows: Only 10,000 rows can be synced by a Unito flow.

Other MySQL considerations

Before you start using Unito's MySQL integration, here are a few things to keep in mind:

• We recommend creating a new user with limited permissions for this connector, but note that these permissions are required for this integration to sync data properly:
  
  
  • INSERT
  • SELECT
  • UPDATE
  • DELETE
  • SELECT permissions on information_schema
• Although not required, it is recommended that you set up an SSL connection — you can learn how to do so here. Note that this connection requires the full CA chain in PEM format.