Altinity
ClickHouse Leading Service Provider

Blog

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
Altinity Stable ClickHouse 18.14.15 Release Notice

Nov 28, 2018

Altinity is happy to introduce ‘Altinity stable’ ClickHouse release marking. Altinity stable releases undergo additional testing from our side, we carefully monitored community feedback for any issues, as well as operated such releases in some heavy loaded production systems.

That being said, Altinity announces ClickHouse 18.14.15 release as Altinity stable. Read more for release notes.

Read More
ClickHouse Crushing Time Series

Nov 15, 2018

Once upon a time we spotted TSBS (https://github.com/timescale/tsbs) -- Time Series Benchmark Suite, started by InfluxDB engineers and polished to perfection by TimescaleDB team. The suite allows to compare apples-to-apples when testing different databases: it is a framework to generate test data, load it to different databases, run test queries, and collect statistics to analyse. We could not resist adding ClickHouse to the list of supported databases. It turned out that ClickHouse --- being a general purpose analytical DBMS -- stands very well against proven time series databases. Those benchmarks highlighted strengths and weaknesses of different technologies. Interested? Let’s dig into details.

Read More
Autumn's Newsletter

Nov 5, 2018

It's been a while, but we promise we've been busy. Since our last update, ClickHouse grew up a lot, there were many new features and enhancements, some of them we reviewed in our blog, others are still waiting for somebody to tell a story about. In this newsletter you can find the latest updates.

Read More
ClickHouse Meetup in Paris Recap

Oct 19, 2018

October for us started strong with a successful ClickHouse meetup in Paris. The purpose of the event was to talk about ClickHouse, an open-source column-store analytics DBMS – its features, roadmap, use cases, meet local ClickHouse users, hear talks from ClickHouse lead developer Alexey Milovidov, Altinity CTO Alexander Zaitsev and Paris ClickHouse users.

Read More
Updates and Deletes in ClickHouse

Oct 16, 2018

It’s been two years already ago when ClickHouse development team published an excellent blog post “How to update data in ClickHouse”. In that old times ClickHouse supported only monthly partitions, and for mutable data structures, they suggested to use pretty exotic data structures. We were all waiting for a more convenient approach, and finally, it is there: ClickHouse now supports updates in deletes! In this article, we will see how it works.

Read More
Using ODBC with Clickhouse

20 Sept 2018
This article shows different ways of how you can use ClickHouse in connection with other data sources to make queries use all of ClickHouse optimization features in order to make results come faster. Also, it is good practice when you have some infrastructure elements already linked to some other data sources or tools that supports ODBC.

Read More
Clickhouse-copier in practice

Aug 22, 2018
Clickhouse-copier is a tool designed to copy data from one ClickHouse environment to another. The tool is a part of standard ClickHouse server distribution. It can work in a fully parallel mode and distribute the data in the most efficient way. In this article, we review a few typical examples when clickhouse-copier can be used.

Read More
Case Study. AfterWords - Intelligent Customer Engagement

Aug 1, 2018
AfterWords is an intelligent customer engagement and survey system that delivers users transactional history and customer feedback to create actionable data to improve operations, sales and profitability.

In this article, our guest author Oleg Khozyainov shares his experience of using ClickHouse as part of work done for www.surveyafterwords.com

Read More
ClickHouse and ProxySQL queries rewrite

July 16, 2018
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 applications to start using ClickHouse as without changes in the client library.

To avoid some limitations to this approach, ProxySQL creator René Cannaò added additional functionality for query rewrite. With his permission, we cross-post his article describing new functionality in our blog.

Read More
Realtime replication from MySQL to ClickHouse in practice

July 2, 2018
Vladislav 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 into ClickHouse using MySQL to ClickHouse replication. A few months ago we introduced clickhouse-mysql tool in our blog, and Ivinco was the first company we know that tried it and used it in production.

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
Circular Replication Cluster Topology in ClickHouse

May 10, 2018
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 nodes configured in a special way, that allows to continue executing queries even in the case of a node failure. Such replication configuration can be found in different distributed systems, it is often referred to as ‘circular’ or ‘ring’ replication. In this article, we will discuss how to set up circular replication in ClickHouse.

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