Which Azure database is more suitable to me

Question

Hi,

I'm new to Azure. I need to use database service from Azure. I have seen more databases like Azure for Mysql, Sql database, Mysql with virtual machines. Here my question: I need to select Mysql or Sql database. I have used azure calculator. But its too make me more confuse. So kindly tell me which database is more suitable to me? like pricing, performance . I will wait . Its urgent too.

Requirements

2 Vcpu, 8 Gb ram and storage 100GB

Database : Mysql or SQL database

Answer 1

Hello @ Lakshminarayanan,

Both the Azure SQL Database and MySQL deal with relational databases, and use SQL as their query language. 

• As such, MySQL is extremely widely used as it is compatible and easy to set up. It’s compatible with all major Operating System platforms and all major programming languages. 
• It is possible for anyone to download and install MySQL from the internet for free, with very little hassle. If it suits you better, you can study its source code and customize its functionality to better fit your personal needs.
• On the other hand, the Azure SQL Database is a database as a service. It is an intelligent, scalable, cloud hosted database, provided as a managed service. Simply put, a database as a service is a service that provides users with some form of access to a database on-demand.
• The Azure SQL Database is equally an amazing database that allows you to only pay for what you use.

As attention shifts to the cloud, and hosted databases, I do think the Azure SQL database is in a better position going forward. It’s able to leverage the entire Azure platform to provide more meaningful ways to interact with data, and doing so very cheaply.

So, choose accordingly to your personnel use.

You can also check this out-Cloud Computing With Azure and Azure Certification here.

Hope it helps!!

Thank You!!

Comments

Dear @Niroj, Many thanks for your reply. I will look this one