Also I have added connected_to() inside action but I did not get the desired result from r6_multidb_development_copy, may be I am missing something.
def index ActiveRecord::Base.connected_to(role: :reading) do @articles = Article.all end end On Wednesday, April 24, 2019 at 6:00:07 PM UTC+5:45, eileencodes wrote: > > Ok after reading this over a few times I've realized that you wrote broken > code on purpose to prove the switching was working. > > Did you turn on the middleware that will automatically swap based on HTTP > verb? If you didn't your POST/GET requests won't switch connections > automatically. > > If you're in a model/controller/test you need to wrap it in a > `connected_to` block like this > > ``` > ActiveRecord::Base.connected_to(role: :reading) do > # read from your replica > end > ``` > > Rails can't know if your replica is up to date so we didn't implement > always select from the replica, you have to tell it you want that. > > On Wednesday, April 24, 2019 at 8:04:45 AM UTC-4, eileencodes wrote: >> >> Hey! >> >> I've implemented multiple databases in Rails 6, but I didn't implement >> multiple *writers*. Rails doesn't know what your replica configuration >> is going to be like so for purposes of local development you should use the >> same database name for your primary and replica, and then have different >> user names. In production you should also use the same name (they are the >> same data you're accessing) with different usernames (one set to readonly) >> but they shouldn't be in the same place. >> >> Hope that helps, >> Eileen >> >>> -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-core+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-core@googlegroups.com. Visit this group at https://groups.google.com/group/rubyonrails-core. For more options, visit https://groups.google.com/d/optout.