Peter Rabbitson wrote: > Steve Bertrand wrote: >> (Un)fortunately, this was a case of reading from a stale replicated >> MySQL server... > > Are you doing the reading manually or are you using the Replicated > storage driver? If the former - take a look at Replicated. If the > later - make sure you wrap your inserts in a transaction - this will > trigger an "always-read-from-master" mode.
I am using Replicated, and I'll have a look at wrapping in a transaction. The entire DBIx::Class is a lot to take in... it took me two days to figure out that all I had to do to switch between Replicated storage and normal DBI storage via a config file was to create a simple subclass ;) ...quite different from what I'm used to. Steve _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
