MySQL Change Data Capture Setup on Amazon RDS with Streamkap
GTID
mode is ON
.
streamkap_user
. Streamkap will use this collection for managing snapshots.
streamkap_signal
in a new schema called streamkap
. It will not be recognised if given another name.binlog_format
parameter to the binary logging format of ROW
binlog_row_image
parameter to Full
CALL mysql.rds_show_configuration;
CALL mysql.rds_set_configuration('binlog retention hours', 72);
log_bin
parameter is ON
SHOW VARIABLES LIKE '%log_bin%';
. Result should be ON
SHOW BINARY LOGS
3306
)
streamkap_user
)
TIMESTAMP
values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. By default, the current time zone for each connection is the database server’s time zone but this option allows you to override that.As long as the time zones remain the same, you get back the same value you store.We recommend using the default SERVER
option which attempts to detect the session time zone from the values configured on the MySQL server session variables ‘time_zone’ or ‘system_time_zone’. It also reduces the chance of problems with daylight savings adjustment ‘fall back’ and ‘spring forward’.If either time zones change, an ad-hoc snapshot is recommended so your source and destination timestamps are consistent.public
. See Enable Snapshots for more informationbytes
)