Yanni Mac wrote: > I have an application that is load balanced. I have a master database > which I update once a day. Then I push the raw mysql files to all other > servers so they are the same as the master. This works fine, but there > are a few situations where I need all databases to update in real-time. > What would be the best way to achieve this in rails? > > Here is an example of what I am trying to do. I want to update the name > of a product on my website. Here is the controller: > > def update_product_name > product = Product.find(params[:id]) > product.name = params[:name] > product.save > #Say I want to save this to 3 other databases > #can I do this with activerecord? > #PSUEDO CODE... I know it cant do this > product.save(mysql_host2) > product.save(mysql_host3) > product.save(mysql_host4) > end > > Any ideas? Alternative ways to do this? > You could use MySQL's built-in replication support.
-- Jack Christensen [email protected] --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
