The thing I don't understand about mongodb is that it makes a tradeoff for scalability.

The secret ingredient in the horizontal scaling sauce is giving up inter node ACID transactions.

Nothing prevents you from making the same tradeoff with mysql or postgresql.