Settings for MySQL

This topic describes how to set up MySQL for DataSync.

In DataSync, create a new source connection for MySQL.
Fill out the fields in the New Connection dialog box as described below.
Click Save.

Connection Properties	Description
Description	Enter a name for the source connection.
Server	The host name or IP address of the server.
Database	Name of the MySQL database.
Port	Port number used by the MySQL database host. The default port is 3306.
Username	Enter the MySQL user account used to authenticate.
Password	Enter the password used to authenticate the user.
Convert zero-dates to null	Specifies whether or not to return Date and DateTime values consisting of all zeros as NULL. A value of all zeros indicates an invalid Date or DateTime value in MySQL. Retrieving such a value may cause parsing errors unless you enable this property.
Verbosity	The verbosity level that determines the amount of detail included in the log file. Verbosity levels range from 1 to 5; the default is 3.
Enable Pooling	This parameter enables connection pooling. When it is selected, the three following properties are displayed: Pool idle timeout: The allowed idle time for a connection before it is closed. Max pool size: The maximum number of connections in the pool. Pool wait time: The maximum number of seconds to wait for an available connection.

Additional Connection Properties	Description
Other	Specifies the number of seconds to wait for a block to be written to a connection before aborting the write process. This property is highly recommended when synchronizing a large amount of data (more than 500,000 rows). Enter net_write_timeout=numberofseconds as value; for example, net_write_timeout=3600.
Characterset	Specifies the character set name in the database collation. If the character set of the source database is different than the destination database, you will not able to add tables in the extractions. Examples of values: utf8mb4, latin1. Note: If you need to specify multiple values, you need to create multiple connections. The MySQL connector can only have one Characterset property per connection.

Additional Connection Properties

Description

Other

Specifies the number of seconds to wait for a block to be written to a connection before aborting the write process. This property is highly recommended when synchronizing a large amount of data (more than 500,000 rows).

Enter net_write_timeout=numberofseconds as value; for example, net_write_timeout=3600.

Characterset

Specifies the character set name in the database collation. If the character set of the source database is different than the destination database, you will not able to add tables in the extractions.

Examples of values: utf8mb4, latin1.

Note: If you need to specify multiple values, you need to create multiple connections. The MySQL connector can only have one Characterset property per connection.