OvalEdge DB on Azure MySQL

This article provides step-by-step instructions to set up an Azure-based MySQL database environment. It covers the creation of an Azure Database for MySQL instance and the execution of initialization scripts. This setup supports database configuration required for application deployment and metadata operations.

Prerequisites

Ensure the following conditions are met before proceeding:

Azure Access: Valid access to the Azure Portal with required permissions
Azure Subscription: Active Azure subscription for resource provisioning
Resource Group: Existing resource group or permission to create a new one
Compute Access: Access to an Ubuntu virtual machine for database connectivity
SQL Scripts: Availability of required MySQL initialization scripts

Installation Steps

Create Azure Database for MySQL
- Log in to the Azure Portal using valid credentials. Select Create a resource. Sample Reference Screenshot
- Search for Azure Database for MySQL and select it. Select Create. Sample Reference Screenshot
Configure Database Settings
- Select the appropriate Subscription.
- Select an existing Resource Group or create a new one.
- Enter a unique Server Name.
- Select the required Region. Sample Reference Screenshot
- Select the appropriate Pricing Tier based on performance requirements. The Business Tier 1 option is suitable for business-critical workloads and provides high performance and reliability. Sample Reference Screenshot
- Enter the Administrator Username and Password for the MySQL server, and proceed to Networking. Sample Reference Screenshot
- Proceed to the Networking configuration.
Configure Network Settings
- Select Connectivity Method as Private Access (VNet Integration).
- Select the required Virtual Network. Sample Reference Screenshot
- Proceed to the Security configuration.
Review and Create
- Review all configuration settings.
- Select Create to deploy the database.
- After deployment, navigate to the Overview page and note the following:\
  - Server Name
  - Administrator Username
  - Database Name
Connect to Azure MySQL from Ubuntu VM
- Connect to the Ubuntu virtual machine.
- Update system packages:
  sudo apt update
- Install MySQL client:
  sudo apt install mysql-client -y
- Verify MySQL client installation:
  mysql --version
- Connect to the Azure MySQL server:
  mysql -h <MYSQL_HOSTNAME> -u <USERNAME> -p
Execute Initialization Script
- Run the required database initialization script after establishing the connection:
  source <script_file_path>/01.R6.3_MasterScripts_FreshInstallation.sql;
  Sample Reference Screenshot: