Implementing Change Data Capture using GCP DataStream

Create instance as shown above

mysql> CREATE USER ‘datastream’@’%’ IDENTIFIED BY ‘[YOUR_PASSWORD]’;

mysql> GRANT REPLICATION SLAVE, SELECT, RELOAD, REPLICATION CLIENT, LOCK TABLES, EXECUTE ON *.* TO ‘datastream’@’%’;

mysql> FLUSH PRIVILEGES;

mysql> SHOW GLOBAL VARIABLES LIKE ‘binlog_row_image’;

mysql> SHOW GLOBAL VARIABLES LIKE ‘log_slave_updates’;

mysql> SHOW GLOBAL VARIABLES LIKE ‘expire_logs_days’;

I am DWBI and Cloud Architect! I have been working with various Legacy data warehouses, Bigdata Implementations, Cloud platforms/Migrations. I am Google Certified Professional Cloud Architect .You can reach out to me @ LinkedIn if you need any further help on certification, GCP Implementations!

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store