Richness of Data Access with Polyglot Persistence
Channel: DATAVERSITY
Date: 2013-05-14

With any significant application, methods of data management never exist in isolation. These applications use a combination of document stores for super fast, super simple data access, other structured systems for analytics and even distributed file stores alongside SQL databases. The MySQL community has long been open to embracing many other ways of managing and storing application data with the core SQL database capabilities.

This session will focus on how data can flow between a caching document store, a store optimized for analytics and our flexible relational database. Playing the role of fast, flexible schemaless store is Couchbase Server. In the role of analytics for the data is Cloudera's Hadoop distribution. For richness of transaction capabilities and indexing, we have MySQL. Using all of the tools for persistence available today, one gains many new capabilities and higher scalability. Each does not deprecate the other; many deployments persist their data in two or more stores to optimize different ways of accessing and processing data.

Couchbase Server integrated with Cloudera's Hadoop distribution via Couchbase's TAP interface and Hadoop's sqoop. Equivalently, sqoop works with MySQL through it's JDBC interface. All three can come together to deliver capabilities that are otherwise not available from any one of the systems alone.

Couchbase Server is in widespread use at Zynga with more than 235 Million active users per month as the simple, fast, elastic document store behind multiple games. It is also deployed by by AOL to service billions of ad impressions per day with intelligence.