It's a powerful tool with some serious computer science work behind it; for example Dr Phil Bernstein's research added its distributed transactions, which are a fascinating solution to the pronblem of running ACID across arbitrary networks where latency is unknown and strong consistency is not guaranteed.