Cross-post

    ClickHouse® and ProxySQL queries rewrite

    ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQL and its forks. Since September 2017 ProxySQL supports ClickHouse as a backend, so clients can connect to ClickHouse via MySQL protocol. In practice, this helps MySQL-aware…

    Analyze MySQL Audit Logs with ClickHouse® and ClickTail

    In this blog post, I’ll look at how you can analyze MySQL audit logs (Percona Server for MySQL) with ClickHouse and ClickTail.  Audit logs are available with a free plugin for Percona Server for MySQL. Besides providing insights about activity on…

    Archiving MySQL Tables in ClickHouse®

    Why Archive? Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. In this article Percona’s blogger Alexander Rubin is talking about archiving MySQL tables in ClickHouse for storage and…

    Aggregate MySQL data at high speed with ClickHouse®

    Feb 12, 2018There are multiple ways how ClickHouse and MySQL can work together. External Dictionaries, ProxySQL support or [realtime streaming] of MySQL binary logs into ClickHouse. A few weeks ago ClickHouse team has released mysql() table function that allows to…

    Big Data Analysis in Digital Marketing Research

    Dec 6, 2017Christian Hotz-Behofsits, Teaching & Research Associate at Vienna University of Business and Economics, is one of the creators of RClickhouse package for R that we have recently introduced on our blog. In this article he describes data analysis…

    ClickHouse® Primary Keys

    This is a cross-post from: (https://medium.com/@f1yegor/clickhouse-primary-keys-2cf2a45d7324) Special thanks to Alexey Milovidov, ClickHouse developer, for providing material for this article. Recently I dived deep into ClickHouse. ClickHouse is column-store database by Yandex with great performance for analytical queries. For example check…

    Massive Parallel Log Processing with ClickHouse®

    In this blog, I’ll look at how to use ClickHouse for parallel log processing. Below I’ll show how ClickHouse can be used to efficiently perform this task. ClickHouse is attractive because it has multi-core parallel query processing

    ClickHouse® AggregateFunctions and Aggregate State

    Jul 10, 2017   The guest article from ClickHouse evangelist Yegor Andreenko (@f1yegor) about an interesting extension of aggregate functions aggregate states, that can be used to pre-aggregate data that usually has to be kept in raw, like uniques.