MariaDB is an advanced open-source relational database management system (RDBMS) developed as a fork of MySQL, originally created to address the growing demands for enhanced performance, scalability, and security in database management. It is widely adopted in various industries for applications ranging from small web-based solutions to large-scale enterprise data systems. By utilizing Structured Query Language (SQL), MariaDB provides an efficient and user-friendly interface for data manipulation, retrieval, and management.

One of MariaDB’s standout features is its compatibility with MySQL, allowing users to easily migrate existing applications without significant changes to their codebases. This makes it an attractive option for organizations seeking to upgrade their database systems while minimizing disruption. MariaDB supports a diverse array of storage engines, including InnoDB, Aria, and MyRocks, enabling users to choose the most suitable engine for their specific workloads. This flexibility helps optimize performance, ensuring that the database can efficiently handle both transactional and analytical workloads.

MariaDB includes a range of advanced features that enhance its functionality and usability. It supports full-text search capabilities, making it easier to query and analyze large text data sets. The inclusion of GIS (Geographic Information Systems) features allows for the management and analysis of spatial data, making MariaDB suitable for applications in mapping and location-based services. Additionally, the dynamic column feature enables users to store different data types in a single column, offering greater flexibility in schema design.

Security is a top priority for MariaDB, and it offers robust measures to protect sensitive data. Features such as data encryption at rest and in transit, as well as comprehensive user authentication methods, ensure that data remains secure from unauthorized access. The system also provides granular access control, allowing database administrators to set permissions at various levels, thus enhancing security management.

In terms of performance, MariaDB is designed for high availability and scalability. It includes built-in support for replication, which allows data to be copied across multiple servers, ensuring redundancy and improving load balancing for high-traffic applications. The Galera Cluster technology integrated into MariaDB provides synchronous multi-master replication, enabling high availability and real-time data synchronization across distributed environments.

To subscribe to this product from Azure Marketplace and initiate an instance using the Azure compute service, follow these steps:

1. Navigate to Azure Marketplace and subscribe to the desired product.
2. Search for “virtual machines” and select “Virtual machines” under Services.
3. Click on “Add” in the Virtual machines page, which will lead you to the Create a virtual machine page.
4. In the Basics tab:

• • Ensure the correct subscription is chosen under Project details.
  • Opt for creating a new resource group by selecting “Create new resource group” and name it as “myResourceGroup.”

5. Under Instance details:

• • Enter “myVM” as the Virtual machine name.
  • Choose “East US” as the Region.
  • Select “Ubuntu 18.04 LTS” as the Image.
  • Leave other settings as default.

6. For Administrator account:

• • Pick “SSH public key.”
  • Provide your user name and paste your public key, ensuring no leading or trailing white spaces.

7. Under Inbound port rules > Public inbound ports:

• • Choose “Allow selected ports.”
  • Select “SSH (22)” and “HTTP (80)” from the drop-down.

8. Keep the remaining settings at their defaults and click on “Review + create” at the bottom of the page.
9. The “Create a virtual machine” page will display the details of the VM you’re about to create. Once ready, click on “Create.”
10. The deployment process will take a few minutes. Once it’s finished, proceed to the next section.

To connect to the virtual machine:

1. Access the overview page of your VM and click on “Connect.”
2. On the “Connect to virtual machine” page:

• • Keep the default options for connecting via IP address over port 22.
  • A connection command for logging in will be displayed. Click the button to copy the command. Here’s an example of what the SSH connection command looks like:
    “`
    ssh [email protected]
    “`

3. Using the same bash shell that you used to generate your SSH key pair, you can either reopen the Cloud Shell by selecting >_ again

or going to https://shell.azure.com/bash.
4. Paste the SSH connection command into the shell to initiate an SSH session.

Usage/Deployment Instructions

Anarion Technologies – MariDB

Note: Search product on Azure marketplace and click on “Get it now”

Click on Continue

Click on Create

Creating a Virtual Machine, enter or select appropriate values for zone, machine type, resource group and so on as per your choice.

After Process of Create Virtual Machine. You have got an Option Go to Resource Group 

Click Go to Resource Group

Copy the Public IP Address

SSH into terminal & run these following commands:

$ sudo su
$ sudo apt update
$ sudo systemctl restart mariadb.service
$ sudo systemctl status mariadb.service

Log in to the MariaDB shell:

$ sudo mysql -u root -p

MariaDB [(none)]> SHOW DATABASES;

Create a new database: Use the following SQL command to create a new database (replace your_database_name with the desired name of your database):

MariaDB [(none)]> CREATE DATABASE your_database_name;

MariaDB [(none)]> SHOW DATABASES;

ThankYou!!!