Provisioning a MySQL service

You can create a MySQL database service using the Provisioning App in the Tessell Console. During provisioning, you can customize the configurations such as the service name, database engine version, cloud provider, region, compute shape, storage, high availability, security, monitoring, backups, and maintenance options.

---

Prerequisites

A subscription must be created for your chosen cloud provider.

---

To create a MySQL database using the Tessell Console:

1. Sign in to the Tessell Console and open the Provisioning App from the DB Services section in the left navigation pane.

1. In the navigation pane, select MySQL as your database engine.

1. In the Service Details section, provide the following:

   1. Service Name: A unique name for your DB service.

   2. Description (Optional): A brief description of the service.

   3. Tags (Optional): Add tags to help organize or track your resources.

   4. Software Release: Select the major version from the dropdown and choose the minor version by clicking the Edit option in the Version section.

1. In the Cloud Provider Settings, enter:

   1. Subscription: Select the subscription registered with the Tessell Platform.

   2. Region: Choose the desired cloud region.

   3. VPC/VNet: Select your VPC (for AWS) or VNet (for Azure).

   4. Availability Zone: Choose your preferred AZ.

   5. Private Subnet: Select a subnet from the dropdown list.

1. In the Compute Shape Settings:

   1. Choose compute shape between High Performance or Standard based on workload.

   2. Select the number of vCPU required.

   3. Choose the Compute Shape based on the selected vCPUs.

   4. Specify Storage (in GiB) for your MySQL data.

   5. To enable encryption at rest, check the Enable Encryption at Rest box. You can use the default encryption key from your cloud provider or specify a custom key.

1. In the High Availability Settings:

   1. Choose your deployment type: Single-AZ or Multi-AZ.

   2. For Multi-AZ, enable High Availability to provision one or two readable standby instances in different availability zones.

1. In the Connectivity Settings:

   1. Port: Specify the database port number.

   2. SSL: Enable SSL to encrypt the connection between your application and the database. For more information, see MySQL documentation Encrypted Connections.

   3. Public Access: Enable if you want to access the DB service over the internet.

   4. IP Address: Specify the IPs or CIDRs from which the database can be accessed.

1. In the Database Configuration section:

   1. Database Name: Enter your database name.

   2. Master Username: Specify the admin username for your database.

   3. Master Password: Use a default or define a custom password.

   4. In Advanced Configuration Setting: Choose your DB parameter profile.

      Optionally, you can create a custom parameter profile if you prefer not to use the default profile.

   5. In Custom Scripts: [Optional] provide:

      1. Pre-Script: Choose to configure the VM before initializing the database.

      2. Post-Script: Choose to configure the VM after the database is created.

      Optionally, you can upload Pre/Post Scripts in the Script Library app if you want to configure custom settings on the VM during provisioning.

1. In the Additional Settings section:

   1. Maintenance Window: Define a weekly time window for applying any modifications or patches.

   2. Auto Minor Version Upgrade: Enable if you want automatic minor upgrades during the maintenance window.

   3. Monitoring Insights: You may enable Performance Insights (contact your infrastructure admin for access).

   4. Availability Machine: Configure your RPO (Recovery Point Objective) policy for data protection and set your preferred backup window.

1. Click Create Service to begin provisioning your MySQL database.

2. As an alternative method, use the code to provision a MySQL service:

   1. Use the Code button at the top-right corner to view the code in different languages like Shell, Python, Go, Java, Javascript, and PowerShell. You can also view the corresponding APIs.

   2. You can copy or download the code using the respective buttons in the top-right corner.

   3. Use the Close button at the bottom-right corner to return back to the main window.

3. Navigate to the My Services console to monitor the provisioning status. Initially, the service shows as Creating, and after it is ready for use, the status updates to Ready.