I want to offer SQL shared hosting for customers.
Ideally I'd like:
- access isolation (one user shouldn't see information about other user's databases)
- SQL disk space quota per SQL user
- ability to limit or deprioritize CPU usage of intensive queries so everyone gets its fair share
- other things that I haven't thought about but you might have insight.
What engine do you recommend, PostgreSQL or MySQL? Why?
I understand PostgreSQL has better support in case of a server crash or loss of failure, but it fails to provide things like 1) (since pg_database is viewable by anyone). I don't know if MySQL supports 2) but it's done in CPanel somehow so it must be possible, I'm clueless if PostgreSQL supports that...