# Production install (RoR + Oracle + IIS)

**URL:** <https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010>\
**Category:** Rails\
**Created:** [May 29, 2008, 9:44pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010 "2008-05-29T21:44:31Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![pepe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/4da419/32.png) [@pepe](https://www.ruby-forum.com/u/pepe)\
**Post date:** [May 29, 2008, 9:44pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010/1 "2008-05-29T21:44:31Z")

</div>

Hi.

Although an expert developer for IBM systems (iSeries) I am VERY new  
to RoR and somehow to the PC development world as well and not  
familiar AT ALL with PC configurations, etc. (in my regular job good  
ol’ IBM takes care of all that and I just need to code). So forgive me  
if any of the following sounds stupid, it probably is. Just get a  
laugh at my expense and try to answer between roll and roll on the  
floor.

I am developing a very simple application (1 main table and some other  
ones used for drop downs and data verification) for an intranet with  
just a few users. I have spent countless hours finding information/  
documentation on using Oracle and IIS with RoR. Got helpful links that  
helped me through some problems but install time is approaching and  
since configuration is not my strength I would like to know if there  
is a kind soul that would be willing to shed some light on this type  
of configuration and some other questions. Here they are:

1. Do I need Mongrel, Mongrel clustering, both (supposing they are  
different things) or none by using IIS?
2. Could I run Apache and IIS at the same time and use Apache for my  
RoR application and forget IIS? If yes, would that cause any problems  
to existing code using IIS and also how can I direct the requests to  
the appropriate server without having to type the port number in the  
URL?
3. The table I’m working with has an ID column that is NOT numeric and  
IT IS primary key. Has anybody tried in the model self.primary\_key =  
“id”? If yes, does that make RoR ignore all the ID stuff it does  
behind the scenes or does it say “mmm… trying to be smarter than  
me?” and still does its magic?

Now, if you can stop laughing I would appreciate some feedback and any  
other type of helpful information on the subject.

Thanks a lot.

---

<div class="post-metadata">

**Author:** ![pepe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/4da419/32.png) [@pepe](https://www.ruby-forum.com/u/pepe)\
**Post date:** [May 30, 2008, 5:23pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010/2 "2008-05-30T17:23:47Z")

</div>

Maybe someone else can clarify if I’m incorrect here, but you should  
be able to just do it similarly to deploying with Apache/Mongrel.  
Install and config Mongrel as a service and have IIS proxy to Mongrel.  
[http://mongrel.rubyforge.org/wiki/Win32](http://mongrel.rubyforge.org/wiki/Win32)

Whether or not you need mongrel cluster depends on how many concurrent  
requests you need to process. Rails is not thread safe and therefore  
you would need to deploy multiple Mongrels to achieve concurrency.  
more info @ [http://mongrel.rubyforge.org/wiki/FAQ](http://mongrel.rubyforge.org/wiki/FAQ)

---

<div class="post-metadata">

**Author:** ![pepe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/4da419/32.png) [@pepe](https://www.ruby-forum.com/u/pepe)\
**Post date:** [May 30, 2008, 5:27pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010/3 "2008-05-30T17:27:56Z")

</div>

You may want to buy this book and read through it before going too  
far:  
[http://www.amazon.com/Deploying-Rails-Applications-Step-Step/dp/0978739205/ref=sr\_1\_13\_s9\_rk?ie=UTF8&s=books&s9r=8a10809b187969430118da9e78ce0ae8&itemPosition=13&qid=1212151457&sr=1-13](http://www.amazon.com/Deploying-Rails-Applications-Step-Step/dp/0978739205/ref=sr_1_13_s9_rk?ie=UTF8&s=books&s9r=8a10809b187969430118da9e78ce0ae8&itemPosition=13&qid=1212151457&sr=1-13)

---

<div class="post-metadata">

**Author:** ![pepe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/4da419/32.png) [@pepe](https://www.ruby-forum.com/u/pepe)\
**Post date:** [May 30, 2008, 9:37pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010/4 "2008-05-30T21:37:56Z")

</div>

Thanks for the comment. This actually gives me the opportunity to ask  
something else. Apparently there will be just a handful of people  
using this application at any given time. Can I just use Webrick then  
since the traffic is going to be so low? What would happen if 2 users  
try to concurrently access the application at the same exact moment?  
Will the requests be queued or will one of them fail?

Thanks.

---

<div class="post-metadata">

**Author:** ![pepe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/4da419/32.png) [@pepe](https://www.ruby-forum.com/u/pepe)\
**Post date:** [May 30, 2008, 10:25pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010/5 "2008-05-30T22:25:00Z")

</div>

I _believe_ the answer is that if webrick is so busy w/user #1 that it  
can’t come back to user #2 with some response before the browser tires  
of waiting, they’d get an error. Now, browsers are patient (more so  
than users 😉 but if you have functions like file uploads that can take  
long periods of time, you may get complaints.

But don’t take my word for that–wait for someone more knowlegeable to  
respond.

That said–you should at least download mongrel (gem install mongrel).  
It’s faster than webrick, and you can install it as a service very  
easily (see the link John gave below).

My tentative plan for my app is to set a single mongrel listening on  
port 80 on a spare windows box, and wait to see if one of my 2 users  
comes to punch me in the back of the head. 😉

Cheers,

-Roy

---

<div class="post-metadata">

**Author:** ![pepe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/4da419/32.png) [@pepe](https://www.ruby-forum.com/u/pepe)\
**Post date:** [May 30, 2008, 5:45pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010/6 "2008-05-30T17:45:08Z")

</div>

Thanks for the tip. I have found numerous links and some information  
about this book during my research but nothing seems to indicate that  
it will address the particularities of the installation I need to work  
on (IIS and Oracle). For what I have read it deals mainly with  
‘mainstream’ installations. I have not had time to check the book at  
the store yet but I am planning on getting it done as soon as I can.

Thanks!

---

<div class="post-metadata">

**Author:** ![pepe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/4da419/32.png) [@pepe](https://www.ruby-forum.com/u/pepe)\
**Post date:** [May 30, 2008, 11:16pm UTC](https://www.ruby-forum.com/t/production-install-ror-oracle-iis/139010/7 "2008-05-30T23:16:41Z")

</div>

Thanks Roy.

I already talked to the users and the reason why I asked about Webrick  
is that there will be only 4 or 5 users at any given time using this  
application and the whole thing is so simple that the server should  
take just miliseconds to execute. The only thing it will do that will  
use some time is to access a few tables to generate drop downs and at  
the end write a record to the Oracle table. Very simple stuff.

Thanks for your comments.