Thursday, March 27, 2014
I have a Rails app that makes connections to other DBs. There may be multiple users connecting to multiple DBs.
The app makes a database connection as part of an action. However, I noticed a problem: there's too many DB connections remaining open, which is causing the DB to not have enough connections remaining for new connections.
So the answer is using a shared connection pool. Importantly, the connection pool needs to be shared amongst different actions / HTTP requests.
Is there any middleware that extends Sequel's or ActiveRecord's connection pool to do this? (Or some code that someone can suggest to do this?)
Thanks.
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/83a783e7-7d94-4884-a6eb-b0aed69095a8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment