Which Azure database is more suitable to me?

0 votes
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
Jul 8 in Azure by Lakshminarayanan
• 1,180 points
117 views

1 answer to this question.

0 votes

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

Hope it helps!!

Thank You!!

answered Jul 8 by Niroj
• 66,780 points
Dear @Niroj, Many thanks for your reply. I will look this one

Related Questions In Azure

0 votes
1 answer
0 votes
1 answer

What is Azure SQL database? How to connect to Azure SQL database?

Azure SQL Database is a general-purpose relational ...READ MORE

answered Jan 13 in Azure by Sirajul
• 58,130 points
300 views
0 votes
1 answer

Is there a way to get ERROR details on Azure website?

You have two options: First, you can turn ...READ MORE

answered May 25, 2018 in Azure by club_seesharp
• 3,450 points
1,094 views
0 votes
2 answers

How can I add database connection string to Azure Functions?

The best way to do this is ...READ MORE

answered Aug 17, 2018 in Azure by Priyaj
• 57,700 points
7,564 views
+1 vote
1 answer

How to copy Azure SQL database to a local development server?

Actually, there are multiple ways to do ...READ MORE

answered Jul 9, 2018 in Azure by null_void
• 3,220 points
865 views
+5 votes
7 answers

Docker swarm vs kubernetes

Swarm is easy handling while kn8 is ...READ MORE

answered Aug 27, 2018 in Docker by Mahesh Ajmeria
1,351 views
0 votes
1 answer
0 votes
2 answers