I've worked on large (10,000 hits an hour) clustered web applications using Mason, mod_perl and Apache::DBI and never once had a problem with the last_insert_id function.

MyISAM tables locking on every insert, now there's another problem... :-)