TiDB Audit Plugin User Guide August 4, 2022 TiDB Audit Plugin User Guide Introduction The TiDB audit plugin records the TiDB server’s activities that are expected to follow auditing regulations of of your organization. For each client session, the plugin records users accessing the server (that is, username and IP address), SQL queries executed, databases and tables accessed, environment variable package, and use the audit plugin. Download the plugin You can download the plugin on TiDB Enterprise Edition Downloads. Deploy the audit plugin After downloading the plugin, you can use either TiDB

Experimental Experimental Experimental Columnar storage (TiFlash) Y Y Y Y RocksDB engine Y Y Y Y Titan plugin Y Y Y Y Invisible indexes Y Y Y N Composite PRIMARY KEY Y Y Y Y Unique indexes Y Y Y Y Clustered 6.2.11 SQL modes TiDB supports most SQL modes: • The compatibility modes, such as ORACLE and POSTGRESQL are parsed but ignored. Compatibility modes are deprecated in MySQL 5.7 and removed in MySQL 8 rocksdb.lockcf.level0-stop-writes-trigger 12.2.3 Titan Overview Titan is a high-performance RocksDB plugin for key-value separation. Titan can reduce write amplification in RocksDB when large values are used

this time period. • The default storage directory for plugins is changed from "" to /data/deploy/plugin. • The DM code is migrated to the folder “dm” in TiCDC code repository. Now DM follows TiDB in version transactions’ statements are not included in TIDB_TRX #28670 – Fix the wrong default value of the plugin_dir configuration #28084 – Fix the issue that the CONVERT_TZ function returns NULL when it is given Experimental Experimental Columnar storage (TiFlash) Y Y Y Y Y RocksDB engine Y Y Y Y Y Titan plugin Y Y Y Y Y Invisible indexes Y Y Y Y N Composite PRIMARY KEY Y Y Y Y Y Unique indexes Y Y Y Y Y

version. 2.2.1.1 System variables Variable name Change type Description default_authentication_plugin �→ Newly added Sets the au- thentication method that the server advertises. The default value is Experimental Experimental Experimental Columnar storage (TiFlash) Y Y Y Y RocksDB engine Y Y Y Y Titan plugin Y Y Y Y Invisible indexes Y Y Y N Composite PRIMARY KEY Y Y Y Y Unique indexes Y Y Y Y Clustered 6.2.11 SQL modes TiDB supports most SQL modes: • The compatibility modes, such as ORACLE and POSTGRESQL are parsed but ignored. Compatibility modes are deprecated in MySQL 5.7 and removed in MySQL 8

Experimental Experimental Columnar storage (TiFlash) Y Y Y Y Y Y Y Y RocksDB engine Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Invisible indexes Y Y Y Y Y Y Y N 1TiDB incorrectly treats latin1 as a subset of 6.2.13 SQL modes TiDB supports most SQL modes: • The compatibility modes, such as Oracle and PostgreSQL are parsed but ignored. Compatibility modes are deprecated in MySQL 5.7 and removed in MySQL 8 <plugin> org.springframework.boot spring-boot-maven-plugin plugin> 181 User

FastScan to accelerate queries in OLAP scenarios E N N N N N N N RocksDB engine Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Titan Level Merge E E E E E E E E Use buckets to improve scan concurrency E E N 4.2.13 SQL modes TiDB supports most SQL modes: • The compatibility modes, such as Oracle and PostgreSQL are parsed but ignored. Compatibility modes are deprecated in MySQL 5.7 and removed in MySQL 8 DataGrip in two ways: • As the DataGrip IDE standalone tool. 269 • As the Database Tools and SQL plugin in JetBrains IDEs, such as IntelliJ, PhpStorm, and PyCharm. This tutorial mainly focuses on the

Fix the issue that TiDB server might consume a significant amount of resources when the enterprise plugin for audit logging is used #49273 @lcwangchao • Fix the issue that the optimizer incorrectly converts accelerate queries in OLAP scenarios Y Y Y E N N N N N N N RocksDB engine Y Y Y Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Y Y Y Titan Level Merge E E E E E E E E E E E Use buckets to improve scan concurrency 4.2.13 SQL modes TiDB supports most SQL modes: • The compatibility modes, such as Oracle and PostgreSQL are parsed but ignored. Compatibility modes are deprecated in MySQL 5.7 and removed in MySQL 8

accelerate queries in OLAP scenarios Y Y E N N N N N N N RocksDB engine Y Y Y Y Y Y Y Y Y Y Titan plugin Y Y Y Y Y Y Y Y Y Y Titan Level Merge E E E E E E E E E E Use buckets to improve scan concurrency 4.2.13 SQL modes TiDB supports most SQL modes: • The compatibility modes, such as Oracle and PostgreSQL are parsed but ignored. Compatibility modes are deprecated in MySQL 5.7 and removed in MySQL 8 DataGrip in two ways: • As the DataGrip IDE standalone tool. 250 • As the Database Tools and SQL plugin in JetBrains IDEs, such as IntelliJ, PhpStorm, and PyCharm. This tutorial mainly focuses on the

g �→ Deleted This vari- able is re- named to tidb_enable_dist_task �→ . default_authentication_plugin �→ Modified Introduces two new value op- tions: authentication_ldap_sasl �→ and authentication_ldap_simple Description authentication_ldap_sasl_tls �→ Newly added Specifies whether connec- tions by the plugin to the LDAP server are pro- tected with Start- TLS in LDAP SASL authen- tica- tion. authenticat Description authentication_ldap_simple_tls �→ Newly added Specifies whether connec- tions by the plugin to the LDAP server are pro- tected with Start- TLS in LDAP simple authen- tica- tion. 61 Variable

proper support for Kubernetes from the Vitess Operator CRDB Maybe attractive to those that use PostgreSQL databases. Migration to MySQL could be lengthy and costly. Does not have the ecosystem and supporting specific cases. These specific cases include if one would want to create such a database as or from a PostgreSQL database. This involves substantial additional costs, or is impossible to set up with TiDB. TiDB Low Medium Medium Low Compatibility Overall High High Medium Medium Low MySQL Yes Yes Yes No Yes PostgreSQL No No No Yes No Kubernetes Yes Yes Yes* Yes No Ecosystem Guarantee * Not recommended. CONCLUSION