I am upgrading from Rails 1.2.6 to Rails 2.1.0 on a system that I have inherited. The database is MySQL. The servers do not have mysql gem installed yet seem to work OK. I have always installed MySQL gem (v 2.7) even on my development machines. My questions are: 1. Should I install this gem as a part of the upgrade? 2. Is there anything that I need to look out for when I install this gem on the servers that have been working fine without it? I don''t do anything special on my machines, just install it since it is supposed to use better and speedier drivers. 3. Am I missing something here? This application was done by some people who were supposed to know that they were doing. In other words, fairly knowledgable and experienced in Ruby on Rails. I am just amazed that this gem is missing yet no one has noticed anything yet. I do not want to lead with my chin up. Thanks in advance for your advice. Bharat -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
There''s two ways to install it--the gem way or just install it by hand [i.e. download the source, run ruby extconf.rb, then make, or something along those lines--it installs it right into ruby''s lib folder, not into the gems folder]. You can tell if it''s installed this way by doing irb then require ''mysql'' if it works it probably is. On Sep 5, 11:03 am, Bharat Ruparel <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> I am upgrading from Rails 1.2.6 to Rails 2.1.0 on a system that I have > inherited. The database is MySQL. The servers do not have mysql gem > installed yet seem to work OK. I have always installed MySQL gem (v > 2.7) even on my development machines. My questions are: > > 1. Should I install this gem as a part of the upgrade? > 2. Is there anything that I need to look out for when I install this > gem on the servers that have been working fine without it? I don''t do > anything special on my machines, just install it since it is supposed to > use better and speedier drivers. > 3. Am I missing something here? This application was done by some > people who were supposed to know that they were doing. In other words, > fairly knowledgable and experienced in Ruby on Rails. I am just amazed > that this gem is missing yet no one has noticed anything yet. I do not > want to lead with my chin up. > > Thanks in advance for your advice. > > Bharat > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thanks Roger. Actually my first question is: should I install it even though the application does seem to be running fine without it? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Bharat Ruparel wrote:> Thanks Roger. > Actually my first question is: should I install it even though the > application does seem to be running fine without it?I''d say don''t fix what ain''t broke. If speed becomes an issue then look into it (to make sure that you''re not using the pure ruby version, which is slow), but until then just let it work :) -=R -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
The RoR app that I have inherited was running without MySQL native drivers on Ubuntu. I just installed MySQL gems to get the benifit of using Native drivers. However: 1. How do I know that the app has switched to using the native drivers instead of the slower ruby drivers. 2. It is an app running Mongrel cluster with a Capistrano deployment script. Will this gem take effect without redeploying (i.e. restarting)? Bharat -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 13 Sep 2008, at 13:51, Bharat Ruparel wrote:> The RoR app that I have inherited was running without MySQL native > drivers on Ubuntu. I just installed MySQL gems to get the benifit of > using Native drivers. However: > > 1. How do I know that the app has switched to using the native > drivers > instead of the slower ruby drivers.It says so in the log file (or better: it doesn''t warn you about the pure ruby one anymore).> 2. It is an app running Mongrel cluster with a Capistrano deployment > script. Will this gem take effect without redeploying (i.e. > restarting)?You''ll need to restart your cluster for it to take effect as far as I know. Best regards Peter De Berdt --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thanks Peter. I restarted the cluster. The speed difference is noticable. I have looked at the logfiles and they are clean. No mention of mysql gem though. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 13 Sep 2008, at 17:48, Bharat Ruparel wrote:> Thanks Peter. I restarted the cluster. The speed difference is > noticable. I have looked at the logfiles and they are clean. No > mention of mysql gem though.That''s what it should be. If you don''t have the native driver installed, the logs will say you are running the pure ruby version and you''re better off installing the native one. So all should be fine now. Best regards Peter De Berdt --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---