Join us on
Star us on
Get Started
Slack
GitHub
Get Started
v2.5 (latest) v2.2 (stable) v2.1 (earlier version) v2.0 (earlier version) v1.3 (earlier version)
  • YUGABYTEDB CORE
    • Quick start
      • 1. Install YugabyteDB
      • 2. Create a local cluster
      • 3. Explore distributed SQL
      • 4. Build an application
        • Java
        • NodeJS
        • Go
        • Python
        • Ruby
        • C#
        • PHP
        • C++
        • C
        • Scala
    • Explore features
      • YSQL vs PostgreSQL
        • Schemas and Tables
        • Data Types
      • Fault tolerance
      • Horizontal Scalability
        • Scaling Transactions
        • Sharding Data
      • Transactions
        • Distributed Transactions
        • Isolation Levels
        • Explicit Locking
      • JSON Support
      • Multi-Region Deployments
        • Sync replication (3+ regions)
        • Async Replication (2+ regions)
        • Row-Level Geo-Partitioning
      • Follower reads
      • Colocated tables
      • Change data capture (CDC)
      • Observability
        • Prometheus Integration
    • Develop
      • Learn app development
        • 1. SQL vs NoSQL
        • 2. Data modeling
        • 3. Data types
        • 4. ACID transactions
        • 5. Aggregations
        • 6. Batch operations
        • 7. Date and time
        • 8. Strings and text
        • 9. TTL for data expiration
      • Ecosystem integrations
        • Apache Kafka
        • Apache Spark
        • JanusGraph
        • KairosDB
        • Presto
        • Metabase
      • Build GraphQL apps
        • Hasura
        • Prisma
      • Real-world examples
        • E-Commerce app
        • IoT fleet management
        • Retail Analytics
      • Explore sample apps
      • Best practices
    • Migrate
      • Migration process overview
      • Migrate from PostgreSQL
        • Convert a PostgreSQL schema
        • Migrate a PostgreSQL application
        • Export PostgreSQL data
        • Prepare a cluster
        • Import PostgreSQL data
        • Verify Migration
    • 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
      • Docker
      • Public clouds
        • Amazon Web Services
        • Google Cloud Platform
        • Microsoft Azure
      • Multi-DC deployments
        • Three+ data center (3DC)
        • Two data center (2DC)
        • Read replica clusters
      • Change data capture (CDC)
        • CDC to Kafka
    • Benchmark
      • TPC-C
      • sysbench
      • YCSB
      • Key-value workload
      • Large datasets
      • Scalability
        • Scaling queries
      • Resilience
        • Jepsen testing
    • Secure
      • Security checklist
      • Enable Authentication
        • Enable User Authentication
        • Configure ysql_hba_conf_csv
      • 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 (RLS)
        • Column-Level Security
      • Encryption in transit
        • Create client certificates
        • Create server certificates
        • Enable server-to-server encryption
        • Enable client-to-server encryption
        • Connect to clusters
      • Encryption at rest
      • Column-Level Encryption
      • Audit Logging
        • Configure Audit Logging
        • Session-Level Audit Logging
        • Object-Level Audit Logging
    • Manage
      • Back up and restore
        • Back up data
        • Restore data
        • Snapshot and restore data
      • Migrate data
        • Bulk import
        • Bulk export
      • Change cluster configuration
      • Diagnostics reporting
      • Upgrade a deployment
      • Grow cluster
    • Troubleshoot
      • Troubleshooting
      • Common error messages
      • Cluster level issues
        • YCQL connection issues
        • YEDIS connection Issues
        • Recover tserver/master
        • Replace a failed YB-TServer
        • Replace a failed YB-Master
      • Node level issues
        • Check servers
        • Inspect logs
        • System statistics
        • Disk failure
    • Contribute
      • Core database
        • Contribution checklist
        • Build the source
        • Configure a CLion project
        • Run the tests
  • YUGABYTE PLATFORM
    • Yugabyte Platform
      • Overview
        • Install
        • Configure
      • Install Yugabyte Platform
        • Prerequisites
        • Prepare the environment
        • Install software
        • Prepare nodes (on-prem)
        • Uninstall software
      • Configure Yugabyte Platform
        • Create admin user
        • Configure the cloud provider
        • Configure the backup target
        • Configure alerts and health checking
        • Create and edit instance tags
      • Create deployments
        • Multi-zone universe
        • Multi-region universe
        • Read replica cluster
      • Manage deployments
        • Start and stop processes
        • Add a node
        • Remove a node
        • Edit a universe
        • Edit configuration flags
        • Upgrade the YugabyteDB software
        • Delete a universe
        • Migrate to Helm 3
      • Back up and restore universes
        • Configure backup storage
        • Back up universe data
        • Restore universe data
        • Schedule data backups
      • Security
        • Security checklist
        • Customize ports
        • Authorization platform
        • Create a KMS configuration
        • Enable encryption at rest
        • Enable encryption in transit (TLS)
        • Network security
      • Alerts and monitoring
        • Live Queries dashboard
      • Troubleshoot
        • Install and upgrade issues
        • Universe issues
      • Administer Yugabyte Platform
        • Back up and restore Yugabyte Platform
  • YUGABYTE CLOUD
    • Yugabyte Cloud
      • Free tier
      • Create clusters
      • Monitor clusters
      • Create databases
      • Manage database access
      • Connect to clusters
  • REFERENCE
    • Reference
    • Architecture
      • Design goals
      • Key concepts
        • Universe
        • YB-TServer Service
        • YB-Master Service
      • Core functions
        • Universe creation
        • Table creation
        • Write IO path
        • Read IO path
        • High availability
      • Layered architecture
      • Query layer
        • Overview
      • DocDB transactions layer
        • Transactions overview
        • Transaction isolation levels
        • Explicit locking
        • Single-row transactions
        • Distributed transactions
        • Transactional IO path
      • DocDB sharding layer
        • Hash & range sharding
        • Tablet splitting
        • Colocated tables
      • DocDB replication layer
        • Replication
        • xCluster replication
        • Read replicas
        • Change data capture (CDC)
      • DocDB storage layer
        • Persistence
        • Performance
    • APIs
      • YSQL
        • The SQL language
          • SQL statements
            • ABORT
            • ALTER DATABASE
            • ALTER DEFAULT PRIVILEGES
            • ALTER DOMAIN
            • ALTER GROUP
            • ALTER POLICY
            • ALTER ROLE
            • ALTER SEQUENCE
            • ALTER TABLE
            • ALTER USER
            • BEGIN
            • CALL
            • COMMENT
            • COMMIT
            • COPY
            • CREATE AGGREGATE
            • CREATE CAST
            • CREATE DATABASE
            • CREATE DOMAIN
            • CREATE EXTENSION
            • CREATE FUNCTION
            • CREATE GROUP
            • CREATE INDEX
            • CREATE OPERATOR
            • CREATE OPERATOR CLASS
            • CREATE POLICY
            • CREATE PROCEDURE
            • CREATE ROLE
            • CREATE RULE
            • CREATE SCHEMA
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLE AS
            • CREATE TRIGGER
            • CREATE TYPE
            • CREATE USER
            • CREATE VIEW
            • DEALLOCATE
            • DELETE
            • DO
            • DROP AGGREGATE
            • DROP CAST
            • DROP DATABASE
            • DROP DOMAIN
            • DROP EXTENSION
            • DROP FUNCTION
            • DROP GROUP
            • DROP OPERATOR
            • DROP OPERATOR CLASS
            • DROP OWNED
            • DROP POLICY
            • DROP PROCEDURE
            • DROP ROLE
            • DROP RULE
            • DROP SEQUENCE
            • DROP TABLE
            • DROP TRIGGER
            • DROP TYPE
            • DROP USER
            • END
            • EXECUTE
            • EXPLAIN
            • GRANT
            • INSERT
            • LOCK
            • PREPARE
            • REASSIGN OWNED
            • RESET
            • REVOKE
            • ROLLBACK
            • SELECT
            • SET
            • SET CONSTRAINTS
            • SET ROLE
            • SET SESSION AUTHORIZATION
            • SET TRANSACTION
            • SHOW
            • SHOW TRANSACTION
            • TRUNCATE
            • UPDATE
            • VALUES
          • 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
        • 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
          • 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
          • Serial
          • UUID
        • Functions and operators
          • 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
          • currval()
          • lastval()
          • nextval()
          • 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
        • Extensions
        • Keywords
        • Reserved names
      • YCQL
        • 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
        • Simple expressions
        • Subscripted expressions
        • Function call
        • Operators
        • BLOB
        • BOOLEAN
        • Collection
        • FROZEN
        • INET
        • Integer and counter
        • Non-integer
        • TEXT
        • DATE, TIME, and TIMESTAMP
        • UUID and TIMEUUID
        • JSONB
        • Date and time
        • BATCH
    • CLIs
      • yb-ctl
      • yb-docker-ctl
      • ysqlsh
      • ycqlsh
      • yb-admin
      • yb-ts-cli
      • ysql_dump
      • ysql_dumpall
    • Configuration
      • yb-tserver
      • yb-master
      • yugabyted
      • Default ports
    • Drivers
      • Client drivers for YSQL API
      • YugabyteDB JDBC Driver
      • Client drivers for YCQL
      • Spring Data YugabyteDB
    • Connectors
      • Kafka Connect YugabyteDB
    • Third party tools
      • DBeaver
      • DbSchema
      • pgAdmin
      • SQL Workbench/J
      • TablePlus
      • Visual Studio Code
    • Sample datasets
      • Chinook
      • Northwind
      • PgExercises
      • SportsDB
  • RELEASES
    • Releases
    • Releases overview
    • Release versioning
    • What's new
      • v2.5 (latest)
      • v2.4.0 (stable)
    • Earlier releases
      • v2.3.3
      • v2.3.2
      • v2.3.1
      • v2.3.0
      • v2.1.8
      • v2.1.6
      • v2.2.0
      • v2.1.5
      • v2.1.4
      • v2.1.3
      • v2.1.2
      • v2.1.1
      • v2.1.0
      • v2.0.11
      • v2.0.10
      • v2.0.9
      • v2.0.8
      • v2.0.7
      • v2.0.6
      • v2.0.5
      • v2.0.3
      • v2.0.1
      • v2.0.0
      • v1.3.1
      • v1.3.0
      • v1.2.12
      • v1.2.11
      • v1.2.10
      • v1.2.9
      • v1.2.8
      • v1.2.6
      • v1.2.5
      • v1.2.4
  • FAQ
    • Comparisons
      • Amazon Aurora
      • Google Cloud Spanner
      • CockroachDB
      • TiDB
      • Vitess
      • MongoDB
      • FoundationDB
      • Amazon DynamoDB
      • Azure Cosmos DB
      • Apache Cassandra
      • PostgreSQL
      • Redis in-memory store
      • Apache HBase
    • FAQs
      • General FAQ
      • Operations FAQ
      • API compatibility FAQ
      • Yugabyte Platform FAQ
  • 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
