Is It Possible To Have Two Databases, One For Reading, One For Writing? In order to improve performance.
Posted 18 August 2013 - 12:53 AM
is there any way to?:
1) Have 2 database components declared for my application, one pointing to a master database, for writing, and one (or many, ideally) read only replicating databases, for reading only data
2) Redirect writings automatically to master and readings to replica?
If it is not possible, it would be a great addition. If it possible, please be kind and point me to the right direction
Thanks in advanced.
Posted 18 August 2013 - 12:33 PM
What database are you using?
Yeah, the database part is already solved. But how can You know which database to use for readings and with for writings? That's it, how can activerecord's find know that it must read from replica and how can save know it must write to master?
Posted 18 August 2013 - 12:42 PM
Posted 18 August 2013 - 04:41 PM
Thanks a lot. I'll give the extension a try.