SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard triexa's Avatar
    Join Date
    Dec 2002
    Location
    Canada
    Posts
    2,476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Multiple databases???

    I've looked at hosting plans.. and some offer 1 mysql database, others offer a few more.. and the rest unlimited...

    Why do you need more than 1 mysql database though?
    AskItOnline.com - Need answers? Ask it online.
    Create powerful online surveys with ease in minutes!
    Sign up for your FREE account today!
    Follow us on Twitter

  2. #2
    SitePoint Zealot thirdcherry's Avatar
    Join Date
    May 2003
    Location
    CA
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi there,

    Actually, I'm working on a client's site right now that we are discussing adding an additional database to.

    We are adding a news section that will archive old headlines for product releases. This will enable us to update the new headlines easier, control the amount of new headlines we want to show in a given area, and have a manageable archive, that will not interfere the with the main product database, which we do not want to bog down added information.

    By keeping them in separate databases, the site stays lean and more functional.

    I'm sure there are many others out there doing even more complex things that would make sense to have more than one database.

    Best Regards,
    Michael Wisniach
    3rd Cherry Designs

  3. #3
    SitePoint Wizard triexa's Avatar
    Join Date
    Dec 2002
    Location
    Canada
    Posts
    2,476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmm... okay, I guess it really seems to be made for the organizational purposes...
    AskItOnline.com - Need answers? Ask it online.
    Create powerful online surveys with ease in minutes!
    Sign up for your FREE account today!
    Follow us on Twitter

  4. #4
    SitePoint Zealot thirdcherry's Avatar
    Join Date
    May 2003
    Location
    CA
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In my case it is, but I'm sure there are others who are doing more with databases that can add to the list of reasons why one would need more than one database.

    Best of luck in finding a good host, it can be tough!

    Best Regards,
    Michael Wisniach
    3rd Cherry Designs

  5. #5
    + platinum's Avatar
    Join Date
    Jun 2001
    Location
    Adelaide, Australia
    Posts
    6,441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The main reason is backing up IMO - it's easy to just say, right, I want this database backed up... rather than sifting through 50 tables.

    It's also just nice to seperate out bits and pieces, when someone finds the user/pass to your database, they can access everything, rather than just a single site feature.

    I generally have one database for site functions, one for forums and one for any other major systems...

    If one database gets corrupted, everything goes down


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
  •