Facebook invented Cassandra, so I don't get your point. And Twitter wasn't exactly a WordPress site doing a needless vanity migration.

I don't think "use MySQL" really means the same thing at that scale.