Verifying your Redshift Installation

1. Create a database within your source MySQL instance:

   mysql> CREATE DATABASE redtest;

2. Create a table within your source MySQL instance:

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

3. Create a schema for the tables:

   redshift> CREATE SCHEMA redtest;

4. 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));

5. Create the target table:

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

6. 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;

7. Check the replicator status on the applier (host2):

   shell> trepctl status

   There should be 5 transactions replicated.

8. Check the table within Redshift:

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