In both cases it is possible to host a database. You still have another option which is the specific hosting of databases.
Shared hosting
Perks:
- The server will be managed by the hosting company and therefore already
is configured, you will only create the bank and use it, without pain
heads safely, system update and licenses.
- Reduced cost
Disadvantages:
- If you use a hosting it will be shared, it wants
say that a database server will be shared with you and
other users (hundreds).
- The performance may not be as good, but for small and even medium websites should meet your needs. The problem is if some other user for example is attacked or consume too much traffic, everyone pays the bill.
VPS or Dedicated Server
Perks:
- This will be a virtual or real server, with resources allocated only to you. The performance is great.
- There is no risk of another user being attacked for example, and you being affected, or using too many features and slowing down your website/application. Resources are reserved for your use.
Disadvantages:
- In VPS and Dedicated you configure everything. You will need to install the database server, licenses, essential settings and even security.
- Security should be extra careful. Overall it’s a better solution than shared but requires more maintainer work.
- Higher cost.
Specific Hosting of Databases
Perks:
- Services such as Amazon DB2, Google Cloud SQL and Microsoft Azure will take care of the server configuration. You should only specify the database system, version, and options you need.
- The performance is excellent, better even than the dedicated server. The servers are highly optimized by companies, and have security and several other problems already thought and fixed. They usually protect and host millions of databases.
Disadvantages:
- The price is high, in addition to the bank’s hosting, you will need other stays such as the website or the application.
Thanks ! for the reply
– Roo Oliveira