Working with TiDB Using mysql-connector-python

Lab Description

In this lab, you will learn how to: Connect to, access and modify data in TiDB Cloud Serverless cluster by Python code; Use prepared statements and batch inserts to improve the performance of your application; Use AUTO_RANDOM instead of AUTO_INCREMENT to avoid hotspots; Use online DDL to perform online schema changes; Use and compare pessimistic and optimistic modes for transaction concurrency control.