Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-5291

Update ClickHouse version from 19.7.5.27 to 21.3-lts

Details

    • Improvement
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.2.1
    • 2.21.0
    • PMM Server
    • 5
    • 11 - Core
    • Yes
    • Yes
    • C/S Core

    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.

      [[email protected] opt]# clickhouse-server --version
      ClickHouse server version 21.3.14.1 (official build).

      Even after the second update to the same version.

      Attachments

        Issue Links

          Activity

            People

              nikita.beletskii Nikita Beletskii
              vadim.yalovets Vadim Yalovets
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist