The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

What’s New and Improved in YugabyteDB Docs – August 2020

Welcome to this month’s edition of what’s new and improved in YugabyteDB Docs. We’re continually adding to and updating the documentation to give you the information you need to make the most out of YugabyteDB. This post covers recent content added, and changes made, to the YugabyteDB documentation since the last posting.

Before we dive into the details, a reminder that YugabyteDB provides two distributed SQL APIs on top of DocDB, a common distributed document store built with inspiration from Google Spanner. The end result is a SQL database that is resilient, scalable, and geo-distributed.

YSQL

Develop apps

  • Client drivers
    The new client drivers for YSQL API page lists supported client drivers (by programming language) that can be used to connect to and interact with the YSQL API.

  • Deferred constraints on foreign keys
    Starting in YugabyteDB 2.2, you can mark foreign key constraints as `DEFERRABLE INITIALLY IMMEDIATE` and `INITIALLY DEFERRED`. For details, see the updated Deferrable constraints page.

  • Benchmark using TPC-C
    The updated Benchmark YugabyteDB using TPC-C page includes steps for you to benchmark the scaling performance (from 10 to 10,000 warehouses) of YugabyteDB YSQL running `oltpbench` with the TPC-C workload. For comparison, new results from in-house benchmarking are included.

Manage database clusters

  • Transactional distributed backup and restore
    The new YSQL snapshot and restore page covers the steps to create a backup of your distributed YSQL databases and to restore to recover from disasters or user errors.

  • Online index backfills
    Based on functionality added in YugabyteDB 2.2, the following new documentation covers how you can build indexes on non-empty tables while online, without failing other concurrent writes:

  • Track slow queries
    To help you track down unoptimized, or “slow” queries, see the documentation added for the new YB-TServer –ysql_log_min_duration_statement flag.

YCQL

Develop apps

  • Client drivers
    The new client drivers for YCQL API page lists supported client drivers (by programming language) that can be used to connect to and interact with the YCQL API.

Manage database clusters

  • Transactional distributed backup and restore
    The updated YCQL snapshot and restore page covers the steps to create a transactional backup of your YCQL tables (including associated secondary indexes) and to restore for disaster recovery.

  • Online index backfills
    Based on functionality added in YugabyteDB 2.2, the following new documentation covers how you can build indexes on non-empty tables while online, without failing other concurrent writes:

DocDB

These features are in the DocDB layer and as a result are common across both the distributed SQL APIs.

yugabyted parent server

The new yugabyted server acts as a parent server across YB-TServer and YB-Master that allows users to get started without knowing the underlying architecture. To see it in action, follow the updated Quick start.

What’s Next?

To help you learn and use YugabyteDB effectively and to get you the answers you need, we constantly update and add new topics to the YugabyteDB documentation. Here are a few ways you can contribute:

  • File GitHub issues for the docs. If you discover missing information, incorrect information, unclear explanations, or have new topics you’d like to see, click New issue and add the “area/documentation” label.
  • Contribute to the YugabyteDB docs. Share your knowledge and lessons learned with the Yugabyte by contributing to the YugabyteDB Docs. You will get recognition and rewards for your efforts as part of our recently launched Community Heroes program.
  • Ask questions and share answers in our Slack community. Your questions in the yugabyte-db Slack community are seen by fellow members and contributors who are there to help you move forward. Additionally, we routinely create new documentation pages based on topics that are of interest to Slack community users.

Related Posts