December 13th, 2011, 06:04 AM
Best approach to setup 30 urls reading off one SQL database
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.
December 13th, 2011, 08:51 AM
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.