I actually got the last insert ID working. However, not sure why, but blobs and text are screwed up. We have a couple of fields where we stored latex which is faxes to be sent. The latex is so screwed up the documents were lost. We did some testing and whenever blobs and text were used we had formatting issue like that.
Peter Halliday Excelsior Systems http://www.excelsiorsystems.net (Phone:) 607-936-2172 (Support:) 607-329-6905 (Fax:) 607-398-7928 > -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 7:44 AM > To: Peter Halliday > Cc: dbi-users@perl.org > Subject: Re: Problem with DBI::Multiplex > > On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote: > > I'm trying to load balance reads across two MySQL database > that have replication. The reads are working wonderfully. > The inserts actually do insert. However, there are some > table that use auto increment primary keys. I can't figure > out how to actually get those particular keys now. > > You could patch DBI::Multiplex so the last_insert_id method > uses the same dbh as the previous operation. > > Patches welcome. > > Tim. >
