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/

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.