fairly new to mysql.
i have been working on a site which would have say 100 + agents.
basically the agents clients are their own so i thought the best way would be to get a dedicated server and create a mysql database for each agents company.
the database would be the same for each, well slight differences to 1 or 2 tables but the basics the same.
first of i have 2 questions really.
1. is this ok to have setup on a dedicated server? having that amount of sub domains and with their own mysql database?
2. what is the restrictions to a mysql database? the hosting company said it is down to hardware on the server?
so say it was a dual core linux machine with 4gb ram and 160gb sata hard drive, what would be the size limit for each database if there is one?
hope someone can help me as i have the idea just not sure if it is best practice to do it this way.