YSQL Changes
- [YSQL] Buffer writes to postgres system tables, reorder table creation on yb-master. #4013
- [YSQL] Single row update overwrites unmodified columns with default values to null #4127
- [YSQL] Read restarts are not done transparently in JDBC "simple" query mode. #4094
- [YSQL] Remove redundant call of YBOnPostgresBackendShutdown. #3236
- [YSQL] Allowing a deletion of a table when the DocDB returns a 'NotFound' error. #3305
- [YSQL] Use higher priority for transactions with explicit locking statements. #4136
- [YSQL] Made pg_notify a NOOP emitting warning. #3875
YCQL
- [YCQL] Backing up table should back up its indexes. #3836
System improvements
- Fix memory leak on transaction abort. #3631
- colocation: enforce colocated reloption behavior. * Implement backfilling for YCQL Unique Index. #3891
- yb-admin hangs for full timeout of 60s when no leader master is present/specified. #209
- Use QLExprResult during expression evaluation to avoid unneccesary memory allocations and copies. #3926
- Fix LB interaction with Preferred Regions. #3461
- [yb-admin] list_all_masters does not list dead hosts. #4070
- Delete a transaction aware snapshot. #1032
- Prevent read-write data race on field in DBImpl. #4025
- [docdb] Master heartbeat writes should be batch written to raft. #2236
- TServer-side tablet splitting. #1459
- Better descripton for BackfillTableJob. #4143
- Bump max threads in the RPC thread pool to 1024. #4058
- Avoid extra fsyncs of tombstoned tablets during startup. #4006
- Fixed tablet log prefix. #4188
- Remove peers when its tablet is in the FAILED state so that they can be remote bootstrapped. #3539
- Index deletion upon backfill failure. #3978
- More resilient multi node yugabyted. #2057
- Added split-tablet RPC support into yb-admin and yb-master. #1461
- Fix master bootstrap after snapshot operations. #1032
- TabletIterator Hangs during Shutdown. #4081
- Enable Move From Leader LB. #3461
- [ybase] Set default value of copy_table_batch_size to 10K. #3743
- Retain delete markers on index tables only during backfill. #4211
Platform
- Ability to attach multiple security groups to yugabyte nodes. #1598
- Remove psql from bin and fix get_clients.sh. #3928
- Set replication_factor gflag on master when creating universe. #4099
- Support for GCS backups. #3405
- Show node name in alert emails. #4102
- [YW] Add Scheduled backups to universe level Backups tab and remove from top-right dropdown. #3591
- Disable standalone backups for YCQL indexes. #3848
- [YW] Fix map markers not showing up in expanded view of node placement map in Universe overview. #4200
Note
Prior to 2.0, YSQL was still in beta. As a result, 2.0 release includes a backward incompatible file format change for YSQL. This means that if you have an existing cluster running releases older than 2.0 with YSQL enabled, then you will not be able to upgrade to version 2.0+. Export from old cluster and import into a new 2.0+ cluster is needed for using existing data.