What is the best linux version for rails project

Rails Deployment
1

what is the best linux version for rails project ?
and what is the best databse for rails project ?

2

Well, I ended up with Centos 4.6 for my servers because of the great
Red Hat EL docs and books available. Pus I was coming from Windows/SQL
Server Sys Admin so I needed lots of docs and a GUI. I went with
mySQL for the database because there were lots of tutorials etc and
performance has actually impressed me. I haven’t gotten to the stored
procedure or view support features yet as I switched my focus to
programming Ruby/Rails but on a server with lots of processing /memory
and a tweaked config it’s running great.

I hope this helps somewhat.

Raul

3

Pokkai D. wrote:

what is the best linux version for rails project ?

The one you already know!

and what is the best databse for rails project ?

I’ve been a fan of MySQL for a couple of years now, performance is good,
and now it has a BIG industry gorilla behind it.

4

On Sat, May 10, 2008 at 12:51 AM, Pokkai D.
[email protected] wrote:

what is the best linux version for rails project ?

This is a good question for your system administrator. It’s whatever
you/they fill the most comfortable with maintaining.

and what is the best databse for rails project ?

PostgreSQL. There is a huge community behind it… kind of like Ruby
and Rails. :wink:

Cheers,
Robby

–
Robby R.
Founder and Executive Director

PLANET ARGON, LLC
Design, Development, and Hosting with Ruby on Rails

http://www.robbyonrails.com/
aim: planetargon

+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4068 [fax]

5

I’ll have to agree with Robby as far as Postgresql for database.
We use redhat enterprise 5 here (not cheap) but Fedora is close to it;
after
all fedora is the testing distro for Redhat.

On Thu, May 22, 2008 at 7:17 AM, Mahalingam Mr <
[email protected]> wrote:

–
Greg N.
Rails Developer & Designer
Owner, carbon8.us
Blog, 20seven.org

6

I’ve had great luck with Centos as well.

I’ve been using MySQL and that’s been fine. I was using SQL Server for
years and MySQL has impressed me. I keep hearing good things about
PostgreSQL so I must have a look at that guy.

Raul

----- Original Message -----
From: Greg N.
To: [email protected]
Sent: Thursday, May 22, 2008 4:31 AM
Subject: [Rails-deploy] Re: what is the best linux version for rails
project

I’ll have to agree with Robby as far as Postgresql for database.
We use redhat enterprise 5 here (not cheap) but Fedora is close to it;
after all fedora is the testing distro for Redhat.

On Thu, May 22, 2008 at 7:17 AM, Mahalingam Mr
[email protected] wrote:

Pokkai D. wrote:

> what is the best linux version for rails project ?


upto my knowledge Ubuntu is doing good with updates, communities and
forums



>  and what is the best databse for rails project ?


in case of database it is MYSQL..


Mahalingam
Sr.Sys.Admin
Railsfactory

http://www.railsfactory.com

--
Posted via http://www.ruby-forum.com/.

–
Greg N.
Rails Developer & Designer
Owner, carbon8.us
Blog, 20seven.org

7

On May 16, 2008, at 10:39 AM, Robby R. wrote:

On Sat, May 10, 2008 at 12:51 AM, Pokkai D.
[email protected] wrote:

what is the best linux version for rails project ?

This is a good question for your system administrator. It’s whatever
you/they fill the most comfortable with maintaining.

I’ll agree with this, but throw out my personal preference of Gentoo
linux :wink:

and what is the best databse for rails project ?

PostgreSQL. There is a huge community behind it… kind of like Ruby
and Rails. :wink:

And I will agree that postgres is a better database then mysql in
most cases> But I will still choose mysql for one major reason…
replication. Postgres has no built in replication except for WAL file
replication which means the slave is in recovery mode and you cannot
run queries against it. If you are sure that you will never need to
scale past one db server then psql is probably a better choice but if
you will need to scale then mysql beats postgres hands down when it
comes to master, slave and master master replication.

Cheers-

8

----- Original Message -----
From: “Ezra Z.” [email protected]
To: [email protected]
Sent: Thursday, May 22, 2008 12:19 PM

