CDC and Database Replication with Upsolver

Learn how to build a replication pipeline for MySQL, Postgres or MariaDB

1. Replicating a MySQL Database

2. Replicating a PostgreSQL database

3. Replicating a MariaDB Database

Replicating a MySQL, MariaDB or PostgresDB Database

Relational databases hold critical company information that can be combined with big data for analytics insights.  However, you need to get this data into your data lake first, in a way that is efficient, timely, and doesn’t interfere with the operations of the source database.  

You can use the Upsolver change data capture (CDC) source connector to create an always up-to-date copy of your database in your data lake. After the initial replication, the connector uses the source database transaction log to stream changes to the data lake without interfering with database operations. The replica is now available for use by a data lake query engine or further processing and output to your data warehouse or other analytics systems. 

These short interactive exercises will illustrate how to easily connect your RDBMS to AWS Athena. We will query the Views in Athena as the CDC data is streaming in, thus providing a very simple solution to database replication into your data lake using Upsolver.

Like What You See?

Run Upsolver on your data now

Start for Free

Take Upsolver for a spin with our free-forever Community Edition. No credit card required!

Launch Upsolver

Talk to an Expert

Schedule some 1-on-1 time with our solution architects for some free tips on building better data architecture.

Schedule a Call

Templates

All Templates

Explore our expert-made templates & start with the right one for you.