In this blog, I’ll demonstrate the steps to create MySQL configuration using OCI console for MySQL.VM.Standard.E3.1.8GB shape, then create a new MySQL standalone DB system using the new configuration.
Prerequisites:
1. Sign in to the OCI console
2. Open the navigation menu and navigate to “Databases -> Configurations“
3. The list of configurations is displayed. Choose your compartment
4. Click the “Create Configuration” button
5. In the “Create Configuration” window, enter and select the below options, then click the “Create” button
– Enter name and description
– Select compartment
– Click the “Change shape” button and select MySQL.VM.Standard.E3.1.8GB shape from the list
– Under the “User variables” section, add the below variables:
– max_connections = 200
– sort_buffer_size = 500000
– time_zone = -5:00
6. Once create configuration finishes, the configuration details page is displayed
7. We can now use the new configuration when creating the MySQL DB system. In the “Create DB System” wizard:
– Under the “Configure Hardware” section, make sure to select “MySQL.VM.Standard.E3.1.8GB” shape
– Click “Show advanced options“, select the “Configuration” tab, click the “Select Configuration” button, then select “MyConfig” configuration from the available list