Everest Mysql unable scale down from 3 node to 1

Percona Everest
1

Deployed test cluster with 3node and unable to scale down to 1.
Error: Cannot scale down 3 node cluster to 1. The operation is not supported

Everest v1.0.1
DATABASE SUMMARY

  1. Basic Information
    Namespace: everest-dev
    Type: MySQL
    Name: sql-mysql-test
    Version: 8.0.36-28.1
    Storage class: standard-rwo
  2. Resources
    Number of nodes: 1
    CPU: 0.6 CPU
    Memory: 0.512 GB
    Disk: 2 GB
  3. Backups
    Backups disabled
    PITR Disabled
  4. Advanced Configurations
    External access enabled
    Database engine parameters set
  5. Monitoring
    Disabled
2

Hello @benpat,
As you can see from the message, such action is not supported. You cannot have a highly available database system with only 1 node. Everest prevents you from deploying such an unreliable configuration. If you can explain in details why you need such a deployment, I can forward this on to the Everest team as a feature request.

3

You can create a new MySQL database with a single node from the backup.

4

In event of development system, users may not want 3node or 2node just a single node to save on resource.

5

Hello @benpat, this post has gained some visibility from our Everest product manager. Scaling down to 1 server is on our roadmap. The best I can give is “coming soon”.

6

If backup of the database with 3 nodes is enabled, you can restore the backup to a new database with 1 node, this may work for development.