-
Notifications
You must be signed in to change notification settings - Fork 13
Configuring mySQL binlog Change Data Capture Environment Configuration
Todd McGrath edited this page Oct 31, 2018
·
1 revision
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
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/