Let’s say you have a datasource with multiple tables with a few Million rows each. A typical architecture will probably include some kind of an Analytics warehouse. For instance, AWS Redshift is a pretty good implementation and understands the PSQL dialect.
To keep the analytics data fresh, we need some way of shoveling data into that DB. In this scenario, we used
Mysql as the OLTP-style, main application Datasource and
Redshift as the analytics cluster.