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.
