GGSCI> dblogin sourcedb ggdemo@localhost, userid root, password xxx
2016-08-06 07:53:25  WARNING OGG-00769  MySQL Login failed: . SQL error (2002). Can't connect to local MySQL 
server through socket '/tmp/mysql.sock' (111).
ERROR: Failed to connect to MySQL database engine for HOST localhost, DATABASE mysql, USER root, PORT 3306.

export MYSQL_HOME=/var/lib/mysql
export MYSQL_UNIX_PORT=/var/lib/mysql/mysql.sock

GGSCI (ip-172-30-3-204) 1> dblogin sourcedb ggdemo@localhost, userid root, password xxx
Successfully logged into database.

drop table tweet_tbl;
drop table tweet_target_tbl;

create table tweet_tbl(
id int primary key,
username char(8),
content varchar(25) ,
update_time timestamp);

create table tweet_target_tbl(
id int primary key,
username char(8),
content varchar(25) ,
update_time timestamp)
DEFAULT CHARACTER SET utf8mb4;

mysql> select default_character_set_name from information_schema.schemata s 
where schema_name='mysql';
+----------------------------+
| default_character_set_name |
+----------------------------+
| latin1                              |
+----------------------------+
1 row in set (0.00 sec)

mysql>  select T.table_name, ccsa.character_set_name
      FROM information_schema.TABLES T,
           information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
      WHERE ccsa.collation_name = T.table_collation
            AND T.table_schema = "ggdemo"
            AND T.table_name in ( "tweet_tbl", "tweet_target_tbl");
+------------------+--------------------+
| table_name       | character_set_name |
+------------------+--------------------+
| tweet_target_tbl | latin1            |
| tweet_tbl        | utf8mb4            |
+------------------+--------------------+
2 rows in set (0.00 sec)

extract extuni
SETEVN (MYSQL_HOME='/var/lib/mysql')
SETENV (MYSQL_UNIX_PORT='/var/lib/mysql/mysql.sock')
sourcedb ggdemo,userid root,password mysql
reportcount every 60 seconds, rate
exttrail ./dirdat/tt
TRANLOGOPTIONS ALTLOGDEST /var/lib/mysql/bin-log.index 
table ggdemo.tweet_tbl;

 replicat repuni
 SETENV (MYSQL_HOME='/var/lib/mysql')
 SETENV (MYSQL_UNIX_PORT='/var/lib/mysql/mysql.sock')
 targetdb ggdemo userid root password mysql SESSIONCHARSET utf8mb4
 map ggdemo.tweet_tbl, target ggdemo.tweet_target_tbl;

add extract extuni, tranlog, begin now 
add exttrail ./dirdat/tt, extract extuni, megabytes 5 
start extract extuni
info extuni 

dblogin sourcedb ggdemo, userid root, password mysql 
add checkpointtable ggdemo.tweetchkpt_tbl

add replicat repuni, exttrail ./dirdat/tt, checkpointtable ggdemo.tweetchkpt_tbl

start repuni
info repuni

mysql> insert into tweet_tbl values(1, 'jiwang', 0xF0A0B296, sysdate());
Query OK, 1 row affected (0.00 sec)

mysql> select hex(tt.content) as source_content, hex(tt.content) as target_content
from tweet_tbl ts, tweet_target_tbl tt;
+----------------+----------------+
| source_content | target_content |
+----------------+----------------+
| F0A0B296       | F0A0B296       |
+----------------+----------------+
1 row in set (0.01 sec)