CockroachDB: The Definitive Guide

Chapter 14. Administration and Troubleshooting

In previous chapters, we’ve shown you how to design and implement applications for the CockroachDB platform and how to create a CockroachDB deployment either in a fully managed cloud platform—CockroachDB Dedicated and Serverless—or in a self-hosted implementation on your own hardware or in a public cloud.

Now that you have your CockroachDB application implemented and your CockroachDB cluster in place, it’s time to consider the day-to-day administration and configuration tasks that are required to keep a CockroachDB deployment healthy and happy.

We’ll leave one of the most significant tasks—cluster optimization—to the final chapter because that topic is deep enough to require its own chapter.

Note that while a lot of these tasks are required only for self-hosted deployments, even a CockroachDB Dedicated or Serverless cloud cluster does require some care and attention. Choosing a CockroachDB Cloud option reduces your administration overhead dramatically; however, there still are some troubleshooting and configuration tasks, which we’ll cover in this chapter.

Monitoring

Production systems require some form of monitoring software that makes sure that the system is healthy and responsive and which collects performance and utilization metrics for longer-term planning. Without a monitoring system, you may not know if your database has stopped responding to requests. Furthermore, you might be unable to detect slow-moving performance or capacity ...