Lightning Talk: Power Up with Distributed Databases and CockroachDB

[seanlowjk]

Despite PostgreSQL including more extension to support distributed databases, they come at a cost of adding more extensions which can be troublesome. Instead of mimicking distributed databases, we can power ourselves up with using a proper distributed database system that provides high availability and in-built scaling techniques to solve big data problems we have today.

Round B:

WIIFY:

• Understand how CockroachDB is not difficult to learn as it builds on SQL concepts
• Understand how CockroachDB provides high availability solutions and prevents issues from single node failures.
• Understand how CockroachDB improves performance via its scaling capabilites.

Key Points:

1. CockraochDB is backwards-compatible with old SQL technologies such as PostgreSQL
2. CockroachDB helps with performance via distributed queries and sharding
3. CockroachDB protects against server crashes via its master-slave architecture.

Impact:

1. Know: What are distributed databases and what CockroachDB is
2. Believe: CockroachDB is the next step to providing better data access layers for OLTP applications
3. Do: Adopt CockroachDB instead of old SQL options in open source projects.

Slides: https://docs.google.com/presentation/d/17pxkJW5pTeDGSh9TrgZExp2mPeIFZSizECD-hEx5RIk/edit?usp=sharing

[seanlowjk]

Posted Slides above