Book Image

Getting Started with CockroachDB

By : Kishen Das Kondabagilu Rajanna
Book Image

Getting Started with CockroachDB

By: Kishen Das Kondabagilu Rajanna

Overview of this book

Getting Started with CockroachDB will introduce you to the inner workings of CockroachDB and help you to understand how it provides faster access to distributed data through a SQL interface. The book will also uncover how you can use the database to provide solutions where the data is highly available. Starting with CockroachDB's installation, setup, and configuration, this SQL book will familiarize you with the database architecture and database design principles. You'll then discover several options that CockroachDB provides to store multiple copies of your data to ensure fast data access. The book covers the internals of CockroachDB, how to deploy and manage it on the cloud, performance tuning to get the best out of CockroachDB, and how to scale data across continents and serve it locally. In addition to this, you'll get to grips with fault tolerance and auto-rebalancing, how indexes work, and the CockroachDB Admin UI. The book will guide you in building scalable cloud services on top of CockroachDB, covering administrative and security aspects and tips for troubleshooting, performance enhancements, and a brief guideline on migrating from traditional databases. By the end of this book, you'll have gained sufficient knowledge to manage your data on CockroachDB and interact with it from your application layer.
Table of Contents (17 chapters)
1
Section 1: Getting to Know CockroachDB
4
Section 2: Exploring the Important Features of CockroachDB
9
Section 3: Working with CockroachDB
Appendix: Bibliography and Additional Resources

Appendix: Bibliography and Additional Resources

Here is a list of references used in the book:

  • Brian W. Kernighan and Alan A. A. Donovan: "The Go Programming Language", 2015
  • Eric Brewer: "CAP twelve years later: How the 'rules' have changed", Computer, Volume 45, Issue 2, pg. 23–29, 2012
  • Ongaro, Diego and John K. Ousterhout: "In Search of an Understandable Consensus Algorithm." USENIX Annual Technical Conference, 2014
  • Ramez Elmasri and Shamkant B. Navathe: "Fundamentals of Database Systems", 7th edition, 2016
  • Rebecca Taft et al.: "CockroachDB: The Resilient Geo-Distributed SQL Database." In Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data (SIGMOD'20), Portland, OR, USA, June 2020
  • Thomas H. Cormen, Charles E. Leiserson, Ronald L. Rivest, and Clifford Stein: "Introduction to Algorithms", 3rd edition. MIT Press, ISBN 978-0-262-03384-8, pp. I-XIX...