How to create a Database Instance?

Step 1: Log in to Your Account.

Step 2: From the left-hand menu, select Databases and then choose Overview.

Step 3: Click on Manage Databases.

Step 4: Select Create New Instance.

Step 5: From the available options—MariaDB, MySQL, PostgreSQL, and Redis—select your preferred datastore. For this example, we'll choose MariaDB.

Step 6: The system automatically assigns a namespace mapped to your account name.

Step 7: Enter a name for your database. Ensure it starts with a lowercase letter, followed by any combination of letters, numbers, or dashes, and ends with either a letter or a number. Click Next to proceed.

Step 8: Configure Database Settings

1. Database Version: Select your desired version of the database.

2. Database Mode: Choose between "Standalone" or "Cluster." For this example, we'll proceed with "Standalone."

Step 9: Standalone Configuration

a. Machine Specifications: Select the appropriate CPU, memory, and storage size for your needs.

b. Advanced Configuration:

1. Deletion Policy: Choose from the following options:

   1. Delete: Keep only database Secrets and backed-up data

   2. Halt: Keep PVCs, database Secrets, and backed-up data

   3. WipeOut: Deletes everything, including backed-up data

   4. DoNotTerminate: Prevents deletion of the MariaDB CRD

2. Authentication Credentials: Toggle "Provide authentication credentials" if you wish to set a custom password.

3. Database Configuration: Toggle "Configure database" to access additional configuration settings.

4. Point-in-Time Recovery: Enable this feature if you require the ability to restore the database to a specific point in time.

5. Additional Features:

   1. Enable Monitoring: Activates performance and health monitoring.

   2. Enable Backup: Schedules regular backups of your database.

   3. Enable TLS: Secures data transmission with Transport Layer Security.

   4. Expose via Gateway: Allows external access to the database through a gateway.

Step 10: Click Deploy and wait for the deployment process to complete.

Step 11: Once deployed, navigate to the Databases section to confirm that your new database instance is active and listed.

Note: By default, your databases can be accessed by any IP address. So, it's highly recommended that you restrict access to your databases by whitelisting only those access points or IP addresses that you trust!