Manage clusters

Cluster management involves the administration and maintenance of database clusters. Here’s an overview of Percona Everest cluster management.

1. Database provisioning

   Provisioning a database instance involves setting up and configuring a database instance on the Percona Everest platform.

   

2. Editing the database clusters

   Editing a cluster in a Percona Everest typically involves making configuration changes to an existing database cluster to adapt it to your evolving needs.

   To edit a database cluster, go to the Overview page of the desired cluster and click Edit on the corresponding widget.

   

3. Scaling

   Scaling in Percona Everest involves adjusting the capacity and performance of your database instances to meet changing application demands. You can scale Percona Everest vertically and horizontally.

   To scale your database cluster, go to the Overview page of the desired cluster. Click on Edit in the Resources widget. This will open the Edit Topology screen. Make the necessary changes to the settings and then click Save.

   

   

   • Vertical scaling

     Vertical scaling is essential for addressing increased workloads or performance demands. You can scale up or scale down as per your requirements.

     • Scale up

       You can vertically scale up your Percona Everest instance by modifying its configuration to a higher performance tier. This involves increasing the memory and/or CPU threshold.

     • Scale down

       Similarly, you can scale down (downsize) your database instance when the resource requirements decrease, which can help optimize costs.

   • Horizontal scaling

     To scale Percona Everest horizontally, add database nodes to the existing cluster. These nodes share the workload, distributing queries and transactions more evenly, which can lead to improved performance.

4. Manual storage scaling

   You can increase the storage capacity of your S3-compatible storage through manual storage scaling. This feature enables you to adapt to rising data demands, providing more flexibility in managing growing database workloads while ensuring system stability and data security.

   To increase the DISK for a database, go to the Percona Everest home page and select your desired database. Then, navigate to Overview > Resources > Edit and enter the new value for DISK (in Gi).

   

5. Back up and restore

   Back up and restore are critical aspects of managing and maintaining databases in Percona Everest. Implementing robust backup and recovery strategies is crucial for preserving the integrity and availability of data and ensuring seamless business operations.

   With the Percona Everest platform, you can generate backups on demand, create new databases using pre-existing backups, and restore backups to existing database clusters.

   

6. Monitoring

   Monitoring ensures consistent performance by continuously observing various metrics and aspects of the database system. It helps identify performance issues or bottlenecks before they escalate, allowing timely interventions, optimizations, and resource allocation adjustments. This helps us maintain a stable and consistent database system performance over time.

   You can manage your monitoring settings by navigating to the Overview page of the desired cluster and clicking Edit in the Monitoring widget. You can turn monitoring on or off by using the toggle.