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, 2020 in Azure by Lakshminarayanan
• 1,370 points
865 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 and Azure Certification here.

Hope it helps!!

Thank You!!

answered Jul 8, 2020 by Niroj
• 82,840 points

edited Jul 4, 2023 by Khan Sarfaraz
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, 2020 in Azure by Sirajul
• 59,230 points
1,506 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
2,656 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
• 58,020 points
13,931 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
2,651 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
3,983 views
0 votes
1 answer

What is Azure Cloud Service?

Azure Cloud Services is an example of ...READ MORE

answered Jan 10, 2020 in Azure by Sirajul
• 59,230 points

edited Jun 21, 2023 by Khan Sarfaraz 1,127 views
0 votes
2 answers

Azure DevOps and its need?

Azure DevOps is a hosted service providing ...READ MORE

answered Aug 29, 2020 in Azure by nbavis
• 380 points
1,455 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP