TiDB and Amazon Aurora Compare / Contrast / Combine Ed Huang, CTO @ PingCAP h@pingcap.com TiDB Community Slack Channel https://pingcap.com/tidbslack/ Compare Why Aurora? ● Amazon Aurora is popular ● ● Amazon Aurora is designed for OLTP workload ● Amazon Aurora is still using the MySQL code base ● It would be cool to do some lightweight OLAP queries directly on the transactional database. ○ No need involve data warehouse! ○ Example: a dashboard for each tenant in SaaS applications Why Aurora is fast ● Fewer I/O, fewer write amplification ● Smaller network packets ● Eventual consistency

1 Aurora InnovationContinuous Regression Testing for Safer and Faster Refactoring Pejman Ghorbanzade Aurora Innovation3 Aurora Innovation Engineers spend 17 hours per week maintaining software. *Stripe *Stripe 2019 Developer Coef�cient Report4 Aurora Innovation Maintaining Software Reading Refactoring Upgrading Migrating Debugging Adding tests Writing documentation Resolving technical debt “The “The only constant in life is change.” - Heraclitus5 Aurora Innovation Types of Change Fixing a defect Enabling code reuse Adjusting to new expectations Improving a function implementation Upgrading

Physique des Particules, France October 4th, 2023 LUTH CppCon - Vincent Reverdy - October 4th, 2023 - Aurora, Colorado, USA 2 CC0 1.0 Universal - Public Domain DedicationIntroduction The lambda trick Comparison Architecture 7 Substitution 8 Construction 9 Conclusion CppCon - Vincent Reverdy - October 4th, 2023 - Aurora, Colorado, USA 3 CC0 1.0 Universal - Public Domain DedicationIntroduction The lambda trick Comparison Architecture 7 Substitution 8 Construction 9 Conclusion CppCon - Vincent Reverdy - October 4th, 2023 - Aurora, Colorado, USA 4 CC0 1.0 Universal - Public Domain DedicationIntroduction The lambda trick Comparison

Particules, France September 20th, 2024 LUTH CppCon - Vincent Reverdy - September 20th, 2024 - Aurora, Colorado, USA 2 CC0 1.0 Universal - Public Domain DedicationIntroduction Firsts steps Context Theoretical 5 Outline of an implementation 6 Conclusion CppCon - Vincent Reverdy - September 20th, 2024 - Aurora, Colorado, USA 3 CC0 1.0 Universal - Public Domain DedicationIntroduction Firsts steps Context Theoretical 5 Outline of an implementation 6 Conclusion CppCon - Vincent Reverdy - September 20th, 2024 - Aurora, Colorado, USA 4 CC0 1.0 Universal - Public Domain DedicationIntroduction Firsts steps Context Theoretical

library: Quantity distance; // No units library: 1 double distance_m; 2 3 4 5 3.3Aurora InnovationAurora InnovationFlashback: CppCon 2021 5A taste of Au 6Example: time to goal 7Example: more 10Au: learning more https://aurora-opensource.github.io/au/main/tutorial/ 10.1Au: learning more https://aurora-opensource.github.io/au/main/tutorial/ https://aurora-opensource.github.io/au/main/troubleshooting/ https://aurora-opensource.github.io/au/main/alternatives/ 17Full comparison https://aurora-opensource.github.io/au/main/alternatives/ 1. Can you get it? 17.1Full comparison https://aurora-opensource

。""* 26 北京银行- 打造面向未来的商业银行业分布式核心系统 ，， 28 中国银行 -基于 TiZabbix 构建金融业新一代运维监控平台 “"""* 30 PayPay - 从AWS Aurora 迁移到TiDB 的最佳实践 32 5.2 能源 国网河北电力 - 利用 TiDB 打造电力企业全场景数据服务能 34 Ping 400 ~ 500 GB 的导入违度，适合上线前迁移现有的大型 数据库到全新的 TiDB 集群 。 支持MySQLdump fles/csv 格式的数据导入 *。 ”支持从 S3 中直接导入Aurora Parquet 格式全量快照 数据导出-Dumpling Dumpling 是由 Go 语言编写的用于对数据库进行数据导出的工具，目前支持 MySQL 协议的数据库，并 且针对TiDB 的特性进行了优化，Dumpling 本身具备良好的横向扩展能力且易用性极高。 PingCAP.COM 32 第五章 - 场景案例 PayPay 从AWS Aurora 迁移到TiDB 的最佳实践 PayPay 是日本排名领先的移动支付公司, 由软银集团.日本雅虎和印度移动支付公司 Paytm 共同投资成 立, 支持线上和线下多种支付方式PayPay 业务扩张迅速

list the hostnames that are considered secure. See also Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'] [$i]['ssl'], $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i] ['ssl_cert'] option. See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca'] pem'; See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca']

explicitly list the hostnames that are considered secure. See also Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'] [$i]['ssl'], $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i] ['ssl_cert'] option. See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca'] pem'; See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca']

explicitly list the hostnames that are considered secure. See also Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'] [$i]['ssl'], $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i] ['ssl_cert'] option. See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca'] pem'; See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca']

explicitly list the hostnames that are considered secure. See also Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'] [$i]['ssl'], $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i] ['ssl_cert'] option. See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl_key'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca'] pem'; See also Using SSL for connection to database server, Google Cloud SQL with SSL, Amazon RDS Aurora with SSL, $cfg['Servers'][$i]['ssl'], $cfg['Servers'][$i]['ssl_cert'], $cfg['Servers'][$i]['ssl_ca']