Provision a database

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

Procedure

To provision a new database:

1. Log into the Percona Everest UI.

2. On the Percona Everest homepage, click Create Database. The Basic information page opens.

   

3. On the Basic information page, provide the following details:

   • Select the Namespace where you want to create your database.

   • Select the Database type: MySQL, MongoDB or PostgreSQL.

   • Choose a name for your database. The name is auto-populated, but you can modify it according to your needs.

   • Select the Database version from the dropdown.

   • In the Storage class field, select one of the classes created by your Kubernetes administrator.

     Storage classes define what storage configuration and features will be used for storing your database data. Different classes map to different quality-of-service levels, backup policies, persistent volumes, or to arbitrary policies determined by your cluster administrator. For more information, see Storage Classes in the Kubernetes documentation.

     

4. On the Resources page, select the Number of nodes. Also, set the resources per node by selecting one of the predefined presets or by specifying the CPU, Memory, and Disk. For more information on resources, see the Scale database deployment section.

5. On the Scheduled Backups page, set up a schedule if you wish to run backup jobs for your new database.

   Provide the following details on this page:

   • Choose a name for your backup schedule. The name is auto-populated, but you can modify it according to your needs.

   • Select the Backup storage from the dropdown.

   • Enter the number of Retention copies for the backups.

     Note

     Currently, Retention copies are not supported for PostgreSQL databases.

     Retention copies refer to the number of backup instances that should be kept.

     Example: When you set retention copies to 3, it means that you want to keep a maximum of 3 backup copies at any given time. So, if you have 3 backups already and then run a 4^th backup, the oldest backup will get deleted automatically.

     

6. On the Point-in-time Recovery (PITR) page, you can enable PITR by turning the toggle on.

7. On the Advanced Configurations page, you can enable external access and customise database engine parameters by turning the toggle button on. For in-depth information, see the configure database engine section.

8. On the Monitoring page, you can enable monitoring by turning the toggle button on and selecting the Monitoring endpoint URL. For information on adding monitoring endpoints, see the monitoring endpoints section.

9. Click Create Database.

10. Click Go to list of my databases to see the database that you provisioned.

    

Video tutorial

You can also learn about creating databases by checking the video tutorial below:

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Community Forum Get a Percona Expert