# TiDB Academy

## Distributed Database with TiDB for MySQL DBAs

+ Introduction:
  - [Course Overview](mysql_dbas/introduction/course-overview.md)
  - [Format and Housekeeping](mysql_dbas/introduction/format-and-housekeeping.md)
  - [Setting up Google Cloud Platform](mysql_dbas/introduction/google-cloud-platform.md)
  - [Introduction to Distributed Databases](mysql_dbas/introduction/distributed-databases.md)

+ TiDB Overview: 
  - [TiDB Platform](mysql_dbas/tidb-overview/tidb-platform.md)
  - [Optional Components: TiSpark](mysql_dbas/tidb-overview/optional-components-tispark.md)
  - [The KOST Stack](mysql_dbas/tidb-overview/the-kost-stack.md) 
  - [Lab: Deploying TiDB Platform on GKE](mysql_dbas/tidb-overview/lab.md)
  - [Recap: Deploying TiDB Platform on GKE](mysql_dbas/tidb-overview/lab-recap.md)

+ MySQL Compatibility:
  - [Overview](mysql_dbas/mysql-compatibility/overview.md)
  - [Behavior Differences](mysql_dbas/mysql-compatibility/behavior-differences.md)
  - [Default Differences](mysql_dbas/mysql-compatibility/default-differences.md)
  - [Lab: Loading Sample Data](mysql_dbas/mysql-compatibility/lab.md)
  - [Recap: Loading Sample Data](mysql_dbas/mysql-compatibility/lab-recap.md)

+ Query Optimization:
  - [Overview](mysql_dbas/query-optimization/overview.md)
  - [EXPLAIN](mysql_dbas/query-optimization/explain.md)
  - [Lab: Optimize Queries](mysql_dbas/query-optimization/lab.md)
  - [Lab Recap: Optimize Queries](mysql_dbas/query-optimization/lab-recap.md)
  - [The Coprocessor](mysql_dbas/query-optimization/coprocessor.md)

+ HTAP: 
  - [Overview](mysql_dbas/htap/overview.md)
  - [TiDB + Apache Spark](mysql_dbas/htap/spark.md)
  - [Lab: HTAP](mysql_dbas/htap/lab.md)
  - [Lab Recap: HTAP](mysql_dbas/htap/lab-recap.md)

+ Backup and Restore: 
  - [Overview](mysql_dbas/backup/overview.md)
  - [Lab: Restore from Accidental Delete](mysql_dbas/backup/restore-from-accidental-delete-lab.md)
  - [Lab Recap: Restore from Accidental Delete](mysql_dbas/backup/restore-from-accidental-delete-lab-recap.md)
  - [Lab: Backup and Restore](mysql_dbas/backup/backup-and-restore-lab.md)
  - [Lab Recap: Backup and Restore](mysql_dbas/backup/backup-and-restore-lab-recap.md)

+ Schema Changes:
  - [Overview](mysql_dbas/ddl/overview.md)
  - [Google's F1 DDL Algorithm](mysql_dbas/ddl/f1-ddl-algorithm.md)
  - [Lab: ALTER TABLE online](mysql_dbas/ddl/lab.md)
  - [Lab Recap: ALTER TABLE online](mysql_dbas/ddl/lab-recap.md)

+ Scaling the TiDB Platform: 
  - [Overview](mysql_dbas/scaling/overview.md)
  - [Scaling Patterns](mysql_dbas/scaling/patterns.md)
  - [Lab: Scaling TiDB](mysql_dbas/scaling/lab.md)
  - [Lab Recap: Scaling TiDB](mysql_dbas/scaling/lab-recap.md)
  - [Placement Driver](mysql_dbas/scaling/pd.md)

+ Updates, Upgrades and Migrations: 
  - [Overview](mysql_dbas/upgrades/overview.md)
  - [Updates](mysql_dbas/upgrades/updates.md)
  - [Upgrades](mysql_dbas/upgrades/upgrades.md)
  - [Migration from MySQL](mysql_dbas/upgrades/migration.md)

+ Data Migration (DM):
  - [Overview](mysql_dbas/dm/overview.md)
  - [Example Usage](mysql_dbas/dm/example.md)

+ RocksDB: 
  - [Overview](mysql_dbas/rocksdb/overview.md)
  - [Architecture](mysql_dbas/rocksdb/architecture.md)

+ Monitoring and Observability: 
  - [Overview](mysql_dbas/monitoring/overview.md)
  - [Observability](mysql_dbas/monitoring/observability.md)
  - [Lab: Prometheus and Grafana](mysql_dbas/monitoring/lab.md)
  - [Lab Recap: Prometheus and Grafana](mysql_dbas/monitoring/lab-recap.md)

+ Conclusion: 
  - [Course Summary](mysql_dbas/conclusion/course-summary.md)
  - [Shutdown your TiDB Cluster](mysql_dbas/conclusion/shutdown.md)
  - [What's Next?](mysql_dbas/conclusion/whats-next.md)