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 sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.