When it comes to managing a database, its obviously easier to manage a single database that has all customer data in it (multi-tenant).
If I was to create the application with a single client in mind, meaning that each new client means that will have their own seperate mysql database.
This means if I have 10K customers, I will have 10K mysql databases, one for each customer.
Would this be a nightmare to manage? (upgrades, etc.)
certain things will be easier, liking backing up a customers database. Also, if a client is using more resources, one could backup and move their database to a server that isn't as much utilized etc.