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:
|
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 useful when synchronizing a large amount of data. Enter net_write_timeout=numberofseconds as value; for example, net_write_timeout=3600. |