Preparing for Amazon Redshift Replication

Preparing the hosts for the replication process requires setting some key configuration parameters within the MySQL server to ensure that data is stored and written correctly. On the Amazon Redshift side, the database and schema must be created using the existing schema definition so that the databases and tables exist within Amazon Redshift.

Source Host : Configure the source and target hosts following the prerequisites outlined in "Installation Prerequisites" then follow the appropriate steps for the required extractor topology outlined in "Deploying MySQL Extractors".

The following sections cover the requirements for replication to Amazon Redshift