> What's new >

What's new in the v2.5 latest release series

  • Notable features and changes (cumulative for the v2.5 latest release series)
  • Release notes
    • Yugabyte Release Notes v2.5.1
    • New features
    • Improvements
    • v2.5.0 - November 12, 2020
    • New features
    • Improvements

Included here are the release notes for all releases in the v2.5 latest release series.

New release versioning

Starting with v2.2, Yugabyte release versions follow a new release versioning convention. The latest release series, denoted by MAJOR.ODD, incrementally introduces new features and changes and is intended for development and testing only. Revision releases, denoted by MAJOR.ODD.REVISION versioning, can include new features and changes that might break backwards compatibility. For more information, see Supported and planned releases.

Upgrading from 1.3

Prior to v2.0, YSQL was still in beta. Upon release of v2.0, a backward-incompatible file format change was made for YSQL. For existing clusters running pre-2.0 release with YSQL enabled, you cannot upgrade to v2.0 or later. Instead, export your data from existing clusters and then import the data into a new cluster (v2.0 or later).

Notable features and changes (cumulative for the v2.5 latest release series)

Note: Content will be added as new notable features and changes are available in the patch releases of the v2.5 latest release series. For the latest v2.5 release notes, see Release notes below.

Release notes

Yugabyte Release Notes v2.5.1

