Hello
I was wondering if there's a simple way to do per-host pooling.
Here's my use case: I have several hosts and on each one of them has
several databases hosted in mysql.
the engine is tied to a specific database when you create it, so the
default pool will pool connection on a specific database.
what I'd like to do is share the same pool of connectors across all
engines that are working with a given host.f
Example in pseudo-code:
pool_server1 = Pool('mysql://server1', size=10)
engine1 = create_engine('mysql://server1/database1', pool=pool_server1)
engine2 = create_engine('mysql://server1/database2', pool=pool_server1)
The goal is to reduce the number of sockets open for every host
Is there a way to do it with the existing pools ? If not, I guess
I'll work on a custom Pool,
Thanks
Tarek
--
Tarek Ziadé | http://ziade.org
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
