Datascape Episode 28 – Getting to Know CockroachDB with Fernando Ipar

Posted in: Podcasts, Technical Track

Today on the show we welcome Fernando Ipar. Fernando is a Principal Consultant at Pythian. Prior to that, he worked for seven years in many roles at Percona and has over 10 years experience as a freelancer and a small business owner. Fernando has also been involved in the open source community as a user since 1997 and as a programmer since 2002, contributing to a few projects and leading some of his own. I recently got wind of Cockroach DB, the SQL database for global cloud services, and luckily, happened to know that Fernando is a devout enthusiast.

The CockroachDB process was introduced in 2015. It went from 1-0 in 2017 to 2-0 just last month – making it an exciting new program to explore! In this episode, Fernando takes us through the database and helps us understand what it is, where we can use it, how we can learn it and of course the burning question – why was it named after a cockroach?

Key Points From This Episode:

• Learn more about Fernando’s history in the industry to date.
• Discover why CockroachDB was named after a cockroach.
• Why the name CockroachDB stuck despite public requests to change it.
• Exactly what is Cockroach DB and how does it work?
• The difference between the free and paid version of CockroachDB.
• Geo-redundancy and how replication works with CockroachDB.
• Find out how CockroachDB leverages raft for consensus.
• Discover the most expensive operations on CockroachDB.
• Learn how a cluster is detected and how it reacts in CockroachDB.
• The language CockroachDB is written in and why it is inspired by Google Spanner.
• Which cloud should a cloud-scale database like CockroachDB be run on?
• Some of the customer implementations of the software.
• Query language and the SQL standards the program conforms to.
• The Cockroach Lab Forum and other good ways to learn the system.
• And much more!

Links Mentioned in Today’s Episode:Fernando Ipar Website
Fernando Ipar on LinkedIn
Mongo
Google Spanner
Galera
MySQL
CockroachDB
Cassandra
Nodes: The Art of Computer Programming
Carrie Millsap’s Optimizing Oracle Performance
Slack
E-Max

email

Interested in working with Chris? Schedule a tech call.

About the Author

Director of Consulting
Chris Presley loves order—making him a premier Microsoft SQL Server expert. Not only has he programmed and administered SQL Server, but he has also shared his expertise and passion with budding DBAs as SQL Server instructor at Conestoga College in Kitchener, Ontario. Drawing on his strong disaster-recovery skills, he monitors production environments to swiftly detect and resolve problems before they arise. A self-described adrenaline junkie, Chris likes tackling the biggest database problems and putting out the toughest fires—and hitting the road on his motorcycle.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *