Docker and Microsoft Azure

This process shows how to deploy MariaDB in a Docker container running on an Azure VM instance. First we'll create the Azure VM, then we'll deploy Docker to it. After that, we'll pull the MariaDB Docker image which we'll use to create a running container with a MariaDB instance. Finally, we'll load a sample database into the MariaDB instance.

Create a VM in Azure

1. Install MariaDB client on your local machine, either bundled with Maria DB server or standalone.

2. Login to Azure, navigate to Azure Virtual Machine

3. . Give the VM a name (e.g. mrdb-ubuntu-docker-use1), and create new or use an existing resource group. Selection region and availability zone, and choose Ubuntu 22.04 LTS x64 (free services eligible).

1. Choose the VM instance size, like a B1s or similar free tier. Note that Azure free works on a credit based system for new accounts

1. Configure an administrator account and generate a new key pair, and give the key pair a name.

1. Click "Review + Create" at the very bottom of the "create virtual machine" page to create the VM.
2. Download the SSH keys and them in a safe place, you will need them later. For this example, let's name the key file mrdb-docker-pk.pem.

If your local machine is Linux or you are using WSL on Windows, open a terminal window and:

1. Once the VM is deployed, "click to resource" to get back to the virtual machine's overview page.
2. From the overview page, the left-hand navigation, choose settings > networking.

3. Click "add inbound port rule"

Install Docker on the Azure VM

For more detailed instructions, refer to

1. To connect to your remote server using SSH, open a terminal window and use the following command, replacing placeholders with your specific details:

   • Replace your-keyfile.pem with your private key file name.

   • Replace your.ip.address with your actual IP address from step 12.

   If you forget your admin details, go to Azure's left-hand navigation, select Settings >

Pull the MariaDB Docker image and create the container

1. To download the latest MariaDB Docker image, run the following command:

2. To start the MariaDB Docker process, open your terminal or command line and enter the following command:

   • Use the -v flag to mount a directory for persistent storage under /var/lib/mysql.

23. To login to MRDB inside the container, use the root password from step 20:

24. Setup admin account with permission for remote connection, configure access control

Obviously replace these passwords with something that is a bit more secure than you see in this example for anything other than development purposes.

1. Setup service account for your app with permission for remote connection, configure access control

Obviously replace these passwords with something that is a bit more secure than you see in this example for anything other than development purposes.

1. Load up your database from your preexisting SQL script that contains ; ; and statements.

Open a new local terminal window and navigate to the directory containing your init.sql script. Then, run the command: mariadb --host=ww.xx.yyy.zzz --port=3306 --user=admin --password=admin -e "SOURCE init.sql", replacing ww.xx.yyy.zzz with your server's IP address.

_{This page is licensed: CC BY-SA / Gnu FDL}