SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Evangelist mad-onion's Avatar
    Join Date
    Aug 2000
    Location
    Land of the long white cloud
    Posts
    556
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is it practical to have say 400+ seperate MySQL databases on one server. I know this is by no means preferable but i am faced with a situation were i can see no practical alternative.

    Is it possible to 'abuse' MySQL like this?

    Thanks

    SiteOptions >> Services :: Products :: Contact
    Developers of PHP, C++, Visual Basic, MySQL, and more!

  2. #2
    SitePoint Wizard
    Join Date
    Apr 2000
    Posts
    1,483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its probably possible (but I don't know for sure) but performance would take a big hit. Certainly not a great idea to have so many - why would they all be needed?

  3. #3
    SitePoint Evangelist mad-onion's Avatar
    Join Date
    Aug 2000
    Location
    Land of the long white cloud
    Posts
    556
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It is a situation i will have to do my best to avoid.

    I am building a system that will basically be 100's of sites, each one will be seriously database intensive.

    It is not practical to operate any other way than with a separate db for each site. Other methods would be impossible to manage.

    I might look into putting only about 30 sites on each server, then there would only be 30 databases needed.
    SiteOptions >> Services :: Products :: Contact
    Developers of PHP, C++, Visual Basic, MySQL, and more!

  4. #4
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Each database is just a directory on the hard drive, so performance wouldn't take too much of a hit.

    Are you certain your system can't be written to use a single database with better DB design? SitePoint, for example, stores all its data in a single database...
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •