ClickHouse as storage engine for MySQL? An experimental approach

The text discusses an experiment on using ClickHouse as a storage engine within a MySQL environment. It explains the prerequisites and steps to configure both MySQL and ClickHouse, including creating structures in each database. The author then explores the possibility of connecting MySQL to ClickHouse using the Federated Storage Engine and highlights some limitations and overheads associated with this approach. Finally, it suggests a better approach where ClickHouse connects to MySQL for OLTP data and does OLAP queries all together in ClickHouse. The article concludes by stating that while it is possible to use ClickHouse as a storage engine within MySQL, the Federated Storage Engine requires more polish before being considered a good solution.