Every YSQL table should have a primary key which identifies a unique row. A primary key has 2 components: The partition key […]
Read More
Display Tablet Leader/Follower Status on a Node
We learned in the YugabyteDB Tip View Metadata for YSQL/YCQL/System Tablets on a Server about the new (in YugabyteDB 2024.1) system view yb_local_tablets. The view […]
Read MoreQuicker Table Row Counts in YSQL
After loading a large dataset into a table, your next step might be to confirm that all records were successfully inserted. To […]
Read MoreEnsure a Read Replica Cluster is Strictly Read-Only
In YugabyteDB, read replicas are specialized nodes designed to handle read-heavy workloads by offloading read operations from the primary cluster. They are […]
Read MoreExtract YCQL Types Into DDL Commands
Migrating system metadata between YCQL Universes can be challenging since system keyspaces, such as system_schema, cannot be transferred using simple INSERT INTO […]
Read More