ping database to keep connection alive

rubyonrails-talk
1

I'm running rails behind a firewall which times out idle tcp connections. What would be the best way to have rails ping the database every so many minutes? Or alternatively, is it possible to ping it myself before the session (which uses a database) is created?

Chris

2

Well it appears that I could use ActiveRecord::Base.connection.verify!, now the question is how to verify before the session is accessed.

3

The simplest way is to set up a cron job somewhere to curl http://myapp.

You could also experiment with something like Thread.new do loop { ActiveRecord:: Base.verify_active_connections!; sleep 300 } end

jeremy

4

I think you are right, the simplest is probably the best.