Altinity
ClickHouse Leading Service Provider

Blog

Posts tagged Clickhouse
Do-It-Yourself Multi-Volume Storage in ClickHouse

Mar 5, 2019
Many applications have very different requirements for acceptable latencies / processing speed on different parts of the database. In time-series use cases most of your requests touch only the last day of data (‘hot’ data). Those queries should run very fast. Also a lot of background processing actions happen on the ‘hot’ data--inserts, merges, replications, and so on. Such operations should likewise be processed with the highest possible speed and without significant latencies.

Read More
ClickHouse Meetup at Cloudflare. Recap

Feb 20, 2019
The ClickHouse Meetup at Cloudflare went great! It was a pleasure to see old friends and to meet new people enthusiastic about ClickHouse. Robert Hodges gave an intro talk about the ClickHouse execution model and how it contributes to rapid query responses. Alex Hofsteede walked through how Sentry.io uses ClickHouse and the steps they went through to migrate applications seamlessly onto ClickHouse from other solutions.

Read More
ClickHouse RoadMap 2019

Dec 17, 2018

The year 2018 approaches the end. It has been a great year for ClickHouse and the ClickHouse community -- a lot of events, new features and interesting projects. Now it is time to see what is next. ClickHouse development team lead Alexey Milovidov unveiled some plans and allowed us to share them with you.

Read More
ClickHouse Releases: Upgrade or not Upgrade

June 4, 2018
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 regressions. ClickHouse team certainly addresses problems in hotfix releases, but ClickHouse streamlined release version numbering makes it not easy to distinguish hotfixes from the feature releases. So how to decide is it safe to upgrade or not?

Read More
ClickHouse release 1.1.54380

Apr 25, 2018

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 latest 1.1.54380 version we think it may be a good candidate for the new stable release. Previous releases free from severe issues were aged 1.1.54292 and 1.1.54327.

ClickHouse 1.1.54380 is available in Yandex and Altinity repositories. So what's new and important in 1.1.54380 and previous release 1.1.54378.

Read More
Aggregate MySQL data at high speed with ClickHouse

Feb 12, 2018
There 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 access MySQL data directly from ClickHouse. This opens up a number of interesting capabilities. Accidentally we have found [a blog article in Japanese] by Mikage Sawatari‏ , that tests a new way of integration and translated it for our blog with some minor edits.

Read More