Shard-Query is a middleware solution for sharding MySQL databases. It rewrites queries to execute them in parallel over multiple cores of a single machine, or even multiple cores on multiple machines.
Here is a link comparing Shard-Query to Amazon Redshift: http://shardquery.com/2013/07/11/comparing-amazon-redshift-and-shard-query-features-and-performance/
Here is a set of slides about Shard-Query: http://www.slideshare.net/MySQLGeek/introduction-to-shard-query-m
This will be a combined meetup with SF MySQL!