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

    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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist