On June 16, TiDB officially released RC3 version. This release does a lot of work on MySQL compatibility, SQL optimizer, system stability, and performance. In terms of performance, load balancing scheduling policies and processes are optimized. Functions further improve the permission management function, users can control data access rights according to the MySQL permission management mode. In addition, DDL speed has been significantly improved.

In order to simplify the operation and maintenance work, tiDB-Ansible project is open source, which can deploy/upgrade/start/stop TiDB cluster with one click.

TiDB:

  • SQL query optimizer

    • Supports incremental update of statistics
    • Merge Sort Join operator is supported
    • Index Lookup Join is supported
    • Optimizer hint syntax is supported
    • Optimize memory consumption for Scan, Join, and Aggregation operators
    • Optimize the CBO framework
    • Refactoring Expression

  • Supports more complete rights management

  • Accelerated the DDL
  • Support HTTP API to get data distribution information for tables
  • Query concurrency is controlled by system variables
  • Add a large number of MySQL built-in functions
  • Large transactions are automatically split into small transaction commits through system variables

PD

  • Support gRPC
  • Disaster Recovery Toolkit
  • Automatically GC out expired data
  • More efficient data Balance
  • Supports scheduling of hotspot regions to balance load and improve data import speed
  • Performance optimization
    • Accelerate Client TSO acquisition
    • Improves the processing efficiency of the Region Heartbeat

  • Improve the pD-CTL function

    • Dynamically update Replica configuration
    • Access to TSO
    • Obtain Region information by ID

TiKV

  • Support gRPC
  • Supports SST Format Snapshot to improve cluster load balancing speed
  • Profile memory is supported
  • Support SSE, speed up CRC32 calculation
  • Speed up Transfer Leader to achieve faster load balancing
  • Batch Apply reduces CPU usage and improves write performance
  • Supports parallel Prewrite to improve transaction writing speed
  • Optimize Coprocessor thread pool scheduling to reduce the impact of large queries on point-checking
  • The new Loader supports concurrent table-level import and supports concurrent import of large tables into multiple logical blocks to improve data import speed

As a world-class open source distributed relational database, TiDB is inspired by Google Spanner/F1 and has core features such as “distributed strong consistent transactions, online elastic horizontal scaling, high availability for fault recovery, and multi-activity across data centers”. TiDB was launched on GitHub in May 2015 with an Alpha release in December 2015, followed by a Beta in June 2016, RC1 in December, and RC2 in March 2017.

TiDB RC3 is now online thanks to the community and the PingCAP technical team for their continued participation and contributions.

Source code address: github.com/pingcap/tid…