YugabyteDB
    OR Ask AIAsk AI
    • Star us on Github YugabyteDB Github
    • Join us on Slack YugabyteDB Community Slack
    • Start Now
      • YugabyteDB Aeon
        YugabyteDB AeonTry our fully-managed cloud DBaaS for free.No credit card requiredSign up
      • YugabyteDB
        YugabyteDBTry our open source distributed SQL database on your laptop.Download
    • Products
      • YugabyteDB
        YugabyteDBThe open source distributed SQL database
      • YugabyteDB Anywhere
        YugabyteDB AnywhereSelf-managed cloud DBaaS
      • YugabyteDB Aeon
        YugabyteDB AeonFully-managed cloud DBaaS
      • YugabyteDB Voyager
        YugabyteDB VoyagerDatabase migration service
    • Tutorials
    • Integrations
    • FAQ
    • Releases
      • YugabyteDB
        YugabyteDB
      • YugabyteDB Anywhere
        YugabyteDB Anywhere
      • YugabyteDB Aeon
        YugabyteDB Aeon
      • YugabyteDB Voyager
        YugabyteDB Voyager
      • Tech Advisories
        Tech Advisories
    Docs Menu
    • Docs Home
    • YugabyteDB
    • Quick Start
    • Explore
      • SQL vs NoSQL
      • SQL features
        • SQL feature support
        • PostgreSQL compatibility
        • Schemas and tables
        • Data types
        • Data manipulation
        • Expressions and operators
        • Queries and joins
        • Join strategies
        • Indexes and constraints
          • Primary keys
          • Foreign keys
          • Secondary indexes
          • Unique indexes
          • Partial indexes
          • Covering indexes
          • Expression indexes
          • GIN indexes
          • Other constraints
          • Index backfill
        • JSON support
        • Stored procedures
        • Advanced features
          • Cursors
          • Table partitioning
          • Views
          • Savepoints
          • Collations
          • Foreign data wrappers
          • Triggers
        • PostgreSQL extensions
          • Install extensions
          • auto_explain
          • file_fdw
          • fuzzystrmatch
          • HypoPG
          • passwordcheck
          • pg_cron
          • pg_stat_statements
          • pgcrypto
          • pgvector
          • postgres_fdw
          • postgresql-hll
          • spi
          • tablefunc
          • uuid-ossp
      • Beyond PostgreSQL
        • Follower reads
        • Geo-placement
        • Configurable data sharding
        • Native async replication
        • Cluster topology
        • Cluster-aware drivers
        • Topology-aware drivers
        • Built-in connection pooling
        • Gen-AI apps
        • Decouple storage and compute
      • YCQL features
        • Cassandra feature support
        • Keyspaces and tables
        • Data types
        • Indexes and constraints
          • Primary keys
          • Secondary indexes
          • Unique indexes
          • Partial indexes
          • Covering indexes
          • Secondary indexes with JSONB
        • JSON support
      • Horizontal scalability
        • Horizontal vs vertical
        • Data distribution
        • Adding nodes
        • Scaling reads
        • Scaling writes
        • Scaling transactions
        • Large datasets
        • Scale out a universe
      • Resiliency
        • Node failures
        • Rack failures
        • Zone failures
        • Region failures
        • Periodic maintenance
        • Transactions
      • Transactions
        • Distributed transactions
        • Isolation levels
        • Explicit locking
      • Colocation
      • Multi-region deployments
        • Synchronous (3+ regions)
        • Row-level geo-partitioning
        • Read replicas
      • Change data capture
        • PostgreSQL protocol
          • Key concepts
          • Get started
          • Monitor
          • Advanced configuration
          • Advanced topics
          • Best practices
          • YugabyteDB connector
        • gRPC protocol
          • Get started
          • Monitor
          • YugabyteDB gRPC Connector
      • Cluster management
        • Point-in-time recovery
      • Observability
        • Prometheus integration
        • Grafana dashboard
        • Live queries
        • Tablet metadata
        • Terminated queries
        • Data transfer status
        • Lock insights
        • Active Session History
      • Query tuning
        • Introduction
        • Get query statistics
        • Analyze queries
        • Optimize YSQL queries
      • Security
    • Develop
      • Data modeling
        • Primary keys
        • Secondary indexes
        • Hot shards
        • Partitioning tables
        • Common patterns
          • Time series
            • Global ordering by time
            • Ordering by time per entity
            • Automatic data expiration
            • Partition data by time
          • Key-value
      • Build global applications
        • Global database
        • Duplicate indexes
        • Active-active single-master
        • Active-active multi-master
        • Latency-optimized geo-partitioning
        • Locality-optimized geo-partitioning
        • Follower reads
        • Read replicas
        • Real world scenarios
          • Global and geo-local tables
      • Build multi-cloud applications
        • Multi-cloud setup
        • Multi-cloud migration
        • Hybrid cloud
      • Learn app development
        • Transactions
          • Transaction retries
          • Performance tuning
          • Global applications
          • Error codes
        • Text search
          • Pattern matching
          • Similarity search
          • Full-text search
          • Phonetic search
        • Aggregations
        • Batch operations
        • Date and time
        • Strings and text
        • TTL for data expiration
      • Best practices
      • Drivers and ORMs
        • Smart drivers
        • Java
          • JDBC Drivers
          • Connect an app
          • Use an ORM
        • Go
          • Go Drivers
          • Connect an app
          • Use an ORM
        • Python
          • Python Drivers
          • Connect an app
          • Use an ORM
        • Node.js
          • Node.js Drivers
          • Connect an app
          • Use an ORM
        • Elixir
          • Phoenix
        • C
          • Connect an app
        • C++
          • Connect an app
        • C#
          • C# Drivers
          • Connect an app
          • Use an ORM
        • Ruby
          • Connect an app
          • Use an ORM
        • PHP
          • Connect an app
          • Use an ORM
        • Rust
          • Rust Drivers
          • Connect an app
          • Use an ORM
        • Build apps using ORMs
          • Java
          • Go
          • Python
          • Node.js
          • C#
          • Rust
          • PHP
        • Scala
          • Connect an app
        • Additional drivers
      • Quality of service
        • Rate limiting connections
        • Write-heavy workloads
        • Transaction priorities
      • Cloud-native development
        • Codespaces
        • Gitpod
    • Secure
      • Security checklist
      • Enable authentication
        • Enable users
        • Create login profiles
        • Configure client authentication
      • Authentication methods
        • Password authentication
        • LDAP authentication
        • Host-based authentication
        • Trust authentication
      • Role-based access control
        • Overview
        • Manage users and roles
        • Grant privileges
        • Row-level security
        • Column-level security
      • Encryption in transit
        • Create server certificates
        • Enable server-to-server encryption
        • Enable client-to-server encryption
        • Connect to clusters
        • TLS and authentication
      • Encryption at rest
      • Column-level encryption
      • Audit logging
        • Trace statements
        • Configure audit logging
        • Session-level audit logging
        • Object-level audit logging
      • Vulnerability disclosure policy
    • Launch and Manage
      • Deploy
        • Deployment checklist
        • Manual deployment
          • 1. System configuration
          • 2. Install software
          • 3. Start YB-Masters
          • 4. Start YB-TServers
          • 5. Verify deployment
        • Kubernetes
          • Single-zone
            • Open Source
            • Amazon EKS
            • Google Kubernetes Engine
            • Azure Kubernetes Service
          • Multi-zone
            • Amazon EKS
            • Google Kubernetes Engine
          • Multi-cluster
            • Google Kubernetes Engine
          • Best practices
          • Connect Clients
        • Public clouds
          • Amazon Web Services
          • Google Cloud Platform
          • Microsoft Azure
        • Multi-DC deployments
          • Three+ data center (3DC)
          • xCluster deployments
            • xCluster
            • Transactional xCluster
              • Set up replication
              • Failover
              • Switchover
              • Manual DDL changes
          • Read replicas
      • Manage
        • Backup and restore
          • Export and import
          • Distributed snapshots
          • Point-in-time recovery
          • Instant database cloning
        • Migrate
          • Export data
          • Import data
          • Verify migration
          • Migrate from PostgreSQL
        • Change cluster configuration
        • Diagnostics reporting
        • Upgrade YugabyteDB
      • Monitor
        • Metrics
          • Throughput+latency metrics
          • Connection metrics
          • Cache and storage metrics
          • Raft metrics
          • YB-Master metrics
          • Replication metrics
      • Troubleshoot
        • Cluster-level issues
          • YCQL API connection issues
          • Recover YB-TServer and YB-Master
          • Replace a failed YB-TServer
          • Replace a failed YB-Master
          • Manual remote bootstrap of failed peer
          • Recover YB-TServer from crash loop
          • Performance issues
        • Node-level issues
          • Check servers
          • Inspect logs
          • System statistics
          • Disk failure
          • Disk Full
          • Common error messages
        • YSQL issues
        • Other issues
    • Benchmark
      • TPC-C
        • Run benchmark
        • Testing horizontal scalability
        • Testing high scale workloads
      • sysbench
      • YCSB
      • Key-value workload
      • Large datasets
      • Scalability
        • Scaling queries
      • Resilience
        • Jepsen testing
    • YSQL
      • Statements
        • ABORT
        • ALTER DATABASE
        • ALTER DEFAULT PRIVILEGES
        • ALTER DOMAIN
        • ALTER FOREIGN DATA WRAPPER
        • ALTER FOREIGN TABLE
        • ALTER FUNCTION
        • ALTER GROUP
        • ALTER INDEX
        • ALTER MATERIALIZED VIEW
        • ALTER POLICY
        • ALTER PROCEDURE
        • ALTER PUBLICATION
        • ALTER ROLE
        • ALTER SCHEMA
        • ALTER SEQUENCE
        • ALTER SERVER
        • ALTER TABLE
        • ALTER USER
        • ANALYZE
        • BEGIN
        • CALL
        • CLOSE
        • COMMENT
        • COMMIT
        • COPY
        • CREATE AGGREGATE
        • CREATE CAST
        • CREATE DATABASE
        • CREATE DOMAIN
        • CREATE EXTENSION
        • CREATE FOREIGN DATA WRAPPER
        • CREATE FOREIGN TABLE
        • CREATE FUNCTION
        • CREATE GROUP
        • CREATE INDEX
        • CREATE MATERIALIZED VIEW
        • CREATE OPERATOR
        • CREATE OPERATOR CLASS
        • CREATE POLICY
        • CREATE PROCEDURE
        • CREATE PUBLICATION
        • CREATE ROLE
        • CREATE RULE
        • CREATE SCHEMA
        • CREATE SEQUENCE
        • CREATE SERVER
        • CREATE TABLE
        • CREATE TABLE AS
        • CREATE TABLESPACE
        • CREATE TRIGGER
        • CREATE TYPE
        • CREATE USER
        • CREATE USER MAPPING
        • CREATE VIEW
        • CREATE_REPLICATION_SLOT
        • DEALLOCATE
        • DECLARE
        • DELETE
        • DO
        • DROP AGGREGATE
        • DROP CAST
        • DROP DATABASE
        • DROP DOMAIN
        • DROP EXTENSION
        • DROP FOREIGN DATA WRAPPER
        • DROP FOREIGN TABLE
        • DROP FUNCTION
        • DROP GROUP
        • DROP INDEX
        • DROP MATERIALIZED VIEW
        • DROP OPERATOR
        • DROP OPERATOR CLASS
        • DROP OWNED
        • DROP POLICY
        • DROP PROCEDURE
        • DROP PUBLICATION
        • DROP ROLE
        • DROP RULE
        • DROP SCHEMA
        • DROP SEQUENCE
        • DROP SERVER
        • DROP TABLE
        • DROP TABLESPACE
        • DROP TRIGGER
        • DROP TYPE
        • DROP USER
        • DROP_REPLICATION_SLOT
        • END
        • EXECUTE
        • EXPLAIN
        • FETCH
        • GRANT
        • IMPORT FOREIGN SCHEMA
        • INSERT
        • LOCK
        • MOVE
        • PREPARE
        • REASSIGN OWNED
        • REFRESH MATERIALIZED VIEW
        • RELEASE SAVEPOINT
        • RESET
        • REVOKE
        • ROLLBACK
        • ROLLBACK TO SAVEPOINT
        • SAVEPOINT
        • SELECT
        • SET
        • SET CONSTRAINTS
        • SET ROLE
        • SET SESSION AUTHORIZATION
        • SET TRANSACTION
        • SHOW
        • SHOW TRANSACTION
        • START TRANSACTION
        • START_REPLICATION
        • TRUNCATE
        • UPDATE
        • VALUES
      • Data types
        • Array
          • array[] constructor
          • Literals
            • Text typecasting and literals
            • Array of primitive values
            • Row
            • Array of rows
          • FOREACH loop (PL/pgSQL)
          • array of DOMAINs
          • Functions and operators
            • ANY and ALL
            • Array comparison
            • Array slice operator
            • Array concatenation
            • Array properties
            • array_agg(), unnest(), generate_subscripts()
            • array_fill()
            • array_position(), array_positions()
            • array_remove()
            • array_replace() / set value
            • array_to_string()
            • string_to_array()
        • Binary
        • Boolean
        • Character
        • Date and time
          • Conceptual background
          • Section contents
          • Timezones and UTC offsets
            • Catalog views
            • Extended_timezone_names
              • Unrestricted full projection
              • Real timezones with DST
              • Real timezones no DST
              • Synthetic timezones no DST
            • Offset/timezone-sensitive operations
              • Timestamptz to/from timestamp conversion
              • Pure 'day' interval arithmetic
            • Four ways to specify offset
              • Name-resolution rules
                • 1 case-insensitive resolution
                • 2 ~names.abbrev never searched
                • 3 'set timezone' string not resolved in ~abbrevs.abbrev
                • 4 ~abbrevs.abbrev before ~names.name
                • Helper functions
            • Syntax contexts for offset
            • Recommended practice
          • Typecasting between date-time and text-values
          • Semantics of the date-time data types
            • Date data type
            • Time data type
            • Plain timestamp and timestamptz
            • Interval data type
              • Interval representation
                • Ad hoc examples
                • Representation model
              • Interval value limits
              • Declaring intervals
              • Justify() and extract(epoch...)
              • Interval arithmetic
                • Interval-interval comparison
                • Interval-interval addition and subtraction
                • Interval-number multiplication
                • Moment-moment overloads of "-"
                • Moment-interval overloads of "+" and "-"
              • Custom interval domains
              • Interval utility functions
          • Typecasting between date-time data types
          • Operators
            • Test comparison overloads
            • Test addition overloads
            • Test subtraction overloads
            • Test multiplication overloads
            • Test division overloads
          • General-purpose functions
            • Creating date-time values
            • Manipulating date-time values
            • Current date-time moment
            • Delaying execution
            • Miscellaneous
              • Function age()
              • Function extract() | date_part()
              • Implementations that model the overlaps operator
          • Formatting functions
          • Case study: SQL stopwatch
          • Download & install the date-time utilities
        • JSON
          • JSON literals
          • Primitive and compound data types
          • Code example conventions
          • Indexes and check constraints
          • Functions & operators
            • ::jsonb, ::json, ::text (typecast)
            • ->, ->>, #>, #>> (JSON subvalues)
            • - and #- (remove)
            • || (concatenation)
            • = (equality)
            • @> and <@ (containment)
            • ? and ?| and ?& (key or value existence)
            • array_to_json()
            • jsonb_agg()
            • jsonb_array_elements()
            • jsonb_array_elements_text()
            • jsonb_array_length()
            • jsonb_build_object()
            • jsonb_build_array()
            • jsonb_each()
            • jsonb_each_text()
            • jsonb_extract_path()
            • jsonb_extract_path_text() and json_extract_path_text()
            • jsonb_object()
            • jsonb_object_agg()
            • jsonb_object_keys()
            • jsonb_populate_record()
            • jsonb_populate_recordset()
            • jsonb_pretty()
            • jsonb_set() and jsonb_insert()
            • jsonb_strip_nulls()
            • jsonb_to_record()
            • jsonb_to_recordset()
            • jsonb_typeof()
            • row_to_json()
            • to_jsonb()
        • Money
        • Numeric
        • Range
        • Serial
        • UUID
      • Functions and operators
        • Sequence functions
          • currval()
          • lastval()
          • nextval()
          • setval()
        • Aggregate functions
          • Informal functionality overview
          • Invocation syntax and semantics
          • Grouping sets, rollup, cube
          • Per function signature and purpose
            • avg(), count(), max(), min(), sum()
            • array_agg(), string_agg(), jsonb_agg(), jsonb_object_agg()
            • bit_and(), bit_or(), bool_and(), bool_or()
            • variance(), var_pop(), var_samp(), stddev(), stddev_pop(), stddev_samp()
            • linear regression
              • covar_pop(), covar_samp(), corr()
              • regr_%()
            • mode(), percentile_disc(), percentile_cont()
            • rank(), dense_rank(), percent_rank(), cume_dist()
          • Case study: percentile_cont() and the "68–95–99.7" rule
          • Case study: linear regression on COVID data
            • Download the COVIDcast data
            • Ingest the COVIDcast data
              • Inspect the COVIDcast data
              • Copy the .csv files to staging tables
              • Check staged data conforms to the rules
              • Join the staged data into a single table
              • SQL scripts
                • Create cr_staging_tables()
                • Create cr_copy_from_scripts()
                • Create assert_assumptions_ok()
                • Create xform_to_covidcast_fb_survey_results()
                • ingest-the-data.sql
            • Analyze the COVIDcast data
              • symptoms vs mask-wearing by day
              • Data for scatter-plot for 21-Oct-2020
              • Scatter-plot for 21-Oct-2020
              • SQL scripts
                • analysis-queries.sql
                • synthetic-data.sql
        • Geo-partitioning helper functions
          • yb_is_local_table()
          • yb_server_cloud()
          • yb_server_region()
          • yb_server_zone()
        • Window functions
          • Informal functionality overview
          • Invocation syntax and semantics
          • Per function signature and purpose
            • row_number(), rank() and dense_rank()
            • percent_rank(), cume_dist() and ntile()
            • first_value(), nth_value(), last_value()
            • lag(), lead()
            • Tables for the code examples
              • table t1
              • table t2
              • table t3
              • table t4
          • Case study: analyzing a normal distribution
            • Bucket allocation scheme
            • do_clean_start.sql
            • cr_show_t4.sql
            • cr_dp_views.sql
            • cr_int_views.sql
            • cr_pr_cd_equality_report.sql
            • cr_bucket_using_width_bucket.sql
            • cr_bucket_dedicated_code.sql
            • do_assert_bucket_ok
            • cr_histogram.sql
            • cr_do_ntile.sql
            • cr_do_percent_rank.sql
            • cr_do_cume_dist.sql
            • do_populate_results.sql
            • do_report_results.sql
            • do_compare_dp_results.sql
            • do_demo.sql
            • Reports
              • Histogram report
              • dp-results
              • compare-dp-results
              • int-results
        • yb_hash_code()
      • Cursors
      • Subprograms and anonymous blocks
        • «Commit» in user-defined subprograms
        • Subprogram attributes
          • "Depends on extension" semantics
          • Alterable subprogram attributes
          • Alterable function-only attributes
            • Immutable function examples
        • "language sql" subprograms
        • "language plpgsql" subprograms
          • Create-time and execution model
          • "language plpgsql" syntax and semantics
            • Declaration section
            • Executable section
              • Basic statements
                • "assert" statement
                • "get diagnostics" statement
                • "raise" statement
                • "return" statement
                • Cursor manipulation
                • Doing SQL from PL/pgSQL
              • Compound statements
                • The "if" statement
                • The "case" statement
                • The "loop", "exit", and "continue" statements
                  • Infinite and while loops
                  • Integer for loop
                  • Array foreach loop
                  • Query for loop
                  • Jumping out of a block statement with "exit"
                  • Two case studies
            • Exception section
          • Case study: PL/pgSQL procedures-for role provisioning
        • Subprogram overloading
        • Variadic and polymorphic subprograms
        • Name resolution in subprograms
        • The "pg_proc" catalog table
      • Keywords
      • Language internals
        • Transaction model for top-level SQL statements
        • Names and identifiers
        • Name resolution in top-level SQL
        • Reserved names
        • Temporary schema-objects
          • Temp tables, views, sequences, and indexes
          • Temp schema-objects of all kinds
          • Globality of metadata and privacy of use of temp objects
          • Paradigm for creating temporary objects
        • WITH clause
          • WITH clause—SQL syntax and semantics
          • Recursive CTE
          • Case study: traversing an employee hierarchy
          • Traversing general graphs
            • Graph representation
            • Common code
            • Undirected cyclic graph
            • Directed cyclic graph
            • Directed acyclic graph
            • Rooted tree
            • Unique containing paths
            • Stress testing find_paths()
          • Case study: Bacon Numbers from IMDb
            • Bacon numbers for synthetic data
            • Bacon numbers for IMDb data
    • YCQL
      • Statements
        • ALTER KEYSPACE
        • ALTER ROLE
        • ALTER TABLE
        • CREATE INDEX
        • CREATE KEYSPACE
        • CREATE ROLE
        • CREATE TABLE
        • CREATE TYPE
        • DROP INDEX
        • DROP KEYSPACE
        • DROP ROLE
        • DROP TABLE
        • DROP TYPE
        • GRANT PERMISSION
        • GRANT ROLE
        • REVOKE PERMISSION
        • REVOKE ROLE
        • USE
        • INSERT
        • SELECT
        • EXPLAIN
        • UPDATE
        • DELETE
        • TRANSACTION
        • TRUNCATE
        • BATCH
      • Data Types
        • BLOB
        • BOOLEAN
        • Collection
        • FROZEN
        • INET
        • Integer and counter
        • Non-integer
        • TEXT
        • DATE, TIME, and TIMESTAMP
        • UUID and TIMEUUID
        • JSONB
      • Functions & Expressions
        • Simple expressions
        • Subscripted expressions
        • Function call
        • Operators
        • Date and time
    • Reference
      • Key concepts
      • Architecture
        • Design goals
        • YQL - Query layer
        • System catalog
        • DocDB - Storage layer
          • Data model
          • Packed rows
          • LSM & SST
          • Performance
        • Sharding
          • Hash and range sharding
          • Tablet splitting
        • Replication
          • Raft
          • Synchronous
          • xCluster
          • Read replicas
          • CDC using PostgreSQL protocol
          • CDC using gRPC protocol
        • Transactions
          • Fundamentals
          • Distributed transactions
          • Transactional I/O path
          • Single-row transactions
          • Isolation levels
          • Concurrency control
          • Transaction priorities
          • Read Committed
          • Read Restart error
        • YB-Master
        • YB-TServer
      • APIs
      • CLIs
        • ysqlsh
          • Meta-commands
            • pset options
            • Examples
        • ycqlsh
        • yb-admin
        • yb-ts-cli
        • ysql_dump
        • ysql_dumpall
        • yb-ctl
        • yb-docker-ctl
      • Configuration
        • yb-tserver
        • yb-master
        • yugabyted
        • Operating systems
        • Default ports
      • Sample datasets
        • Chinook
        • Northwind
        • PgExercises
        • SportsDB
        • Retail Analytics
      • Misc
        • YEDIS
          • Quick start
          • Develop
            • Build an application
            • C#
            • C++
            • Go
            • Java
            • NodeJS
            • Python
          • API reference
            • APPEND
            • AUTH
            • CONFIG
            • CREATEDB
            • DELETEDB
            • LISTDB
            • SELECT
            • DEL
            • ECHO
            • EXISTS
            • EXPIRE
            • EXPIREAT
            • FLUSHALL
            • FLUSHDB
            • GET
            • GETRANGE
            • GETSET
            • HDEL
            • HEXISTS
            • HGET
            • HGETALL
            • HINCRBY
            • HKEYS
            • HLEN
            • HMGET
            • HMSET
            • HSET
            • HSTRLEN
            • HVALS
            • INCR
            • INCRBY
            • KEYS
            • MONITOR
            • PEXPIRE
            • PEXPIREAT
            • PTTL
            • ROLE
            • SADD
            • SCARD
            • RENAME
            • SET
            • SETEX
            • PSETEX
            • SETRANGE
            • SISMEMBER
            • SMEMBERS
            • SREM
            • STRLEN
            • ZRANGE
            • TSADD
            • TSCARD
            • TSGET
            • TSLASTN
            • TSRANGEBYTIME
            • TSREM
            • TSREVRANGEBYTIME
            • TTL
            • ZADD
            • ZCARD
            • ZRANGEBYSCORE
            • ZREM
            • ZREVRANGE
            • ZSCORE
            • PUBSUB
            • PUBLISH
            • SUBSCRIBE
            • UNSUBSCRIBE
            • PSUBSCRIBE
            • PUNSUBSCRIBE
        • Legal
          • Third-party software
    • Contribute
      • Core database
        • Contribution checklist
        • Build the source
        • Configure a CLion project
        • Build and test
        • Coding style
      • Documentation
        • Docs checklist
        • Docs layout
        • Build the docs
          • Editor setup
        • Edit the docs
          • Docs page structure
          • Widgets and shortcodes
          • Syntax diagrams
          • Page with elements
        • Style guide
    • Download
    • Join our community
      • Slack
      • Yugabyte University
      • GitHub
      • Yugabyte Friday Tech Talks
      • Forum
    • Contact Support
    1. YugabyteDB
    2. Troubleshoot
    3. Cluster-level issues
    Cluster-level issues

    Cluster-level issues

    Diagnostics and solutions for typical YugabyteDB cluster issues.
    • Contribute List Contribute
      Report a doc issue Suggest new content Edit this page Contributor guide
    YCQL API connection problems
    Troubleshoot issues related to connecting to the Cassandra-compatible YCQL API service.
    Recover YB-TServer, YB-Master, and node
    Recover failed nodes to get the cluster back on optimal settings.
    Replace a failed YB-TServer
    Replace a failed YB-TServer in a YugabyteDB cluster.
    Replace a failed YB-Master
    Replace a failed YB-Master in a YugabyteDB cluster.
    Replace failed peers
    Perform manual remote bootstrap of failed peers.
    Recover YB-TServer from crash loop
    Find faulty tablets and their data on disk, and then remove it.
    Troubleshoot performance issues
    Investigate and troubleshoot performance of your YugabyteDB clusters.
    YugabyteDB
    © 2024 Yugabyte, Inc. All Rights ReservedPrivacy Policy | Terms of Service