#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2011
    Posts
    1
    Rep Power
    0

    Best approach to setup 30 urls reading off one SQL database


    Hi all

    I have been asked to manage a project comprising around 30 URLs all reading data from a single MySQL database.

    I have a dedicated server based in the UK, managed by a ISP called Fasthost. The server is Linux running Ubuntu.

    I currently run all my sites by setting the DNS to my nameservers, then setting up the server space through a control panel on the server, and then uploading files through FTP.

    Is there a way of setting up the Domain Name Server to point these urls straight to a standard set of files, with data and site css/theme configured through a table by the site_id ??

    I do have an existing short cut for batches of linked sites where I have set up a parent/child type of structure with one URL and fies acring as the parent but it involves full server space setup, uploading a standard set of files to each child server space,
    The index page of the child site uses multiple php includes which - and if there are any development changes all the sites have to be updated.

    Can anyone suggest a route forward. I recognise that I will have to get expert help to implement this, but I would like some advice on best practice approach for this project.

    Thanks all
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2011
    Location
    United States
    Posts
    24
    Rep Power
    0
    From this point on..."Is there a way of setting up the Domain Name Server to point these urls straight to a standard set of files, with data and site css/theme configured through a table by the site_id ??", your description gets a bit confusing. However, I assume what you mean is can you set up a DNS record to point to the full URL such as: http://www.domain.com/someFolder/somepage?querystring.

    If that is the case, no, DNS cannot perform that function. You would have to handle that portion of the redirection on the webserver or webcode itself.

IMN logo majestic logo threadwatch logo seochat tools logo