Add Upgrade Support for Main Cluster + Standby Cluster

[vitabaks]

Currently, after updating the main cluster, it is necessary to deploy a new standby cluster. While this approach works, it is not convenient, especially for large databases, as it requires substantial time and computing resources.

Proposal: Add support for upgrading the standby cluster so it can be updated alongside the main cluster. This enhancement would streamline the upgrade process for larger clusters, making it more efficient and less time-consuming.

[vitabaks]

If you're interested in this feature, please consider becoming a sponsor.

The development of this feature requires sponsorship to fund developer efforts. If you're already a sponsor and are interested in this feature, please leave a comment here so we can prioritize this issue accordingly.

We also welcome contributions from those willing to dedicate their time to implement this feature on a voluntary basis. Please see the Contributing Guide for more information.