VMs with MariaDB

%3CLINGO-SUB%20id%3D%22lingo-sub-2092640%22%20slang%3D%22en-US%22%3EVMs%20with%20MariaDB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092640%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20time%20creating%20Azure%20resources%20for%20a%20project.%20We%20want%20to%20have%202%20VM%E2%80%99s%20attached%20to%20Application%20Gateway%20for%20load%20balancing%20traffic.%20If%20we%20want%20to%20add%20the%20Azure%20Database%20for%20MariaDB%20resource%2C%20do%20we%20need%20to%20create%20our%20own%202%20VMs%20or%20does%20Azure%20DB%20for%20MariaDB%20come%20with%20VM%E2%80%99s%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2092875%22%20slang%3D%22en-US%22%3ERe%3A%20VMs%20with%20MariaDB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092875%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EIt%20depends%20on%20your%20scenario.%3CBR%20%2F%3EIn%20Azure%20DB%20for%20MariaDB%20Server%2C%20you%20have%20one%20read%2Fwrite%20db%20and%20several%20read%20replicas.%20Only%20when%20the%20replication%20is%20stoped%20the%20replica%20server%20can%20accept%20write.%3CBR%20%2F%3EMicrosoft%20doc%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmariadb%2Fconcepts-read-replicas%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fmariadb%2Fconcepts-read-replicas%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20want%20to%20be%20able%20to%20write%20on%20both%20dbs%20and%20sync%20them%20with%20each%20other%2C%20the%20solution%20with%202VM%20and%20installing%20Mariadb%20on%20them%20would%20be%20better.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2093793%22%20slang%3D%22en-US%22%3ERe%3A%20VMs%20with%20MariaDB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2093793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F941083%22%20target%3D%22_blank%22%3E%40Chriso1051%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Azure%20Database%20for%20Maria%20DB%20is%20a%20Paas%20service%20so%20you%20will%20not%20see%20the%20infrastructure%20layer%20and%20you%20just%20have%20to%20provide%20parameters%20and%20deploy%20.%20If%20you%20want%20to%20go%20for%20Iaas%20(%20after%20defining%20pros%20and%20cons)%20in%20this%20case%20you%20will%20need%26nbsp%3B%20you%20have%20to%20create%20VM%20install%20MariaDB%20take%20care%20about%20backups%20updates%20and%20security%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20talk%20about%20application%20gateway%20so%20i%20guess%20there%20is%20a%20web%20tier%20in%20you%20application%20.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20would%20be%20%3A%26nbsp%3B%20Client%20request%20%3D%3D%3D%3D%26gt%3BApplication%20Gateway%20%3D%3D%3D%3D%26gt%3Bweb%20tier%20%3D%3D%3D%3D%26gt%3B%20database%20tier%3C%2FP%3E%3CP%3E1%20subnet%20for%20App%20Gateway%20(mandatory)%3C%2FP%3E%3CP%3E1%20subnet%20for%20web%20tier%20%2B%20network%20security%20group%3C%2FP%3E%3CP%3E1%20subnet%20for%20database%20tier%26nbsp%3B%20%2B%20network%20security%20group%20or%20private%20endpoints%20to%20avoid%20exposing%20you%20database%20to%20the%20entire%20world%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

First time creating Azure resources for a project. We want to have 2 VM’s attached to Application Gateway for load balancing traffic. If we want to add the Azure Database for MariaDB resource, do we need to create our own 2 VMs or does Azure DB for MariaDB come with VM’s?

2 Replies
Hi,
It depends on your scenario.
In Azure DB for MariaDB Server, you have one read/write db and several read replicas. Only when the replication is stoped the replica server can accept write.
Microsoft doc: https://docs.microsoft.com/en-us/azure/mariadb/concepts-read-replicas

If you want to be able to write on both dbs and sync them with each other, the solution with 2VM and installing Mariadb on them would be better.

@Chriso1051 

 

Hi Azure Database for Maria DB is a Paas service so you will not see the infrastructure layer and you just have to provide parameters and deploy . If you want to go for Iaas ( after defining pros and cons) in this case you will need  you have to create VM install MariaDB take care about backups updates and security .

 

You talk about application gateway so i guess there is a web tier in you application . 

The flow would be :  Client request ====>Application Gateway ====>web tier ====> database tier

1 subnet for App Gateway (mandatory)

1 subnet for web tier + network security group

1 subnet for database tier  + network security group or private endpoints to avoid exposing you database to the entire world