Jan 14, 2021

Build: 2.5.1.0-b153

Downloads

     

Docker

docker pull yugabytedb/yugabyte:2.5.1.0-b153

New features

Yugabyte Platform

  • [#5723] Support for custom CA signed certificates for encryption in-flight
  • [#5556] Add alerts capability for backup tasks

Core Database

  • [#6010] YCQL: Cache authentication information
  • [#4874] YSQL: Backup for colocated databases
  • [#4899] YSQL: Index backfill unique indexes
  • [#6237] YSQL: add CREATE INDEX NONCONCURRENTLY grammar
  • [#5982] YSQL: Add support for CREATE TABLE/INDEX ... WITH (table_oid = x)
  • [#4770] YSQL: Completing feature RANGE Partitioning
  • Improved Clock Skew Handling
    • [#6370] Bump default max_clock_skew to 500ms
    • [#3335] Crash when too big clock skew is detected

Improvements

Yugabyte Platform

  • [#5888] Better error for handling when user creates concurrent backup tasks
  • [#6016] Pre-flight checks for create universe / edit universe / add node operations
  • [#4183] Add error message for invalid ssh keys for onprem providers
  • [#5848] Onprem provider creation failure leaves incomplete state behind
  • [#5652] Improve delete universe handling for failed universes
  • [#6254] Allow user to input multiple GFlag entries at the same time
  • [#4843] New Health check for Replication status in 2dc setup
  • [#6268] Utility script to edit universe json from command line
  • [#4795] Embed http proxy within yb platform to avoid need for deploying nginx
  • [#5799] Delete platform code related to dev/debug package installs and EPEL repo
  • [#6228] Enabling Encryption-at-Rest without KMS config causes Create Universe to fail silently
  • [#6289] Fixed degraded performance on Live Queries tab caused by huge number of DOM nodes in rows
  • [#6383] Disabled unused API endpoint: run_query
  • [#6384] Disabled unused API endpoint: run_in_shell
  • [#6389] Input validation for kubernetes config path
  • [#6386] Added input validation for access_keys API endpoint
  • [#6382] Added UI validation for backup target paths
  • #6175: Use sudo when removing prometheus snapshots during platform backup
  • [#6602] Fix TLS directory while provisioning YB nodes.
  • [#6683] Use a timeout mechanism in cluster_health.py that is more compatible with docker's lack of zombie reaping
  • [#6633] Platform: rename Pivotal to VMware Tanzu, add Red Hat OpenShift cloud provider

Core Database

  • [#6580] ycql: Log the status when statement fails for system query cache
  • [#6608, #6609] YCQL: Consolidate authentication error handling and messages
  • [YCQL][#6374] Upgrade spark-cassandra-connector version to 2.4-yb-3
  • #5678: [YCQL] Optimize updating non-indexed columns within indexed tables.
  • [#3329][YSQL] Optimized updates to reflect changes on necessary indexes only
  • [#5805] [YSQL] Use slots more widely in tuple mapping code and make naming more consistent
  • [YSQL] Clean up libpq connection code (#6481)
  • [#6417] [YSQL] Backport 'Skip allocating hash table in EXPLAIN-only mode'
  • [#6131] [YSQL] Dowgrade permission check for data directory to warning
  • [YSQL] Bubble up backfill error message (#6292)
  • [#5805] [YSQL] Don't require return slots for nodes without projection
  • [#5805] [YSQL] Split ExecStoreTuple into ExecStoreHeapTuple and ExecStoreBufferHeapTuple
  • [#5805] [YSQL] Error position support for defaults and check constraints
    • Improvements to 2DC x-cluster async replication
    • [#6169] Correctly replay write batches with external intents on bootstrap
    • [#6169] New format for external intents
    • [#6283] Fix Very Large Metric Lag for 2DC Txns
    • [#3522] Fix Threading Issues with CDC Consumer Writes
    • [#6068] Replicate Intents and Apply Messages for 2DC Txns
    • [#6169] Fix apply order of updated external intents records
    • [#4516] 2DC: Initial support for colocated databases
  • Improvements to Tooling
    • [#6589] docdb: Add option to clear placement info in yb-admin.
    • [#6223] master UI make hash_split more readable
    • [#6161] Change modify_table_placement_info to wipe read_replicas and affinitized_leaders
    • [#5420] ybase: Enhance YMaster admin page to display under-replicated tablets
    • [#1325] ybase: API for displaying YB version information
  • Improvements to Tablet splitting
    • [#4942] docdb: tablet splitting: implemented retries to post-split involved tablets for
    • #5937: Fixed the case when one of the tablet replicas is down during the split.
    • #6101 Add the flag to limit number of tablets per table
    • [#6424] Fix post-split compaction to be async
  • Improvements to core product security
    • [#6568] Add flag to force client certificate verification in SSL
    • [#6266] Replace retry counter with check that data is ready
    • [#6266] Retry SSL_write on SSL_ERROR_WANT_WRITE
    • [#6266] Fix handling SSL_write error
  • [#6394, #6434] docdb: Speedup system.partitions queries
  • [#3979] Add Transaction Cleanup to Catalog Manager Create DDLs
  • [#1258]: Send election request from master during table creation
  • [#6114] docdb: Add metrics for master YCQL system table
  • [#1259] Speedup DROP TABLE
  • [#5752] Avoid starving threadpool with run election tasks from FailureDetector
  • [#5755] Faster cleanup of transactions that failed to commit due to a concurrent abort
  • (#5996) Messenger::ScheduleOnReactor should break loop finding reactor
  • [#6305] Adaptive Heartbeat Reporting
  • [#6445] docdb: Master should rebuild YCQL system.partitions on a background thread
  • [#6696] Small master perf tweaks

Bug Fixes

Yugabyte Platform

  • [#6300] Install of s3cmd fails for default GCP OS image when airgapped
  • [#6085] Fixed the issue where master is brought up in read replica cluster
  • [#6416] Deletion with flag --node_ip fails for onprem universes.
  • [#6614] Fixed NPE with full move
  • [#6252] Fixed NPE on the metrics page
  • [#5942] Fixed an issue where release instance is not an option for a node should the install fail because of ssh access
  • [#6275] Fixed missing stats on Nodes page when universe has read replicas
  • [#6257] Updating user profile when smtp username or password are empty

Core Database

  • [#6144] YCQL: Fix handling of tablet-lookup errors in Executor::FlushAsync

  • [#6570] YSQL: Use IsYBRelation instead of IsYugaByteEnabled

  • [#6492] YSQL Avoid memcpy() with a NULL source pointer and count == 0

  • [YSQL] Fix IsCreateTableDone for index backfill (#6234)

  • [#6318, #6334] Call InitThreading in YSQL webserver process

  • #6317: [YSQL] Fixed SIGSERV in YBPreloadRelCache

  • [#6364] [YSQL] Replace CurrentMemoryContext with GetCurrentMemoryContext for all pg_extensions

  • #6219] [YSQL] PRIMARY KEY index in TEMP TABLE is not checked for uniqueness

  • (#6284) [YSQL] Clear ALTERING when there's no alter

  • [#5805] [YSQL] Fix run-time partition pruning for appends with multiple source rels

  • [#6151] [YSQL] Handle rowmark in case of read with batch of ybctids

  • (#6270) [YSQL] Prevent concurrent backfill index

  • [#6133] [YSQL] Fix procedure with an INOUT parameter in DO block

  • [#6061] [YSQL] ysql_dump should consistently use quotes on column names

  • #6009: [backup][YSQL] Fixed incorrect column-ids in restored YSQL table if original table was altered.

  • #5954 [YSQL] Check transaction status after read finished

  • #6430 [YSQL] Refresh YBCache in case postgres clears its internal cache

  • #6468 [YSQL] Fix read restarts of request with paging state

  • [#6435] docdb: fixed handling of empty bloom filter key in the write path

  • [#6435] Fixed bloom filter index generation for range-partitioned tablets

  • [#6375] Check against TabletPeer returning null tablet pointer in

  • (#5641) Fix for --cert_node_filename for tservers and --enable_ysql

  • [#6318, #6334] Call InitThreading in YSQL webserver process

  • [#4150] Fix incorrect tracking of flushed/synced op id in case of Raft operation abort

  • (#6278) Master SEGV during LB due to null TSDescriptor

  • [#6353] Disable rocksdb flush on all DeleteTablet calls

  • [#6338] Fix crash with redis workloads and snapshot restore

  • [#6334] Attach/detach Squeasel threads to/from libcds using callbacks

  • [#6245] Fixed incorrect restored table schema if the table was altered after the backup.

  • [#6217] Avoid a possible assertion failure in CDSAttacher destructor in Webserver

  • [#6170] Shutdown status resolver before destroying it in ResolveIntents

  • [#6482] Fix timeout handling when getting safe time in a RF1 cluster

  • [#6635] Fix the wrong detection of communication failure when no operations transferred

  • [#6678] backup: Fix restore of colocated table with table_oid already set

    Known Issues

Yugabyte Platform

  • Azure IaaS orchestration
    • No pricing information provided (5624)
    • No support for regions with zero Availability Zones(AZs) (5628)

Core Database

  • Advisory on clock-skew
    • After commit a60a4ae00d217563cac865b3363e2c2bb8aa58ba, by default, any YB node will explicitly crash if it detects a clock skew higher than the max_clock_skew flag (default 500ms). This can be disabled by setting fail_on_out_of_range_clock_skew=false, but this could lead to consistency issues! The recommendation is that you ensure clocks are synchronized across your cluster.

v2.5.0 - November 12, 2020

Build: 2.5.0.0-b2

Downloads

     

Docker

docker pull yugabytedb/yugabyte:2.5.0.0-b2

New features

Yugabyte Platform

  • Azure Cloud integration for Yugabyte Platform (in beta):

    Yugabyte Platform is natively integrated with Azure cloud to simplify deploying, monitoring, and managing YugabyteDB deployments. This feature automates a number of operations including orchestration of instances, secure deployments, online software upgrades, and scheduled backups, as well as monitoring and alerting. (6094, 6020)

  • Yugabyte Platform operations now allow promoting a Yugabyte TServer only node to run Yugabyte Master and TServer process (5831)

Core Database

  • Enhanced multi-region capabilities with geo-partitioning and follower reads

    The YugabyteDB 2.5 release adds row-level geo-partitioning capabilities as well as follower reads to the extensive set of multi-region features that YugabyteDB already had.

  • Enterprise-grade security features:

    Authentication using the highly secure SCRAM-SHA-256 is now supported to limit security risks from brute force attacks and sniffing, including LDAP support for better user management and the ability to audit all database operations.

  • Table-level partitions allow users to split what is logically one large table into smaller sub-tables, using the following types of table partitioning schemes that PostgreSQL supports: range partitioning, list partitioning, and hash partitioning. Read more about table partitioning in YugabyteDB.

  • Event triggers are now supported in addition to regular table-level triggers in YSQL. While regular triggers are attached to a single table and capture only DML events, event triggers are global to a particular database and are capable of capturing DDL events. The event-based trigger framework enables detecting changes made to the data, and automating any subsequent tasks that need to be performed, which are useful in a number of use cases such as implementing a consolidated, central audit table (2379)

  • Simplified cluster administration:

    • Online rebuild of indexes is supported for both the YSQL and YCQL APIs. This means that new indexes can be added to tables with pre-existing data while concurrent updates are happening on the cluster. The online index rebuild process creates the newly added index in the background, and transactionally enables the index once the rebuild of all the data is completed. This feature allows flexibility of adding indexes as the application needs evolve to keep queries efficient.
    • Cluster execution statistics and running queries can be analyzed in detail, allowing administrators to gain insights into how the database is performing. The pg_stat_statements extension, which enables tracking execution statistics of all SQL statements executed by the cluster, is supported and enabled by default. Support for pg_stat_activity has also been added, which shows information related to the activity performed by each connection. Yet another useful feature in this category is the ability to view all the live queries being executed by the cluster at any point in time.
    • Detailed query plan and execution analysis can now be performed with commands such as EXPLAIN and EXPLAIN ANALYZE. These commands display the execution plan generated by the planner for a given SQL statement. The execution plan shows details for any SQL statement such as how tables will be scanned (plain sequential scan, index scan), what join algorithms will be used to fetch required rows from the different tables, etc.

Improvements

Yugabyte Platform

  • Enhancements to on-prem deployment workflows
    • Do not fail universe creation if cronjobs can't be created for on-prem (5939)
    • Remove pre-provision script requirement for air-gapped installations (5929)
    • "Sudo passwordless" in on-prem cloud provider configuration toggle is renamed
    • Allow yugabyte user to belong to other user groups in Linux (5943)
    • Added a new "Advanced" section in on-prem cloud provider configuration which includes
      • Use hostnames
      • Desired home directory
      • Node exporter settings
    • Improvements to installation of Prometheus Node Exporter utility workflow (5926)
      • Prometheus Node exporter option is now available in the cloud configuration under advanced settings
      • Supports bringing your own node exporter user
  • Make YEDIS API optional for new Universes and no change in behavior of existing universes (5207)
  • Yugabyte Platform now provides alerts for backup tasks (5556)
  • UI/UX improvements for YB Platform
    • Add visual feedback when backup or restore is initiated from modal (5908)
    • Minor fixes to primary cluster widget text issue (5988)
    • Show pre-provision script in UI for non-passwordless sudo on-prem provider (5550)
    • Update backup target and backup pages (5917)
  • For Yugabyte Universes with Replication Factor(RF) > 3, change the default min_num replicas for even distribution of AZs across all regions (5426)
  • Added functionality to create IPv6 enabled Universe in Kubernetes (5309, 5235)

Core Database

  • Support for SQL/JSON Path Language( jsonb_path_query) (5408)
  • Incorrect index update if used expression result is still unchanged (5898)
  • As part of the Tablet Splitting feature
    • Implemented cleanup of the tablet for which all replicas have been split for (4929)
    • Compaction improvements (5523)
  • Improve performance for sequences by using higher cache value by default. Controlled by a tserver gflag ysql_sequence_cache_minval (6041)
  • Added compatibility mode in the yb_backup script for Yugabyte version < 2.1.4 (5810)
  • Stability improvements: Make exponential backoff on lagging RAFT followers send NOOP instead of reading 1 op from disk (5527)
  • Added use of separate metrics objects for RegularDB and IntentsDB (5640)

Bug Fixes

Yugabyte Platform

  • Fix for Universe disk usage shows up empty on the universe page (5548)
  • Fix on on-prem backup failures due to file owned by the root user (6062)
  • Fix for a bug where user operation to perform a change to nodes count by AZ was doing a full move (5335)
  • Fixes for Yugabyte Platform data backup script for Replicated based installations
  • Fixes to Client Certificate start time to use UTC during download (6118)
  • Fixes for migration if no access keys exist yet (6099)
  • Fix to resolve issues caused by starting a Yugabyte TServer Node when another Yugabyte Master node is down in the Universe (5739)
  • Use the correct disk mount point while calculating disk usage of logs (5983)
  • Fixes to delete backups for TLS Enabled Universes (5980)

Core Database

  • Fix for bug with the duplicate row detection that allows a unique index to get created when the table is not unique on the index column(s) (5811)
  • Improve fault tolerance of DDLs and reduce version mismatch errors in YSQL (3979, 4360)
  • Fixes to incorrect column-ids in the restored table if the original table was altered (5958)
  • Fixes timeout bug in YB Platform when there are Read Replicas. This fix will ignore read replica TServers when running AreLeadersOnPreferredOnly (6081)
  • Fixes to restore of YSQL Backups after dropping and recreating a database (5651)
  • Fixes to 2DC(x-cluster replication) by adding TLS support for cleaning up cdc_state table (5905)

Known Issues

Yugabyte Platform

  • Azure IaaS orchestration -
    • No pricing information provided (5624)
    • No support for regions with zero Availability Zones(AZs) (5628)
Ask our community
  • Slack
  • Github
  • Forum
  • StackOverflow
Yugabyte
Contact Us
Copyright © 2017-2020 Yugabyte, Inc. All rights reserved.