# What is the best linux version for rails project **URL:** \ **Category:** Deployment\ **Created:** [May 10, 2008, 9:51am UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221 "2008-05-10T09:51:33Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 10, 2008, 9:51am UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/1 "2008-05-10T09:51:33Z")
what is the best linux version for rails project ? and what is the best databse for rails project ? ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 10, 2008, 6:34pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/2 "2008-05-10T18:34:01Z")
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 ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 16, 2008, 7:31pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/3 "2008-05-16T19:31:08Z")
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. ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 16, 2008, 7:40pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/4 "2008-05-16T19:40:12Z")
On Sat, May 10, 2008 at 12:51 AM, Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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. 😉 Cheers, Robby – Robby R. Founder and Executive Director PLANET ARGON, LLC Design, Development, and Hosting with Ruby on Rails > **[Planet Argon](https://www.planetargon.com/)** > > Planet Argon is a Ruby on Rails development agency specializing in maintenance and support for existing Rails apps. Based in Portland, OR, Planet Argon has been a member of the Rails community since 2004. [http://www.robbyonrails.com/](http://www.robbyonrails.com/) aim: planetargon +1 503 445 2457 +1 877 55 ARGON [toll free] +1 815 642 4068 [fax] ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 22, 2008, 1:32pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/5 "2008-05-22T13:32:06Z")
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 \< removed\_email\_address@domain.invalid\> wrote: > > – Greg N. Rails Developer & Designer Owner, [carbon8.us](http://carbon8.us) Blog, [20seven.org](http://20seven.org) ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 22, 2008, 4:56pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/6 "2008-05-22T16:56:07Z")
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: removed\_email\_address@domain.invalid 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 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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](http://carbon8.us) Blog, [20seven.org](http://20seven.org) ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 22, 2008, 9:20pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/7 "2008-05-22T21:20:53Z")
On May 16, 2008, at 10:39 AM, Robby R. wrote: > On Sat, May 10, 2008 at 12:51 AM, Pokkai D. > [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 😉 > > and what is the best databse for rails project ? > > PostgreSQL. There is a huge _community_ behind it… kind of like Ruby > and Rails. 😉 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- - Ezra Z. – Founder & Software Architect – removed\_email\_address@domain.invalid – [EngineYard.com](http://EngineYard.com) ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 22, 2008, 9:34pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/8 "2008-05-22T21:34:24Z")
----- Original Message ----- From: “Ezra Z.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) To: [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 22, 2008, 1:17pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/9 "2008-05-22T13:17:18Z")
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 > **[Ruby on Rails Development Company | RoR Development Company](https://railsfactory.com/)** > > Largest pure play ruby on rails > development company delivering best-in-class web & mobile application > development services. ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 23, 2008, 12:50am UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/10 "2008-05-23T00:50:45Z")
Also very good info, Ericson. Thanks for the follow up! Raul ----- Original Message ----- From: Ericson S. To: removed\_email\_address@domain.invalid 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 -](http://highscalability.com/skype-plans-postgresql-scale-1-billion-users) - Ericson S. CTO [http://www.funadvice.com](http://www.funadvice.com) On Thu, May 22, 2008 at 3:33 PM, Raul [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: ``` ----- Original Message ----- From: "Ezra Z." To: 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 ``` ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 22, 2008, 9:37pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/11 "2008-05-22T21:37:56Z")
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 -](http://highscalability.com/skype-plans-postgresql-scale-1-billion-users)** > > Skype uses PostgreSQL as their backend database . PostgreSQL doesn't get enough run in the databas... - Ericson S. CTO [http://www.funadvice.com](http://www.funadvice.com) ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 23, 2008, 1:51am UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/12 "2008-05-23T01:51:03Z")
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 ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [May 23, 2008, 1:58am UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/13 "2008-05-23T01:58:39Z")
Best is such an ugly word. There is no “best”. Each will have its pros and cons. ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [June 7, 2008, 2:41am UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/14 "2008-06-07T02:41:26Z")
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. ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [June 13, 2008, 6:32am UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/15 "2008-06-13T06:32:58Z")
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. ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [June 13, 2008, 1:16pm UTC](https://www.ruby-forum.com/t/what-is-the-best-linux-version-for-rails-project/137221/16 "2008-06-13T13:16:03Z")
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 > **[De domeinnaam Nedforce.nl is te koop.](http://www.nedforce.nl)** > > Deze mooie domeinnaam kan al over een paar minuten van jou zijn. Betalen gaat eenvoudig en vertrouwd via iDEAL. Direct na de betaling ontvang je de verhuiscode per e-mail en kun je aan de slag.