Create a database within your source MySQL instance:

mysql> CREATE DATABASE redtest;

Create a table within your source MySQL instance:

mysql> CREATE TABLE redtest.msg (id INT PRIMARY KEY AUTO_INCREMENT,msg CHAR(80));

Create a schema for the tables:

redshift> CREATE SCHEMA redtest;

Create a staging table within your Redshift instance:

redshift> CREATE TABLE redtest.stage_xxx_msg (tungsten_opcode CHAR(1), \
    tungsten_seqno INT, tungsten_row_id INT,tungsten_date CHAR(30),id INT,msg CHAR(80));

Create the target table:

redshift> CREATE TABLE redtest.msg (id INT,msg CHAR(80));

Insert some data within your MySQL source instance:

mysql> INSERT INTO redtest.msg VALUES (0,'First');
Query OK, 1 row affected (0.04 sec)

mysql> INSERT INTO redtest.msg VALUES (0,'Second');
Query OK, 1 row affected (0.04 sec)

mysql> INSERT INTO redtest.msg VALUES (0,'Third');
Query OK, 1 row affected (0.04 sec)

mysql> UPDATE redtest.msg SET msg = 'This is the first update of the second row' WHERE ID = 2;

Check the replicator status on the applier (host2):

shell> trepctl status

There should be 5 transactions replicated.

Check the table within Redshift:

redshift> SELECT * FROM redtest.msg;
1	First
3	Third
2	This is the first update of the second row