Ask HN: Using Cassandra instead of MySQL from the start?

Does it make sense to start off a potentially DB-bound project using Cassandra rather than go with a traditional MySQL setup? How is the perf of Cassandra compared to MySQL running on a single machine (512MB Xen VPS)?