+ Post New Thread
Results 1 to 6 of 6
Web Development Thread, Databases in Coding and Web Development; Couple of odd questions... one leads on to the other (or not at all...) 1. Is there actually a way ...
  1. #1
    DrPerceptron's Avatar
    Join Date
    Dec 2008
    Location
    In a house
    Posts
    926
    Thank Post
    34
    Thanked 134 Times in 114 Posts
    Rep Power
    41

    Databases

    Couple of odd questions... one leads on to the other (or not at all...)

    1. Is there actually a way of assigning a single user access to more than one database within Plesk?

    2. Is there any advantage to running multiple databases instead of using table prefixes to differentiate content?


    Basically, I'm trying to run a multi-site setup using a single users table... the way I've always done it is using multiple databases... but since Plesk doesn't (in an obvious manor) provide any way of assigning a single user to multiple databases, I can't use that way - but I've never really tried using tables.

    In the long run will it make a difference? Talking on a site with around 5-6 thousand visitors a month (unique)

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    Contacting your host directly should provide you the answer to Plesk. If they supply the product they should answer questions like yours (if they're any good)

    As for multiple databases, the main advantage is you could host these on different physical servers which could speed things up. Again it depends on number of users, and the type of hosting you're using. Shared, VPS or Dedicated for example.

  3. Thanks to Michael from:

    DrPerceptron (24th December 2009)

  4. #3

    Join Date
    Apr 2008
    Location
    Notts
    Posts
    55
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    13

    sql Database

    After reading this thread I need some clarification;

    I run a webserver at our college; Server 2003, iis 6 with PHP and Mysql

    This runs our moodle, joomla and a number of other PHP/SQl apps like calandars etc

    At the moment these are all run from one database with tables with separate prefixes etc. mainly because I was new to sql when I set it up.

    I am unlikely to want to split these on to different servers

    Is having them all in one database causing any performance hit?

    Is it likely to cause any problems in the future?

    Thanks

    Mark

  5. #4

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    In a way (similar to RAID), RAID0 would in theory perform quicker than RAID1, so splitting databases into smaller chunks and running on multiple servers would speed things up. It really depends how big the databases are and how powerful the servers are.

  6. #5

    Join Date
    May 2009
    Posts
    11
    Thank Post
    0
    Thanked 5 Times in 5 Posts
    Rep Power
    11

    Databases

    When I used to use plesk you could use your main usename/password from the control panel, which had access to all databases.

    As for seperating them in different databases it will help performance, and also is easier to work with.

    Hope that helps

  7. #6
    SteveBentley's Avatar
    Join Date
    Jun 2007
    Location
    Yorkshire
    Posts
    1,438
    Thank Post
    120
    Thanked 263 Times in 189 Posts
    Rep Power
    72
    Quote Originally Posted by THERADIOTUBBY View Post
    After reading this thread I need some clarification;

    I run a webserver at our college; Server 2003, iis 6 with PHP and Mysql

    This runs our moodle, joomla and a number of other PHP/SQl apps like calandars etc

    At the moment these are all run from one database with tables with separate prefixes etc. mainly because I was new to sql when I set it up.

    I am unlikely to want to split these on to different servers

    Is having them all in one database causing any performance hit?

    Is it likely to cause any problems in the future?
    Your main risk is that if the database gets trashed you lose all of the services while you're restoring it, rather than just the one. I guess there's also a potential security issue that a vulnerability in one app could lead to data used by the other applications being compromised.

    It's not too big a job to split these into seperate databases, either on the same server or a different one - stop the applications writing to the database, dump the database to a .sql file, make a copy for each of the databases you want to end up with, delete the queries which create the tables for other apps, and then import the file into a new db. Then change your script which connects to the database to look for a new database name. There's no reason to (and I would strongly advise that you don't) change the table prefixes.

SHARE:
+ Post New Thread

Similar Threads

  1. Databases and Visual Basic Express
    By Jobos in forum Coding
    Replies: 2
    Last Post: 1st July 2007, 10:19 AM
  2. MySQL Databases
    By timbo343 in forum Windows
    Replies: 12
    Last Post: 1st May 2007, 11:46 AM
  3. Technical Databases
    By RobC in forum Educational Software
    Replies: 15
    Last Post: 21st April 2006, 06:45 PM
  4. Designing Access Databases
    By RobC in forum Windows
    Replies: 2
    Last Post: 20th December 2005, 11:56 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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