[Catalyst] Per request DBIX Class Schema Connections

[Moritz Onken]

Am 05.10.2009 um 08:35 schrieb Chris Grafham:

>
> Thanks for the suggestion, however I am limited to using a pure  
> DBIx::Class solution in the production environment.
>
> I have an existing setup that is kind of working, but not always  
> (FETCH's failing on prepared statements).  The setup is as follows:
>
> 1.  Determine write master or read slave connection based on URL.
> 2.  Set connect_info on DBIx catalyst model.
> 3.  Do queries.
> 4.  Disconnect from DBI storage handle.
>
> Will this result in clean connections and disconnects at the start  
> and end of the request? Or will catalyst cache connections or not  
> reset the schema object correctly for a new connection, especially  
> then switching between the master and slave  (note: I am not using  
> DBI::Apache).  Do I need to do an explicit re-connect to the schema  
> for each connection?

Did you have a look at DBIx::Class::Storage::DBI::Replicated? It has  
some features that allow you to force the communication to the master  
server. Just have a look at the pod.

moritz