Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Toronto, ON

    Thoughts on DB/Site design so to speak..

    I wanted to get some input on a design... specifics aside, the idea is to be able to create numerous child sites under the main site.. now, an idea is obviously to have all child sites share the database together to beable to give access to all users on each site access to other child sites and move freely across the network without having to register and what not.. the benefits to this specific network would be great

    Cons, obviously a very large database with large amounts of queries - security is a big concern though not really as I have that somewhat taken care of.. Cache common database queries, restricting access, not allowing child sites to upload php files, etc.

    The real question is has anybody taken on a project that has a similar idea and run into problems or issues that most people wouldn't think of and how it was dealt with...

    I know I would save a lot of time and effort by just giving each child site it's own database and letting them do whatever they want...

    Language is PHP, MySQL dbase (mysqli)
    I specialize in neck beards
    Latest: Reach for Android

  2. You don't really give much detail so this obviously depends on what the sites will be doing but I'd just have a database for each site - this way if the load on your main database server gets too high then you can simply move the heavy databases to another DB server.

    If you were in fact implying using 1 central database for authentication of various sites then I'd probably look at OpenLDAP or something.

    If you can post more specifics we can be of more help.


Similar Threads

  1. New site design, any thoughts
    By Host Ahead in forum Web Site Reviews
    Replies: 10
    Last Post: 10-29-2010, 11:10 PM
  2. New Design for us -- thoughts?
    By IntraHost-Greg in forum Web Site Reviews
    Replies: 1
    Last Post: 07-01-2009, 04:35 PM
  3. your thoughts on design
    By railto in forum Web Site Reviews
    Replies: 16
    Last Post: 01-20-2009, 02:06 PM
  4. Thoughts on my design
    By thinguy in forum Web Site Reviews
    Replies: 9
    Last Post: 03-14-2004, 05:57 PM
  5. Speak your thoughts
    By ElectronicCr in forum Web Site Reviews
    Replies: 5
    Last Post: 02-28-2003, 09:19 PM

Posting Permissions

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