It's worth noting that ClickHouse and MySQL work quite well together. Clickhouse has a similar SQL dialect and can read data directly from MySQL. (Awesome feature BTW; in some cases queries even run faster that way.)
It's straightforward to build applications that do transaction processing in MySQL and analytics in ClickHouse. You can migrate data out of MySQL that does not belong there. You can also use CDC to mirror transaction data into ClickHouse for analytic processing. [0] The resulting applications are quite robust and have the advantage that different parts can scale independently.
Building applications that use the strengths of each of the component databases is a natural way to scale systems.
Disclaimer: I'm the author of the cited article and I work for Altinity.
It's straightforward to build applications that do transaction processing in MySQL and analytics in ClickHouse. You can migrate data out of MySQL that does not belong there. You can also use CDC to mirror transaction data into ClickHouse for analytic processing. [0] The resulting applications are quite robust and have the advantage that different parts can scale independently.
Building applications that use the strengths of each of the component databases is a natural way to scale systems.
Disclaimer: I'm the author of the cited article and I work for Altinity.
[0] https://altinity.com/blog/using-clickhouse-as-an-analytic-ex...