Altinity
ClickHouse Leading Service Provider

Blog

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
ClickHouse Experiencing Explosive Growth in EU, US and Asia in Q1 2018

LONDON, April 23, 2018 /PRNewswire/ -- Altinity, a leading service provider for ClickHouse, today announced explosive 10x quarter-over-quarter revenue growth in Q1 2018 for its ClickHouse services. The spike in demand for ClickHouse Support mirrors the trend of companies increasingly relying on ClickHouse as a solution for their data analytics and data warehousing needs.

Read More
ClickHouse Monitoring with Graphite

Apr 20, 2018
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 solutions that can be used. In this article, we will describe how to configure Graphite for monitoring ClickHouse metrics.

Read More
Amadeus Technologies Launches Investment and Insights Tool Based on Machine Learning and Strategy Algorithms

TORONTO, March 27, 2018 /PRNewswire/ -- Amadeus Technologies today announced the availability of Amadeus Equity Tools, an analytical approach to enable equity portfolio managers to quickly and easily derive actionable insights for investments. Built from the ground up on ClickHouse, a leading open-source columnar SQL database used for analytics and reporting, and Kodiak Data's memory-speed cloud infrastructure, this application uses cutting-edge technology and machine learning (ML) techniques to manage big data.

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
ClickHouse for Machine Learning

Jan 18, 2018
ClickHouse is very flexible and can be used for various use cases. One of the most interesting technology areas now is machine learning, and ClickHouse fits nicely there as very fast datasource. A few months ago ClickHouse team implemented the support for ML algorithms, that makes it much easier and faster to run ML over ClickHouse data. They started with open source Yandex CatBoost algorithm, but it can be extended with other algorithms in the future. In this article, we posted a tutorial on how ClickHouse can be used to run CatBoost models.

Read More