MySQL as a target

The MySQL target supports both cloud and on-premises databases. To connect to an on-premises database, your environment must have a self-managed Groundplex configured in the Classic Manager shared folder. Refer to Connect to on-premises endpoints for more information.

When you select MySQL, if AutoSync detects that a Groundplex is available, a dialog opens that enables you to select a cloud or on-premises database. For an on-premises database, you must select a Groundplex.

Supported load types

The MySQL target endpoint supports:

  • Full load
  • Incremental (insert new, update changed) load

Supported account types

To provide connection information, you can enter credentials in AutoSync or in the Classic Manager, as an account asset. The Classic Manager offers multiple account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list only includes compatible account assets. AutoSync supports the following Classic Manager account types:

Create your MySQL Account in Classic Manager or AutoSync Manager, using one of the following account types:

  • MySQL Database Account

Known limitations

  • MySQL credentials can't be created in AutoSync because they need an updated JDBC JAR file. As a workaround, create the Account in Classic Manager and specify the correct JAR file. Learn more about configuring MySQL Accounts.
  • If the source does not define precision for a column that AutoSync maps to a varchar type, AutoSync now creates columns with precision of 255 to avoid the MySQL row size limit.
  • If the source doesn't define precision for columns that AutoSync maps to a varchar type and values in the source have greater precision and scale than 255, the integration fails. AutoSync sets the precision to 255 to keep under the MySQL row size limit. Workaround: If a failure occurs, you can change the precision and scale in the source to be compatible with the default precision and scale.

Configuration

To configure MySQL as a destination:

  • Select existing credentials: From the dropdown list, select credentials created in Classic Manager.
  • Select schema: From the dropdown list, choose the source schema. AutoSync populates the list from your MySQL account.