Update ClickHouse version from 19.7.5.27 to 21.3-lts

Description

User story:

Now is used version 19.7.5.27 and want to update to 21.3.

Ticket scope:

  1. Update the Clickhouse to 21.3 version

  2. Move clickhouse initialization from pmm2-images playbook to update playbook

  3. Change log level for Clickhouse from debug to information.

  4. Use the official Clickhouse RPM package instead of our version

 How to test
It's a big change. We need to test it carefully. Query Analytics feature was impacted.
1. THE MOST IMPORTANT. We need to test the update feature and make sure that data in Query Analytics that was created before the update remained the same after the update. It'll be good to check it with MongoDB/PostgresSQL.
2. We need to check that the Query Analytics feature works fine.
3. Clickhouse version should be 21.3.

[root@9d5e4cf47471 opt]# clickhouse-server --version ClickHouse server version 21.3.14.1 (official build).

Even after the second update to the same version.

How to test

None

How to document

None

Smart Checklist

Activity

Show:

Alexey Palazhchenko January 28, 2020 at 9:24 AM
Edited

I don't follow. That page describes 19.13. I propose to update to 19.14 LTS. All described 19.13 features should be in 19.14.
And, frankly, we are not going to use any of those features any time soon.

Roma Novikov January 27, 2020 at 11:03 AM

, we are trying to get some new features as well. + we can see https://www.altinity.com/blog/2020/1/20/new-clickhouse-altinity-stable-release-19161044 sometested versions

Alexey Palazhchenko January 14, 2020 at 8:26 AM

Why not use 19.14 LTS?

Done

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Fix versions

Story Points

Sprint

Affects versions

Smart Checklist

Created January 13, 2020 at 11:38 AM
Updated March 6, 2024 at 4:58 AM
Resolved July 28, 2021 at 6:44 PM