In the following sections, the term "self-managed" applies to any database that is installed either on-premises or on Amazon EC2.
These prerequisites apply to either self-managed or Amazon-managed sources. The role needs the following privileges:. In other words, full-load-only tasks don't require this privilege.
You must enable binary logging if you plan to use change data capture CDC. Don't include the file extension. Set this parameter to a value of 1 or greater. To prevent overuse of disk space, we recommend that you don't use the default value of 0. If your source uses the NDB clustered database engine, the following parameters must be configured to enable CDC on tables that use that storage engine.
Set this parameter to ON. This value ensures that changes in clustered tables are logged to the binary log. Set this parameter to OFF. This value ensures that the binary log contains the entire row and not just the changed columns. You must enable automatic backups. Because Amazon-managed MySQL-compatible databases purge the binary logs as soon as possible, you should increase the length of time that the logs remain available.
For example, to increase log retention to 24 hours, run the following command. Columns are always added to the end of the table. CDC is not supported when a table name contains uppercase and lowercase characters, and the source engine is hosted on an operating system with case-insensitive file names. Capturing changes when the binary logs are not stored on standard block storage is not supported. The task ends successfully, but the target might be out of sync with the source.
If this happens, either restart the task or reload the affected tables. Indexes created on a portion of a column value aren't migrated. You can use extra connection attributes to configure a MySQL source.
You specify these settings when you create the source endpoint. Multiple extra connection attribute settings should be separated from each other by semicolons. Specifies the time zone for the source MySQL database. Timestamps are translated to the specified timezone. Valid values are the standard time zone abbreviations for the operating system hosting the source MySQL database. The migration task continues running regardless if the SQL statement succeeds or fails.
One or more valid SQL statements, set off by a semicolon. The UTF-8 4-byte character set utf8mb4 is not supported and can cause unexpected behavior in a source database.
Set this parameter to ROW. Set this parameter to NONE. Set this parameter to FULL.