So, you're looking at 150-300 databases and ~31-62k tables based on your numbers? MySQL should be able to handle that, as should your OS, but the most important part IMO is how your clients will be using their data(bases). What sort of queries, how many, etc. Will it be possible for one client to hog all the disk IO?
Ignoring the latter questions, with a properly designed database and tuned queries this doesn't seem like an impossible setup on a single database daemon. Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 16 Jun 2006, Robinson, Eric wrote: > Our server will be home to 50-100 separate clients. Each client will > have their own set of databases that will be accessed by 10-60 users at > each client's site. > > In terms of performance, is it better to have 1 instance of MySQL > servicing multiple databases, or multiple instances of MySQL each > serving 1 database? > > Here's some more information to work with: > > Each client has 3 databases. > > Database: 500 tables. 13 tables sized 10-100MB. Remaining tables all > less that 10MB. (This is the only database that is updated. The others > are just for reference.) Main table grows at a rate of a few hundred > MB/year. > > Database2: 50 tables. 3 tables sized 10-100MB. All other tables less > than 10MB. No data growth. > > Database3: 179 tables. 10 tables sized 1-15MB. All other tables less > than 1MB. No data growth. > > --Eric > > > Disclaimer - June 16, 2006 > This email and any files transmitted with it are confidential and intended > solely for [EMAIL PROTECTED] If you are not the named addressee you should > not disseminate, distribute, copy or alter this email. Any views or opinions > presented in this email are solely those of the author and might not > represent those of Physician Select Management (PSM) or Physician's Managed > Care (PMC). Warning: Although the message sender has taken reasonable > precautions to ensure no viruses are present in this email, neither PSM nor > PMC can accept responsibility for any loss or damage arising from the use of > this email or attachments. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
