SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Feb 2001
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Question,

    Most documentation doesn't give straight information on using mysql on a virtual server with multiple domains. Is is better to set up multiple databases per domain or would it be better to create one large database with tables per domain?

  2. #2
    SitePoint Evangelist
    Join Date
    May 2000
    Location
    Canada
    Posts
    533
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it wouldnt make much of a difference...

    as far as the server is concerned, a table is stored in a file, so, whether you have multiple databases or not, it wouldnt make much of a difference
    cogito, ergo sum

  3. #3
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Not that I know much about this, but wouldn't their be a difference with security. If you don't want the different domains having access to other domains data then you would need to use different databases. You can then set up a different user account to the sql server for each domain and give them access only to their database.

  4. #4
    SitePoint Member
    Join Date
    Feb 2001
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am also very new to this thing, however, can't you avoid the security issues by adding table access restrictions?


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
  •