Sunday, May 27, 2018

Streaming Data From MariaDB Server Into MariaDB ColumnStore via MariaDB MaxScale

DZone Database Zone
Streaming Data From MariaDB Server Into MariaDB ColumnStore via MariaDB MaxScale
Streaming Data From MariaDB Server Into MariaDB ColumnStore via MariaDB MaxScale

In this blog post, we look at how to configure Change Data Capture (CDC) from the MariaDB Server to MariaDB ColumnStore via MariaDB MaxScale. Our goal in this blog post is to have our analytical ColumnStore instance reflect the changes that happen on our operational MariaDB Server.

MariaDB MaxScale Configuration

We start by creating a MaxScale configuration with a binlogrouter and avrorouter instances. The former acts as a replication slave and fetches binary logs and the latter processes the binary logs into CDC records.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...