I think your information is outdated. Using the older MyISAM tables, concurrent updates do not scale well on MySQL. The newer InnoDB tables scale very well, and have the same sort of locking system that PostgreSQL has.