goldengate同步mysql_Goldengate之Mysql到Mysql的同步

使用Goldengate完成Mysql到Mysql的数据同步，源库的o2m-mc库同步到目标库的gmdc库，表名GMQDSJSP

1、初始化

1)目标库创建数据库

mysql> create database gmdc; 2)导入数据

将源库表GMQDSJSP数据导出，然后导入到目标库中

mysqldump -uroot -p123456 --single-transaction --flush-logs --master-data=2 -B o2m-mc --tables GMQDSJSP > /tmp/GMQDSJSP20151021.sql

mysql -uroot -p123456 gmdc < /tmp/GMQDSJSP20151021.sql

2、源库

1)修改参数

在/etc/my.cnf的[mysqld]下添加如下参数

binlog_format=row重启

service mysqld restat

2)创建用户并授权

mysql> GRANT ALL PRIVILEGES ON `o2m-mc`.* TO 'ogg'@localhost IDENTIFIED BY 'ogg;

mysql> GRANT ALL PRIVILEGES ON `o2m-mc`.* TO 'ogg'@'%'IDENTIFIED BY 'ogg;

3)解压安装创建相应目录

unzip ggs_121210_Linux_x64_MySQL_64bit.zip -d /home/goldengate

cd /home/goldengate

tar xvf ggs_Linux_x64_MySQL