Skip to content

Instantly share code, notes, and snippets.

@asalimonov
Created November 16, 2018 10:16
Show Gist options
  • Save asalimonov/72554a2cb829b69dd2bc76e52db703ff to your computer and use it in GitHub Desktop.
Save asalimonov/72554a2cb829b69dd2bc76e52db703ff to your computer and use it in GitHub Desktop.
Configs for MySQL 5.7 (source DB) and AWS Data Migration service
#MySQL 5.7 has a bug in the engine. The MySQL as a source where it sends incorrect message to DMS task about the number of rows in a table. This will lead to not all data being loaded to the target database.
#Extra connection attributes for AWS DMS task
Resumefetchforxrows=0;unloadTimeout=36000
#Parameters for the source MySQL instance to increase the read and write timeout periods
net_read_timeout: 3600
net_write_timeout: 3600
wait_timeout: 86400
max_allowed_packet: 16777216
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment