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? -- 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 [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 -~----------~----~----~----~------~----~------~--~---