And I will agree that postgres is a better database then mysql in
most cases> But I will still choose mysql for one major reason…
replication. Postgres has no built in replication except for WAL file
replication which means the slave is in recovery mode and you cannot
run queries against it. If you are sure that you will never need to
scale past one db server then psql is probably a better choice but if
you will need to scale then mysql beats postgres hands down when it
comes to master, slave and master master replication.

This is excellent to know! Thanks

Raul

9

Pokkai D. wrote:

what is the best linux version for rails project ?

upto my knowledge Ubuntu is doing good with updates, communities and
forums

and what is the best databse for rails project ?

in case of database it is MYSQL…

Mahalingam
Sr.Sys.Admin
Railsfactory

10

Also very good info, Ericson. Thanks for the follow up!

Raul

----- Original Message -----
From: Ericson S.
To: [email protected]
Sent: Thursday, May 22, 2008 12:37 PM
Subject: [Rails-deploy] Re: what is the best linux version for rails
project

Just to expound on Ezra’s call…

There are replication solutions for Postgresql, but not as easy to use
as MySQL. Just so you know, Skype uses Postgresql for their backend.
Skype Plans for PostgreSQL to Scale to 1 Billion Users - High Scalability -

On Thu, May 22, 2008 at 3:33 PM, Raul [email protected] wrote:

----- Original Message -----
From: "Ezra Z." <[email protected]>
To: <[email protected]>
Sent: Thursday, May 22, 2008 12:19 PM

>
> And I will agree that postgres is a better database then mysql in
> most cases> But I will still choose mysql for one major reason...
> replication. Postgres has no built in replication except for WAL

file
> replication which means the slave is in recovery mode and you
cannot
> run queries against it. If you are sure that you will never need
to
> scale past one db server then psql is probably a better choice but
if
> you will need to scale then mysql beats postgres hands down when
it
> comes to master, slave and master master replication.
>

This is excellent to know!  Thanks

Raul
11

Just to expound on Ezra’s call…

There are replication solutions for Postgresql, but not as easy to use
as
MySQL. Just so you know, Skype uses Postgresql for their backend.

12

On Thu, 2008-05-22 at 12:19 -0700, Ezra Z. wrote:

And I will agree that postgres is a better database then mysql in
most cases> But I will still choose mysql for one major reason…
replication. Postgres has no built in replication except for WAL file
replication which means the slave is in recovery mode and you cannot
run queries against it. If you are sure that you will never need to
scale past one db server then psql is probably a better choice but if
you will need to scale then mysql beats postgres hands down when it
comes to master, slave and master master replication.

Yup, this is a PostgreSQL limitation. Slony is the non-WAL replication
solution, but I hear tell that Slony and Rails (specifically, AR
migrations) don’t play so well together either… boo.

That said, I’ve used PostgreSQL on a bunch of apps and always been happy
with it. I’ve always kind of figured that if I got a DB that was too
big for one box I’d shard the data or something…

Yours,

Tom

13

Best is such an ugly word.

There is no “best”. Each will have its pros and cons.

14

There’s no simple answer to this question, as there is no “best” Linux.

But if you have to have an answer, I would go with latest Debian stable
(4.0 as of now) and PostgreSQL.

15

I’ve got newest app running with ubuntu server edition (Latest
Release) on a vm. WOrks great.
I’m running with Mongrel/Mongrel Cluster/Nginx. Even got image magik,
and filecolumn to work in one day.

The other “solution” would be elastic.
It can “generate” a vm ready to run with the rails stack you want.

16

Pokkai D. wrote:

what is the best linux version for rails project ?
and what is the best databse for rails project ?

We tend to use CentOS (or RHEL if the customer requires a high SLA).
It’s got Ruby 1.8.5 and then we install RubyGems from source (I think
the packaged RubyGems version is 0.9 still). Nice thing is that all
major third-party software is guaranteed to work with RHEL (and thus
CentOS), that it doesn’t require forced upgrade and has a long support
cycle. And if you’re into Xen, well than that’s got some amazing backing
too.

Out of the box it comes with PostgreSQL 8.1 which incidentally is our
database server of choice. It’s fast (though it requires tuning to get
there), got excellent ACID properties and has never failed on us even
with large datasets. If so required it can do synchronous replication
and parallelization too.

For specialty cases we set up JRuby or hand-compile Ruby 1.8.6.

–
Roderick van Domburg