Search

Welcome to Datagrid
Welcome to Datagrid
Azure MySQL Database

Azure MySQL Database

Azure Database for MySQL is a fully managed database service that allows you to set up, manage, and scale MySQL databases in the cloud. By connecting Azure MySQL Database to Datagrid, you can seamlessly integrate your database information with other business-critical data, enabling enhanced reporting, analytics, and decision-making.

1. How-to

1. Prerequisites

To configure the Azure MySQL Database connector, follow these steps:

  • An active Azure account with the necessary permissions to access Azure MySQL Database.
  • Azure MySQL Database server details, including server name, database name, username, and password.
  • Ensure that your Azure MySQL Database server allows connections from Datagrid's IP addresses. You may need to configure the firewall rules accordingly.
  • Select the data you want to import into Datagrid

2. Connect

Creating a dataset from the Azure MySQL Database connector involves selecting the specific data you want to import:

  1. Connect Azure MySQL Database App: a. Click on the "+ Create” Button on the top left of the screen. b. Select the "Connect Apps" item. c. Search for the Azure MySQL Database connector from the list. d. Enter your Azure MySQL Database server details, including server name, database name, username, and password. e. Click on the “Next” button.
  2. Pick your Data: a. Pick the Azure MySQL Database data you want to include in your dataset (e.g., Tables, Views, Stored Procedures). b. Click on the “Start First Import” Button to start syncing your Azure MySQL Database dataset.

3. Set Up a Schedule

Scheduling regular data pulls ensures your Datagrid datasets remain up-to-date with the latest information from Azure MySQL Database:

  1. Navigate to Azure MySQL Database Dataset: a. Go to the left side panel and locate and click on the Azure MySQL Database dataset you created.
  2. Schedule Settings: a. Click on the “...” on the top right of the dataset. b. Click on “Edit Pipeline” to edit your connector's name. c. Click the “Schedule” button on the right, beside the “Import Configuration” button.
  3. Configure Schedule: a. Set the desired frequency for data pulls (e.g., daily, weekly, monthly). b. Specify the time of day for the data pull to occur. c. Specify downtime if needed – when the sync should not happen. d. Click the “Update” button to update the new configuration.

4. Data Access

  • Object
    • Server
    • Configuration
    • Database
    • Firewall Rule
    • Log File
    • Operation

5. Use Cases

  • Business Intelligence: Import data from Azure MySQL Database into Datagrid to create dashboards and reports that provide insights into key business metrics.
  • Data Analysis: Analyze data from Azure MySQL Database in Datagrid to identify trends, patterns, and anomalies.
  • Application Development: Use Datagrid to access and transform data from Azure MySQL Database for use in custom applications.
  • Data Migration: Migrate data from Azure MySQL Database to other data sources using Datagrid's data integration capabilities.
  • Website and Application Hosting: Azure Database for MySQL is ideal for hosting websites and applications.
  • E-commerce Platforms: Many e-commerce platforms rely on MySQL databases for storing product catalogs, customer information, and order details.
  • Content Management Systems (CMS): WordPress, Drupal, and Joomla are popular CMS platforms that often use MySQL as their underlying database.

6. FAQ

Q: What versions of MySQL are supported? A: Azure Database for MySQL uses MySQL Community Edition. See supported versions for the specific engine versions available.

Q: What are the differences between the Burstable, General Purpose, and Business Critical service tiers? A: The service tiers are primarily differentiated by compute, memory, storage type, and IOPS. See details: Azure Database for MySQL flexible Server service tiers.

Q: Do I need to manage my MySQL database, apply updates, and make backups? A: No. Azure Database for MySQL is a fully managed database service, which means that Microsoft automates the management and maintenance of your infrastructure and database server, including routine updates, backups, and security.

7. Support & Additional Resources