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.
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.Read More
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.Read More
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
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.
Apr 6, 2018
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 your server, you might need the logs for compliance purposes.
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
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 – you should not miss this!Read More
Mar 12, 2018
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 formats.
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.
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.
Jan 8, 2018
ClickHouse development team is known for lack of published development plans. Sometimes they disclose plans responding to questions and bug reports, but more often discuss the roadmap at meetups. In this article we describe 'secret' 2018 roadmap that has been presented at ClickHouse Meetup in Moscow on December 12th by Alexey Milovidov.
Jan 4, 2018
It's been a while since Altinity announced a partnership with Kodiak Data, a cloud-infrastructure company. Despite that, we have never written about Kodiak Data and how they help with ClickHouse deployments. Now there are several companies already using ClickHouse at Kodiak Data MemCloud(TM), so it's time to explain why. In this article, we test ClickHouse performance at various AWS and Kodiak Data cloud instances as well as add RedShift to complete the picture.
Dec 18, 2017
There are many cases where ClickHouse is a good or even the best solution for storing analytics data. One common example is web servers logs processing. In this article, we guide you through Nginx web server example but it is applicable to other web servers as well.
We will use Logstash with ClickHouse in order to process web logs. Logstash is a commonly used tool for parsing different kinds of logs and putting them somewhere else. For example, in ClickHouse. This solution is a part of Altinity Demo ApplianceRead More
Dec 6, 2017
Christian 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 challenges his group is facing and how ClickHouse helps in their research.