Gossamer Forum
Home : Gossamer Threads Inc. : Discussion :

Expandability

Quote Reply
Expandability
I have a client that has been looking at some of my previous work on other sites, and is interested in using GT's products. A few questions first. The site is going to be very huge, spanning 5-8 dedicated servers. The products he is interested in ar LinksSQL, G-Mail, G-Forum, DBManSQL, and Community in an integrated package. The question I have is:
1) Can all of these products be ported into Oracle?
2) The setup will be G-mail on one server, G-forum on another server, linkssql spanning several servers. Can LinksSql be spanned across several servers?
3) Can the search.cgi be modifed to recognize http_referer and select which database it uses, i.e. http://www.site.com/directory will go to the directory database, but http://www.site.com/market will go to the market database.
4) What are the differences between oracle and mysql that a client would choose oracle over mysql?

Thanks, more to follow as I think of them...

</not a clue>
Quote Reply
Re: [Kilroy] Expandability In reply to
Hi,

1. Yes, all our products have been tested with Oracle 8i. They have not been nearly as extensively tested as MySQL or MS SQL, but you shouldn't have any problems.

2. What do you mean by "spanned across several servers"? Do you mean build the html pages across different servers? If you use nfs this can be done. You could also install multiple copies (would need multiple licenses). There are also lots of load balancing solutions as well that we could look at. Not sure what you are trying to do.

3. Yes, that wouldn't be a difficult change.

4. The main thing, don't use Oracle unless you have an experienced Oracale database administrator available. It's not trivial to setup, tune, or maintain.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Expandability In reply to
I will be using nsf to span over several servers. The idea is to use two copies of links, one running the search side of the house with http_refer directing to the appropriate database. There will be three main databases, one with the initial search for a directory compiled from spidered dmoz data, a second for the site search, and a third for shopping/books/classified, etc. The second liscense for Links will possibly be used as a content manager, though we are also looking at masonhq as a content manager also.
Questions
1) Is there an example of a large site out there that I can compare this project with? If you don't want to publicly post the url please PM me.
2) Is there anyone out there that has ported this into oracle that can give me some of the issues ran into with oracle. I have only worked with mysql and sybase in the past, and have no experience with oracle.

Basically what we are trying to do is set up a site in manner like a vigenette storyserver without the cost using GT products.
Any other suggestions would be greatly appreciated. Also, if I am not able to pull this off, is there anyone else that would like to look into this job (it's contract based with an initial payment, with a bonus upon completion, along with administration support afterwards for 1 year)

</not a clue>
Quote Reply
Re: [Kilroy] Expandability In reply to
Reliance on CGI variables, like $ENV{HTTP_REFERER} is not foul-proof. What about those users who bookmark your search form or search results page? There ain't gonna be a refering page.
========================================
Buh Bye!

Cheers,
Me