Large project, what to choose Azure + MSSQL or Basic hosting + MySQL?

Question

MySQL

Hello, I'm a website developer.
I was approached by a person who wants to launch a large project similar to a social network. Its main requirements are:
1) Hosting must be abroad (we are located in Kazakhstan)
2) Security must be on top
Personally, I have identified two options for myself:
1) American hosting https://www.https://www.hostmonster.com /cgi-bin/si... with "Plus" tariff plan. Accordingly there will be MySQL.
2) MS Azure is, in my opinion, a more secure service, MSSQL database.
In the first case, I am confused by the speed of loading their site, I didn’t really like the support service. I liked everything else, especially unlimited disk space, did I understand correctly? If the project is popular, it will be necessary to switch to a dedicated server.
In the second case, Azure was well advertised to me in terms of security, automatic backup and scaling, databases up to 100 MB for free, and up to 10 sites for free too (or a month of trial period). That is, it will be free to start, and with the popularity of our project, it is easy to scale the project. But I don't understand pricing in azure at all. How to roughly calculate the bandwidth of a site?
In general, questions:
1) At the hoster https://www.hostmonster.com/cgi-bin/signupunlimited disk space if azure has any limit?
2) How to calculate the approximate bandwidth of the site? And how do you calculate the cost of using MS azure? (I saw the calculator, I don't understand anything in it, if I want MSSQL + "Website", what to choose, what bandwidth, support, etc.)
(MySQL can also be used in azure, but MSSQL was advised to me)
3) What would you choose, in my place? Maybe some other alternative solutions?
I would be glad to hear any opinion, sorry if the question is incorrect.
Ps: If the project is popular, it is also planned to write mobile applications, which I also took into account, and because of which I paid attention to azure.

Answer 1

While you have a start - place yourself anywhere.
There will be some kind of load - move to your servers.
There will be a serious load - you will rewrite the architecture 4 times for sure.

Answer 2

1 - MS SQL should be used in conjunction with the .NET stack. if, for example, you use PHP, it’s easier to work in tandem with MySql, if Node.js - a bundle with MongoDB will be very organic
in such combinations, it’s easier to find examples of solutions. otherwise, you will have a separate headache to link solutions from different gardens and not infrequently with a very different mentality
(it should be noted that MongoDB is a NoSql family, the choice of a database should generally be done at a fairly early stage and very consciously, read for example on the links habrahabr.ru /post/231213 и habrahabr.ru/post/229129/)
the biggest price of any project is the labor input. and any going beyond the typical combination of a technology stack dramatically increases its
2 - "hostmonster" and Azur are not commensurable in terms of cost, which means that in terms of scaling capabilities,
you need to understand a number of points
- in general, the price and the level of service correlate quite clearly. that is, there the "hostmonster" cannot offer you anything new, only the initial level of Azuri appears. both in terms of prices and performance
- the two main leaders in scalability are Amazon AWS and Azur, while Azur fundamentally builds a pricing policy - "no more expensive than the same level for Amazon AWS"
- Azure offers free entry levels for sites, mobile services and databases (when creating a mobile service, you can create one 20MB database for mock development), but then the prices rise quite sharply. a niche appears between free features and entry-level services for a combat load - they are already significantly expensive
for this particular niche and can be closed with the services of host monsters. but only on the condition that you have chosen a non-Microsoft stack
, if a macrosoft one (.NET + MS SQL is my choice, according to that additional infa) - then there will be a shortage of intermediate-level hosting,
you can see the price levels of more or less interesting offers for entry-levels below:
https:/ /ultravds.com/#main
https://www.primahost.info/ (Windows VPS (KVM) at the bottom of the page)
https://somee.com/CustomizeIt.aspx?pid=100000002361
but after reaching really BIG loads, you will still come to Amazon AWS and Azure
3 - to make it easier to navigate the comparisons, the Azuri price calculator will still have to be mastered. as you know "appetite comes with eating" - take a free 3-month trial and try different services
if memory serves - there you can see the estimated calculation at the end of the billing period based on the ordered services and the loads achieved
one more nuance - during the trial period, services seem to be provided within 500 bucks (also if I'm not confused), if you spend a large amount of resources (and this can be done in one day - by ordering a powerful machine and loading it to its fullest), subscription is blocked and it is proposed to switch to a paid mode - here it is necessary to take into account that it is blocked only until the end of the billing month! you can just wait, then continue studying for another 2 months. and the billing month is counted from the date of registration

Answer 3

In vain you rely so much on unlimited space.
Since the space is declared unlimited, then there are some restrictions (most likely - on the number of files).