DB engine upgrade should be available in the Namespaces page

Description

After upgrading to 0.11.0 rc1, the Myql operator displayed 2/4 tasks pending. The tasks included upgrading the mysql db version from 8.0.23 to 8.0.25

It would be good to have a button next to Actions for upgrading the db version here as it might be confusing for the user to go and edit the db using the wizard.

Attachments

5

Activity

Manish Chawla 
August 5, 2024 at 3:27 PM

Upgrade from 0.10.1 to 1.1.0 rc1

Install 0.10.1 and create two namespaces - n1 and n2. Install mysql,pg in n1 and mongodb in n2.

./everestctl_0.10.1_release install --version 0.10.1 ? Namespaces managed by Everest (comma separated) n1 ? What operators do you want to install? MySQL, PostgreSQL 2024-08-05T07:37:28Z info install/install.go:513 Installing Operator Lifecycle Manager {"component": "install"} 2024-08-05T07:37:28Z info kubernetes/kubernetes.go:326 OLM operator is already installed {"component": "install", "component": "kubernetes"} 2024-08-05T07:37:28Z info install/install.go:518 OLM has been installed {"component": "install"} 2024-08-05T07:37:28Z info install/install.go:519 Installing Percona OLM Catalog {"component": "install"} 2024-08-05T07:37:28Z info install/install.go:525 Percona OLM Catalog has been installed {"component": "install"} 2024-08-05T07:37:28Z info install/install.go:502 Creating namespace everest-monitoring {"component": "install"} 2024-08-05T07:37:28Z info install/install.go:508 Namespace everest-monitoring has been created {"component": "install"} 2024-08-05T07:37:28Z info install/install.go:317 Preparing k8s cluster for monitoring {"component": "install", "action": "monitoring"} 2024-08-05T07:37:28Z info install/install.go:287 Creating operator group for everest {"component": "install"} 2024-08-05T07:37:28Z info install/install.go:291 Installing victoriametrics-operator operator {"component": "install"} 2024-08-05T07:37:29Z info install/install.go:307 victoriametrics-operator operator has been installed {"component": "install"} 2024-08-05T07:37:31Z info install/install.go:325 K8s cluster monitoring has been provisioned successfully {"component": "install", "action": "monitoring"} 2024-08-05T07:37:31Z info install/install.go:502 Creating namespace n1 {"component": "install"} 2024-08-05T07:37:31Z info install/install.go:508 Namespace n1 has been created {"component": "install"} 2024-08-05T07:37:31Z info install/install.go:394 Installing operators into n1 namespace {"component": "install"} 2024-08-05T07:37:31Z info install/install.go:574 Installing percona-xtradb-cluster-operator operator {"component": "install"} 2024-08-05T07:37:32Z info install/install.go:621 percona-xtradb-cluster-operator operator has been installed {"component": "install"} 2024-08-05T07:37:32Z info install/install.go:574 Installing percona-postgresql-operator operator {"component": "install"} 2024-08-05T07:37:33Z info install/install.go:621 percona-postgresql-operator operator has been installed {"component": "install"} 2024-08-05T07:37:33Z info install/install.go:398 Creating role for the Everest service account {"component": "install"} 2024-08-05T07:37:33Z info install/install.go:404 Binding role to the Everest Service account {"component": "install"} 2024-08-05T07:37:33Z info install/install.go:502 Creating namespace everest-system {"component": "install"} 2024-08-05T07:37:33Z info install/install.go:508 Namespace everest-system has been created {"component": "install"} 2024-08-05T07:37:33Z info install/install.go:334 Creating operator group for everest {"component": "install"} 2024-08-05T07:37:33Z info install/install.go:574 Installing everest-operator operator {"component": "install"} 2024-08-05T07:38:35Z info install/install.go:621 everest-operator operator has been installed {"component": "install"} 2024-08-05T07:38:35Z info install/install.go:363 Deploying Everest to everest-system {"component": "install"} 2024-08-05T07:38:47Z info install/install.go:377 Updating cluster role bindings for everest-admin {"component": "install"} 2024-08-05T07:38:47Z info install/install.go:678 Creating token for Everest {"component": "install"} 2024-08-05T07:38:48Z info install/install.go:205 Here's your authorization token for accessing the Everest UI and API: HVycV2juQPFRC2bjDdS7cVpMBO4XgLDky2vtdmtB0tfpUpCAgapFmWTkefi5j3I9N0Rk7B3WlTjCSt9qefCaYhNJbgb7K8w5wxw109P9baWNeKq49tmIzor44iyuoJ5e Store this token securely as you will not be able to retrieve it later. If you ever need to reset it, use the following command: everestctl token reset {"component": "install"} ./everestctl_0.10.1_release install --version 0.10.1 ? Namespaces managed by Everest (comma separated) n2 ? What operators do you want to install? MongoDB 2024-08-05T07:39:48Z info install/install.go:513 Installing Operator Lifecycle Manager {"component": "install"} 2024-08-05T07:39:48Z info kubernetes/kubernetes.go:326 OLM operator is already installed {"component": "install", "component": "kubernetes"} 2024-08-05T07:39:48Z info install/install.go:518 OLM has been installed {"component": "install"} 2024-08-05T07:39:48Z info install/install.go:519 Installing Percona OLM Catalog {"component": "install"} 2024-08-05T07:39:48Z info install/install.go:525 Percona OLM Catalog has been installed {"component": "install"} 2024-08-05T07:39:48Z info install/install.go:502 Creating namespace everest-monitoring {"component": "install"} 2024-08-05T07:39:48Z info install/install.go:508 Namespace everest-monitoring has been created {"component": "install"} 2024-08-05T07:39:48Z info install/install.go:317 Preparing k8s cluster for monitoring {"component": "install", "action": "monitoring"} 2024-08-05T07:39:48Z info install/install.go:287 Creating operator group for everest {"component": "install"} 2024-08-05T07:39:48Z info install/install.go:291 Installing victoriametrics-operator operator {"component": "install"} 2024-08-05T07:39:50Z info install/install.go:307 victoriametrics-operator operator has been installed {"component": "install"} 2024-08-05T07:39:51Z info install/install.go:325 K8s cluster monitoring has been provisioned successfully {"component": "install", "action": "monitoring"} 2024-08-05T07:39:51Z info install/install.go:502 Creating namespace n2 {"component": "install"} 2024-08-05T07:39:51Z info install/install.go:508 Namespace n2 has been created {"component": "install"} 2024-08-05T07:39:51Z info install/install.go:394 Installing operators into n2 namespace {"component": "install"} 2024-08-05T07:39:51Z info install/install.go:574 Installing percona-server-mongodb-operator operator {"component": "install"} 2024-08-05T07:40:12Z info install/install.go:621 percona-server-mongodb-operator operator has been installed {"component": "install"} 2024-08-05T07:40:12Z info install/install.go:398 Creating role for the Everest service account {"component": "install"} 2024-08-05T07:40:12Z info install/install.go:404 Binding role to the Everest Service account {"component": "install"} 2024-08-05T07:40:12Z info install/install.go:502 Creating namespace everest-system {"component": "install"} 2024-08-05T07:40:12Z info install/install.go:508 Namespace everest-system has been created {"component": "install"} 2024-08-05T07:40:12Z info install/install.go:334 Creating operator group for everest {"component": "install"} 2024-08-05T07:40:12Z info install/install.go:574 Installing everest-operator operator {"component": "install"} 2024-08-05T07:40:24Z info install/install.go:621 everest-operator operator has been installed {"component": "install"} 2024-08-05T07:40:24Z info install/install.go:368 Restarting Everest {"component": "install"} 2024-08-05T07:40:44Z info install/install.go:377 Updating cluster role bindings for everest-admin {"component": "install"}

