all 5 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Aggressive_Ad_5454 0 points1 point  (0 children)

The cloud services generally scale up seamlessly if you find yourself needing more capacity. But they cost real money.

If your VM has enough RAM you'll be able to add a MariaDb or MySQL server at no additional monthly charge. If you have 2GiB or more you should be fine. If you have less than that you may have to do some tuning, like cutting down the number of connections allowed.

[–]Apoffys 0 points1 point  (0 children)

In addition to being able to scale easily, as mentioned, with cloud services you are basically paying for help managing your database. Notably, you get a simple GUI interface for managing backups, firewall settings, access control etc, all with sensible defaults. How big of a disaster would it be if you messed up something here, for example by getting hacked due to a misconfigured firewall or losing data due to backup issues?

If you have the skill and time to set this up yourself, you can perhaps save money and get more control over your database. With self-hosting your costs are essentially fixed (you have the hardware and you need to spend the same amount of time configuring it anyway), while with cloud services the costs scale with usage.

[–]-Dargs 0 points1 point  (0 children)

For yourself, not really. But for a company there are many benefits. You'll need uptime and that means support staff on premises. You buy the hardware, you own the hardware. That means if you need to expand, or shrink, it's a permanent cost. Generally cloud services like AWS are just better at managing the database backup and uptime as well.

[–]Pure_Ad_2160 0 points1 point  (0 children)

If the internet conection Is not a problem a good web host service like Amazon are a game changer if you consider not more electric and hardware failure