SELECT
(On the tables that are to be loaded, usually all tables)REPLICATION CLIENT
REPLICATION SLAVE
RELOAD
SHOW DATABASES
(this is only necessary if the server was started with the --skip-show-database option)ROW
mode. You can follow these instructions to check if it's enabled and configure it if you are using your own MySQL server: https://debezium.io/documentation/reference/connectors/mysql.html#enable-mysql-binlog​ROW
in the parameter group settings for the cluster:BINGLOG_FORMAT
to ROW
call mysql.rds_set_configuration('binlog retention hours', 24);
staging_
for a table named orders
. The destination table name will be staging_orders
data.* as *
to your SQL statement. orders
, it will show up as split_orders
in Athena with the example given below. Click on NEXT.ENDING AT
as Never
will continuously read updates from your MySQL source.