How many sites can use one central database

Discussion in 'Databases' started by Michal Demin, Sep 17, 2008.

0
  1. #1
    I have a client that have 100 sites that display information from a database currently they are running individual databases for each sites.

    I was wondering if it was possible for all these 100 sites to use one database as they are all exact same script. All they do is pulling information out of database and doesnot write anything.

    So it is possible to use one database for 100 sites. Each site recieves about 200 user per day.
     
    Michal Demin, Sep 17, 2008 IP
  2. live-cms_com

    live-cms_com Notable Member

    Messages:
    3,128
    Likes Received:
    112
    Best Answers:
    0
    Trophy Points:
    205
    Digital Goods:
    1
    #2
    Then they'd have duplicate content, unless there was 100 tables in the one database.
     
    live-cms_com, Sep 17, 2008 IP
  3. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If the appliction / site is written to support this then the answer would be yes, if no such support is given you are doing something the author did not anticipate so you would need to ask the author or test and validate for yourself if this site can run with a single database/table solution.

    The more important question to me is the motive for trying to merge multiple databases, what are the gains you receive when doing this. P.S. This is only interesting if you are trying to merge into a single table.
     
    chisara, Sep 17, 2008 IP
  4. webburu

    webburu Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    It is not possible to do so if the script does not supports multiple database. I think you should find an CMS that support multiple sites with just one database such as dotnetnuke
     
    webburu, Sep 20, 2008 IP