Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
2 blog posts in 13 categories

Hybrid OLTP/Analytics Database Workloads in Galera Cluster Using Asynchronous Slaves

Reporting and analytics is a common requirement, but should you run it on your production database? For Galera Cluster, heavy OLAP queries may interfere with the performance of regular OLTP operations. In this blog post, we’ll describe an easy way to offload OLAP workload from Galera Cluster to asynchronous replication slave.

Hybrid OLTP/Analytics Database Workloads: Replicating MySQL Data to ClickHouse

Columnar data stores provide much better performance for analytics queries than regular relational databases like MySQL. ClickHouse is an example of such datastore, queries that take minutes to execute in MySQL would take less than a second instead. In this blog post we show how to tackle the challenge of replicating the data from MySQL to ClickHouse.