Breakout Session Presented by Jason Petersen of Citus Data at PGConf Silicon Valley 2015 скачать в хорошем качестве

Breakout Session Presented by Jason Petersen of Citus Data at PGConf Silicon Valley 2015

Sharding and Scaling PostgreSQL with pg_shard PostgreSQL alone is a powerful RDBMS made even greater by a strong ecosystem. So why do so many users write custom sharding logic in their applications? To address this need, Citus Data developed pg_shard, an open-source extension that manages the placement, distribution, and replication of sharded database tables. The extension maintains full compatibility with the standard PostgreSQL tool set, types, indexes, and semi-structured data types. We'll cover key principles of sharding and discuss previous forays in this space, before diving into the design and operation of pg_shard. Finally, we'll set up a cluster to demonstrate pg_shard's strength in building time-series and schemaless data stores similar to environments it is used in production today. Intended audience: PostgreSQL DBAs and application developers Topics covered: • Horizontal scaling • Logical sharding • Choosing a shard key • Parallelizing workloads • Redundancy & recovery • Designing shardable schemas • Impact on applications