MySQL Connector > Replication tasks with MySQL > MySQL targets in replication tasks
  

MySQL targets in replication tasks

When you replicate data to a database target, the replication task truncates the table name in the target database if the source object name exceeds 128 characters.
The following table describes the target properties in a replication task:
Property
Description
Connection
Name of the target connection. Select a target connection or create a connection.
Target Prefix
String that prefixes the source object names to create names for the target objects in the target.
Note: For more information, see “Truncating Table Names” in the help for Tasks.
Load Type
Replicates full load of data from MySQL to other applications.
Delete Options
This property is not applicable for MySQL Connector.
You can also configure the commit size, which defines the number of rows to commit. If you do not specify a value, the Secure Agent uses the default value. Default is 10000.