MySQL
      Back to home
      1. Help Center
      2. Integration Documentation
      3. MySQL

      An Overview of Unito's MySQL Integration

      Ready to start syncing data from MySQL? Here's everything you need to know.

      In this MySQL integration article:

      Unito syncs your MySQL data to other apps and tools automatically. All you have to do is create a flow that turns your rows into tasks, spreadsheet rows, tickets, or other work items.

      Note: Our MySQL integration is currently a Lite connector, which means it doesn't yet offer the full functionality of our other integrations. We'll be adding new features and functionality over the next few months based on demand.

      What does Unito sync from MySQL?

      Unito syncs records from your MySQL tables to other tools automatically and keeps data in sync in both tools. You can use this integration as a lynchpin to sync MySQL data to the rest of your tool stack.

      Which MySQL fields can Unito sync?

      Much like other integrations for spreadsheets and databases, Unito can sync all sorts of fieldsfrom your MySQL tables, mapping columns to fields in other tools. Here are the fields Unito can sync:

      • Id
      • Date
      • Date Time
      • Time
      • Timestamp
      • Year
      • Text
      • Boolean
      • String
      • Bit
      • Tiny int
      • Small int
      • Medium int
      • Big int
      • Integer
      • Float
      • Double precision
      • Decimal

      Rows are synced as individual work items. So if you sync a MySQL table with a Google Sheet, each row will become spreadsheet rows, populated with the information in each column.

      You can use any MySQL record in filtering rules, choosing from any available options.

      What counts as an item in sync?

      For MySQL, Unito counts every synced row as an item in sync.

      Things to keep in mind when connecting MySQL to Unito

      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.

      Limitations and other considerations

      Since this is one of our Lite integrations, you won't be able to do everything with MySQL that a full Unito integration can.

      • 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.