Unsupported Features: MySQL
Here’s a breakdown of what Unito’s MySQL integration can’t do yet — and a few other considerations.
MySQL limitations
Section titled “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
Section titled “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.