Sep 18, 2013
 Percona Live MySQL Webinar
  Justin Swanhart

To view the webinar recording, visit: http://www.percona.com/resources/mysql-webinars/introduction-open-source...

This presentation will introduce the concept of column stores and contrast them with traditional row stores. It will then introduce a set of open source column store databases. The available features of each of the databases will be compared and contrasted. Finally the performance of loading a star schema and executing some mildly complex queries will be compared for each database, and the results will be compared with XtraDB, a row store.

The following open source products will be demonstrated and compared:

Infobright Community Edition (A MySQL column store)
LucidDB
MonetDB
XtraDB (A MySQL row store)



About the Author

Justin Swanhart

Justin is a Principal Support Engineer on the support team. In the past, he was a trainer at Percona and a consultant. Justin also created and maintains Shard-Query, a middleware tool for sharding and parallel query execution and Flexviews, a tool for materialized views for MySQL. Prior to working at Percona Justin consulted for Proven Scaling, was a backend engineer at Yahoo! and a database administrator at Smule and Gazillion games.