ClickHouse

    Tableau with ClickHouse®

    ClickHouse users often require data to be accessed in a user-friendly way. There is a number of tools that can display big data using visualization effects, charts, filters, etc. Tableau is one of the popular ones. In this article, we…

    Realtime replication from MySQL to ClickHouse® in practice

    July 2, 2018Vladislav Klimenko from Altinity and Valery Panov from Ivinco presented a talk at HighLoad Siberia 2018 conference recently. They described the real problem that Ivinco faced and how it has been solved with migration of analytics from MySQL…

    ClickHouse® Releases: Upgrade or not Upgrade

    ClickHouse team has released 1.1.54385 version recently. This is yet another bugfixing update in a row of small updates that followed 1.1.54378 release from mid-April. Unfortunately, ClickHouse test coverage is not perfect, and sometimes new features are accompanied by disappointing…

    ClickHouse® + Graphouse introduction

    A few weeks ago we described how to setup ‘ClickHouse monitoring with Graphite’. Today we are going to look at this from a different angle: how ClickHouse can be used as a Graphite backend.

    Circular Replication Cluster Topology in ClickHouse®

    In some cases, there is a need to configure a distributed cluster with replication but there are not enough servers in order to place every replica on a separate node. It is better to have multiple replicas at the same…

    ClickHouse® Meetups at Bay Area. Recap

    We would like to thank all attendees, our great partners, talented speakers, and generous hosts, who made these events possible and successful!Presentations from meetups are published here.

    ClickHouse® release 1.1.54380

    ClickHouse team and community contributors actively develop ClickHouse adding many new features, improving performance and flexibility. Unfortunately, sometimes it affects stability of the product. We were very upset by some unexpected regressions in recent ClickHouse releases. After initial testing of…

    ClickHouse® Monitoring with Graphite

    Monitoring is an important part of operating any software in production. The proper monitoring solution needs to store metrics somewhere as well as provide visualization capabilities. ClickHouse does not have such a tool packaged, but there are several 3rd-party monitoring…

    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…

    Bay Area ClickHouse® Week is Coming (Apr 23-27)

    Great news for San Francisco Bay Area: ClickHouse is coming. The week of April 22nd is going to be entertaining for ClickHouse adopters and newcomers: Percona Live conference talks, two ClickHouse meetups, meetings with ClickHouse developers and Altinity team –…

    ClickTail Introduction

    Altinity is happy to introduce ClickTail — an easy to use tool for ingesting log file data into ClickHouse and making it available for exploration. Its favorite format is JSON, but it understands how to parse a range of other well-known log…

    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…