On Nov 4, 2008, at 4:10 PM, Lenn0x wrote:
Hi
I have 2 sessions created:
a_engine = create_engine('mysql:///host1', echo=True)
a_session = scoped_session(sessionmaker(autoflush=True,
transactional=True, bind=a_engine))
b_engine = create_engine('mysql:///host2', echo=True)
b_session =
After pondering this for awhile, I think the easiest solution would be
to do this:
1. Have it connect to a hardware vip that manages failovers etc to my
2 servers.
2. Have 1 dedicated pool, when the connect occurs on the vip, the vip
will evenly distribute.
3. Set the pool to have idle recycle