Company
Date Published
Author
Marko Rajcevic
Word count
1291
Language
English
Hacker News points
None

Summary

Distributed SQL systems, such as YugabyteDB, are being increasingly adopted for their ability to scale horizontally and handle large amounts of data. To approach multi-tenancy in a distributed SQL system, strategies like row-level security, multi-schema/multi DB, and tablegroups can be used to control access and storage requirements. Increasing the max connections for YSQL can also improve performance by scaling the cluster with additional nodes. However, row-level data recovery is not currently supported natively in YugabyteDB, but implementing a versioning scheme or using point-in-time recovery (PITR) can help address this issue. Additionally, writes in YugabyteDB only rewrite the columns that have changed, rather than rewriting the entire row.