[storm] Disconnecting and Connecting a Storm Store Manually

[Gustavo Niemeyer]

Hello Jeremy,

Sorry for the slow response as well.  I've just now managed to cut
down my mailbox to a manageable size again, so I'm going through some
mails in the past month that went unhandled.

> As far as I can tell, one can close a Store down easily enough, which
> will wipe the underlying Connection's raw_connection, but there is no
> exposed way to start one back up.

You seem to have a use case that we haven't considered so far.

What's your motivation for:

1) Reducing the number of connections open to the database server.
You mention you have a large project, but so far the large projects
we've been in touch with want to do precisely the opposite: keeping a
number of connections open so that the handling time for a given
request is as reduced as possible.  Connections open are not generally
an expensive resource when talking about app => SQL database server
communication.

2) Closing and reopening the same Store, rather than simply recreating
a new one when you want a Store again.

3) Not reflecting the fact that you want to close unused connections
in the wait_time option of mysqld.  I don't understand details about
this option, but if it merely closes idle connections after a given
period, it looks like Storm would deal well with it.

I hope this gives you some ideas for how to solve the problem.  If you
still think that Storm should be extended, answering these questions
will help me understanding why.

-- 
Gustavo Niemeyer
http://niemeyer.net