Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,472
There are 717 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

Distributed Forums

Thread title: Distributed Forums
Closed Thread    
    Thread tools Search this thread Display Modes  
10-22-2005, 01:02 AM
#1
Sketch is offline Sketch
Sketch's Avatar
Status: Member
Join date: Aug 2005
Location: Melbourne, Australia
Expertise:
Software:
 
Posts: 419
iTrader: 0 / 0%
 

Sketch is on a distinguished road

  Old  Distributed Databases

I am about to purchase quite a few domains (20 or more), I'm thinking about making them all point to the same hosting (if this is possible). The site is going to be built with PHP and mySQL, and I have a few questions about this.

Each address is going to do different things, like search a different area, so for example I might get electricalshops.com and then motorshops.com.

As you can see one is for electrics and one is for motor goods, the overall layout of the site will be constant, it is just the database queries that change...

I am thinking of setting up 20 different databases within the one host, and then using a script that gets the domain name and will access the correct SQL query. I'm not sure if this is the best way to do it, or if I'm better getting a different hosting per domain.

I really hope this makes sense to everyone, if it doesn't I will type it out again, but some help on this matter would be much appreciated.

10-22-2005, 01:05 AM
#2
DateinaDash is offline DateinaDash
Status: The BidMaster
Join date: Nov 2004
Location: England
Expertise:
Software:
 
Posts: 10,821
iTrader: 0 / 0%
 

DateinaDash is on a distinguished road

  Old

I understand your concept....what software are you using? vbulletin won't allow you to use the same license on multiple domains unfortunatly You could hack phpbb to display different sections on the various domains using the same database.

10-22-2005, 01:14 AM
#3
Sketch is offline Sketch
Sketch's Avatar
Status: Member
Join date: Aug 2005
Location: Melbourne, Australia
Expertise:
Software:
 
Posts: 419
iTrader: 0 / 0%
 

Sketch is on a distinguished road

  Old

I'm going to be coding it all myself, but I'm just not sure whether i should be doing it all from the one host or if I should be doing it from different ones, and is it going to be slow from the same host ect..

10-22-2005, 01:16 AM
#4
xZaft is offline xZaft
Status: Member
Join date: Jul 2005
Location: Massachusetts, US
Expertise:
Software:
 
Posts: 428
iTrader: 0 / 0%
 

xZaft is on a distinguished road

  Old

Hmm, maybe make it redirect to the forum category from those. Say like the elecrticalshops.com. The 4th forum is electric, have it redirect to f4-Electrical-Shops.html

10-22-2005, 01:20 AM
#5
Sketch is offline Sketch
Sketch's Avatar
Status: Member
Join date: Aug 2005
Location: Melbourne, Australia
Expertise:
Software:
 
Posts: 419
iTrader: 0 / 0%
 

Sketch is on a distinguished road

  Old

I don't want to loose the URL page though, if they go to electricshop.com I want the url to change with the browsing, so it goes electrishop.com/bargans.php and motorshop.com/bargans.php i don't want the domains changing between one another.

10-22-2005, 01:40 AM
#6
Salathe is offline Salathe
Salathe's Avatar
Status: Community Archaeologist
Join date: Jul 2004
Location: Scotland
Expertise: Software Development
Software: vim, PHP
 
Posts: 3,820
iTrader: 25 / 100%
 

Salathe will become famous soon enough

Send a message via MSN to Salathe

  Old

Just from a technical standpoint, it is perfectly possible to have all 20 domains pointing to one hosting account; provided your host allows that many addon/parked domains. For the database option, why make things difficult with 20 different ones? Surely the data is going to be relatively similar so duplicating 20 sets of the same tables is not the best way to go. Use one database that all sites access, rather than one per site. Anyway, if you want a central point for data (eg for forums, user registrations, etc) then one DB is the way to go.

10-22-2005, 01:48 AM
#7
Sketch is offline Sketch
Sketch's Avatar
Status: Member
Join date: Aug 2005
Location: Melbourne, Australia
Expertise:
Software:
 
Posts: 419
iTrader: 0 / 0%
 

Sketch is on a distinguished road

  Old

Thanks Salathe, I think I might follow that option for the databases, your right I was making this difficult, i just wasn't sure if hosting would allow a lot of domains pointing to the same account. If my domains are pointing to the same account that lets me keep the names constant like what I said in #5 ?

No just to try and find a reliable host that will let me point all the domains to the same account. Also on that note, do you think it is important to have a host close to home, like I'm in Melbourne Australia, and these sites are going to be aimed at people in my area, so am I better to find an aussie host or what?

10-22-2005, 02:42 AM
#8
Sketch is offline Sketch
Sketch's Avatar
Status: Member
Join date: Aug 2005
Location: Melbourne, Australia
Expertise:
Software:
 
Posts: 419
iTrader: 0 / 0%
 

Sketch is on a distinguished road

  Old

Originally Posted by Robson
I understand your concept....what software are you using? vbulletin won't allow you to use the same license on multiple domains unfortunatly You could hack phpbb to display different sections on the various domains using the same database.

I now understand why you mentioned vbulletin and phpBB, I put forums in the heading, I meant databases, silly me

10-22-2005, 10:30 AM
#9
Salathe is offline Salathe
Salathe's Avatar
Status: Community Archaeologist
Join date: Jul 2004
Location: Scotland
Expertise: Software Development
Software: vim, PHP
 
Posts: 3,820
iTrader: 25 / 100%
 

Salathe will become famous soon enough

Send a message via MSN to Salathe

  Old

In your situation, yes it would be good to find a localhost (*giggles* developer's joke). Why bother forcing everyone to connect to a server in the US if everyone is in Aus? (rhetorical question)

10-23-2005, 01:02 AM
#10
Sketch is offline Sketch
Sketch's Avatar
Status: Member
Join date: Aug 2005
Location: Melbourne, Australia
Expertise:
Software:
 
Posts: 419
iTrader: 0 / 0%
 

Sketch is on a distinguished road

  Old

Sweet, thanks Salathe, I think I will pay the little extra and use a good Aussie host.

Thanks for your help.

Closed Thread    


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed