[sqlalchemy] Re: Sharding with 2 pools of connections

2008-11-04 Thread Lenn0x
e, the VIP will notice this, and then the app servers will eventually knock the connections off with the recycle. -Chris On Nov 4, 3:39 pm, Lenn0x <[EMAIL PROTECTED]> wrote: > Again that is like a hardware vip (that solution is a bit more > complex) but the same issue still comes up. If

[sqlalchemy] Re: Sharding with 2 pools of connections

2008-11-04 Thread Lenn0x
dling this? Since I don't want extra load on 1 particular server since I am using persistent connections. On Nov 4, 2:40 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Nov 4, 2008, at 4:10 PM, Lenn0x wrote: > > > > > > > Hi > > > I have 2 sessio

[sqlalchemy] Sharding with 2 pools of connections

2008-11-04 Thread Lenn0x
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 = scoped_session(sessionmaker(autoflush=True, transacti