Azure Database for MariaDB Tutorials

Getting Started

Provision Your First Azure Database for MariaDB Server

Learn the fundamental steps to create a new Azure Database for MariaDB server, configure basic settings, and connect to it.

Category: Getting Started | Difficulty: Beginner | Last Updated: 2023-10-27

Provisioning Creation Basics

Start Tutorial

Connecting to Azure Database for MariaDB

Discover various methods for connecting to your MariaDB server, including using command-line tools, GUI clients, and application code.

Category: Connectivity | Difficulty: Beginner | Last Updated: 2023-10-25

Connection MySQL Workbench CLI Application

Start Tutorial

Database Management & Optimization

Importing and Exporting Data

Master the techniques for migrating your existing MariaDB data into Azure Database for MariaDB and exporting data for backups or other uses.

Category: Data Management | Difficulty: Intermediate | Last Updated: 2023-10-20

Import Export Data Migration Mysqldump

Start Tutorial

Performance Tuning for Azure Database for MariaDB

Learn how to identify and resolve performance bottlenecks, optimize queries, and configure server parameters for optimal performance.

Category: Performance | Difficulty: Advanced | Last Updated: 2023-10-18

Performance Tuning Query Optimization Parameters Monitoring

Start Tutorial

Implementing High Availability and Disaster Recovery

Understand Azure's built-in HA/DR features and how to configure them to ensure your database remains available during outages.

Category: Availability | Difficulty: Intermediate | Last Updated: 2023-10-15

High Availability Disaster Recovery Replication Backup

Start Tutorial

Advanced Topics

Securing Your Azure Database for MariaDB Instance

Learn best practices for securing your database, including network security, authentication, authorization, and data encryption.

Category: Security | Difficulty: Intermediate | Last Updated: 2023-10-12

Security Firewall SSL Authentication

Start Tutorial

Code Examples

Example: Connecting from a Python Application

See how to establish a connection to your Azure Database for MariaDB from a Python application using the `mysql.connector` library.

# Install the library: pip install mysql-connector-python
import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='YOUR_SERVER_NAME.mariadb.database.azure.com',
                                         database='YOUR_DATABASE',
                                         user='YOUR_USERNAME@YOUR_SERVER_NAME',
                                         password='YOUR_PASSWORD',
                                         ssl_ca='YOUR_SSL_CERT_PATH') # Optional, but recommended

    if connection.is_connected():
        db_Info = connection.get_server_info()
        print("Connected to MariaDB Server version ", db_Info)
        cursor = connection.cursor()
        cursor.execute("SELECT DATABASE();")
        record = cursor.fetchone()
        print("You're connected to database: ", record)

except Error as e:
    print("Error while connecting to MariaDB", e)

finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MariaDB connection is closed")
            

More Code Examples