Skip to content

Configuring mySQL binlog Change Data Capture Environment Configuration

Todd McGrath edited this page Oct 31, 2018 · 1 revision

Config for OS X and Amazon RDS

Running on OS X with mySQL installed via homebrew

mySQL 5.7 running on OS X installed via homebrew

mySQL 5.7 binlog (CDC) worked with following

Updated /usr/local/etc/my.cnf

log-bin = mysql-bin
server-id = 1
default_time_zone='-06:00'

and restarted mysql

mysql.server restart

AWS RDS

mySQL 5.6 binlog (CDC) works with AWS RDS with the following

a) Need to configure ROW binlog format using a Parameter Group as described in AWS RDS documentation https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html#USER_LogAccess.MySQL.BinaryFormat

b) Needed to use the latest mysql JDBC driver 8.0.11. Older 5.1.46 version did not work.

One person reported the need to enable binary logging in RDS using https://blog.pythian.com/enabling-binary-logging-rds-read-replica/

Clone this wiki locally