Create databases of 1 node, take scheduled backups with PITR. Run restore to same cluster and new cluster. Create mysql db of 8.0.23.

Upgrade to 1.0.1

./everestctl_1.0.1_release upgrade 2024-08-05T08:51:51Z info upgrade/upgrade.go:303 Current Everest version is 0.10.1 {"component": "upgrade"} 2024-08-05T08:51:51Z info upgrade/upgrade.go:311 Found available upgrade to Everest version 1.0.1 {"component": "upgrade"} 2024-08-05T08:51:51Z info upgrade/upgrade.go:314 Checking requirements for upgrade to Everest 1.0.1 {"component": "upgrade"} 2024-08-05T08:51:51Z info upgrade/upgrade.go:457 Checking cli version requirements {"component": "upgrade"} 2024-08-05T08:51:51Z info upgrade/upgrade.go:486 Checking operator requirements in namespace n1 {"component": "upgrade"} 2024-08-05T08:51:51Z info upgrade/upgrade.go:486 Checking operator requirements in namespace n2 {"component": "upgrade"} 2024-08-05T08:51:51Z info upgrade/upgrade.go:167 Upgrading Percona Catalog to 1.0.1 {"component": "upgrade"} 2024-08-05T08:51:51Z info upgrade/upgrade.go:176 Waiting for install plan for Everest operator {"component": "upgrade"} 2024-08-05T08:52:25Z info upgrade/upgrade.go:191 Upgrading Everest to 1.0.1 in namespace everest-system {"component": "upgrade"} 2024-08-05T08:52:37Z info upgrade/upgrade.go:547 Approving install plan install-kdvkf for Everest operator {"component": "upgrade"} 2024-08-05T08:52:37Z info upgrade/upgrade.go:553 Waiting for install plan installation of Everest operator to finish {"component": "upgrade"} 2024-08-05T08:52:41Z info upgrade/upgrade.go:202 Everest has been upgraded to version 1.0.1 {"component": "upgrade"} Everest has been successfully upgraded! To view the password for the 'admin' user, run the following command: everestctl accounts initial-admin-password IMPORTANT: This password is NOT stored in a hashed format. To secure it, update the password using the following command: everestctl accounts set-password --username admin

