I'm setting up a client management application as a hosted service; whereas the application itself will be accessed and ran from the internet. The application currently runs on one database and 9 tables for each client's account if I were running it on a standalone single system.
Now suppose, I have more than one client, each with an account of the application, is it wise to build a database for each application or could I have one master database for all clients. My concern is with maintaining and backing up multiple databases should my client accounts become large.
Are there any thoughts on how this can be achieve?