Forum Discussion
Chriso1051
Jan 24, 2021Copper Contributor
VMs with MariaDB
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 ...
Parisa_Moosavinezhad
Jan 24, 2021Brass Contributor
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.
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.