-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jack Christensen wrote:
> 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.
>
What if I want it on other SQL server?
davi
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkltDOUACgkQ76Bs0E5RGKO3twCePRLi1tyfJM1FTGgQX3jiT7Co
BDgAnilihvAKaFQE+17ifR4RaASgLqjV
=a/a+
-----END PGP SIGNATURE-----
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