Create another namespace n3 and install pg in it. Create a pg database in n3.

./everestctl_1.0.1_release install --version 1.0.1 ? Namespaces managed by Everest [comma separated] n3 ? What operators do you want to install? PostgreSQL 2024-08-05T11:29:45Z info install/install.go:580 Installing Operator Lifecycle Manager {"component": "install"} 2024-08-05T11:29:45Z info kubernetes/kubernetes.go:334 OLM operator is already installed {"component": "install", "component": "kubernetes"} 2024-08-05T11:29:45Z info install/install.go:585 OLM has been installed {"component": "install"} 2024-08-05T11:29:45Z info install/install.go:586 Installing Percona OLM Catalog {"component": "install"} 2024-08-05T11:29:46Z info install/install.go:592 Percona OLM Catalog has been installed {"component": "install"} 2024-08-05T11:29:46Z info install/install.go:561 Creating namespace everest-monitoring {"component": "install"} 2024-08-05T11:29:46Z info install/install.go:575 Namespace everest-monitoring has been created {"component": "install"} 2024-08-05T11:29:46Z info install/install.go:358 Preparing k8s cluster for monitoring {"component": "install", "action": "monitoring"} 2024-08-05T11:29:46Z info install/install.go:328 Creating operator group for everest {"component": "install"} 2024-08-05T11:29:46Z info install/install.go:332 Installing victoriametrics-operator operator {"component": "install"} 2024-08-05T11:29:47Z info install/install.go:348 victoriametrics-operator operator has been installed {"component": "install"} 2024-08-05T11:29:48Z info install/install.go:366 K8s cluster monitoring has been provisioned successfully {"component": "install", "action": "monitoring"} 2024-08-05T11:29:48Z info install/install.go:561 Creating namespace n3 {"component": "install"} 2024-08-05T11:29:48Z info install/install.go:575 Namespace n3 has been created {"component": "install"} 2024-08-05T11:29:48Z info install/install.go:441 Installing operators into n3 namespace {"component": "install"} 2024-08-05T11:29:48Z info install/install.go:641 Installing percona-postgresql-operator operator {"component": "install"} 2024-08-05T11:29:59Z info install/install.go:688 percona-postgresql-operator operator has been installed {"component": "install"} 2024-08-05T11:29:59Z info install/install.go:445 Creating role for the Everest service account {"component": "install"} 2024-08-05T11:29:59Z info install/install.go:451 Binding role to the Everest Service account {"component": "install"} 2024-08-05T11:29:59Z info install/install.go:561 Creating namespace everest-system {"component": "install"} 2024-08-05T11:29:59Z info install/install.go:575 Namespace everest-system has been created {"component": "install"} 2024-08-05T11:29:59Z info install/install.go:375 Creating operator group for everest {"component": "install"} 2024-08-05T11:30:00Z info install/install.go:641 Installing everest-operator operator {"component": "install"} 2024-08-05T11:30:12Z info install/install.go:688 everest-operator operator has been installed {"component": "install"} 2024-08-05T11:30:12Z info install/install.go:415 Restarting Everest {"component": "install"} 2024-08-05T11:30:42Z info install/install.go:424 Updating cluster role bindings for everest-admin {"component": "install"} Everest has been successfully installed! To view the password for the 'admin' user, run the following command: everestctl accounts initial-admin-password IMPORTANT: This password is NOT stored in a hashed format. To secure it, update the password using the following command: everestctl accounts set-password --username admin

Switch to fast channel

kubectl -n everest-system patch sub/everest-operator -p '{"spec":{"channel":"fast-v0"}}' --type=merge

Upgrade to 1.1.0 rc1

./everestctl-1.1.0-rc1 upgrade --version-metadata-url https://check-dev.percona.com ✓ Upgrade Operator Lifecycle Manager ✓ Upgrade Percona Catalog ✓ Wait for Everest Operator InstallPlan ✓ Upgrade Everest API server ✓ Upgrade Everest Operator ✓ Run post-upgrade tasks 🚀 Everest has been upgraded to version 1.1.0-rc1 To view the password for the 'admin' user, run the following command: everestctl accounts initial-admin-password IMPORTANT: This password is NOT stored in a hashed format. To secure it, update the password using the following command: everestctl accounts set-password --username admin

After upgrade, the namespaces page displays the mysql db engine upgrade

Upgrade the mysql db from 8.0.23 to 8.0.25

 

The mysql database is upgraded successfully.

Unresolved

Details

Assignee

Reporter

Sprint

Fix versions

Priority

Created June 6, 2024 at 2:25 PM
Updated August 12, 2024 at 12:28 PM