database row locking versus multiversion concurrency control

hey everyone, ive been thinking about how we handle concurrent data access in our transactional systems. weve been using traditional row locking for most things, but im curious about the trade-offs with Multi-Version Concurrency Control (MVCC). what are your experiences with MVCC, especially for high-throughput read scenarios? any specific database systems youve found it particularly effective or problematic in?