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 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 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

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'] this 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'] ey.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'] this 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'] ey.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'] this 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'] ey.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'] this 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'] ey.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']

27 of 121. CloudBeaver Enterprise Edition also supports AWS IAM and SAML authentication methods. Amazon Web Services authentication allows users to authorize to CloudBeaver EE with IAM credentials. Once 3. Page 93 of 121. You can subscribe to CloudBeaver EE in the AWS Marketplace here: https://aws.amazon.com/marketplace/pp . /B08QTY2JTF There is a one month trial period. After launching EC2 instance databases (most of them are optional): STS (required): used for user authentication RDS: list RDS/Aurora instances for cloud databases explorer (describeDBInstances) Redshift: list Redshift clusters for

Anonymous access Local access Reverse proxy access CloudBeaver EE CloudBeaver user guide 23.0 20/111 Amazon Web Services authentication allows users to authorize to CloudBeaver EE with IAM credentials. Once user guide 23.0 82/111 You can subscribe to CloudBeaver EE in the AWS Marketplace here: https://aws.amazon.com/marketplace/pp/B08QTY2JTF. There is a one month trial period. After launching EC2 instance databases (most of them are optional): STS (required): used for user authentication RDS: list RDS/Aurora instances for cloud databases explorer (describeDBInstances) Redshift: list Redshift clusters for

。""* 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 业务扩张迅速

29 of 140. CloudBeaver Enterprise Edition also supports AWS IAM and SAML authentication methods. Amazon Web Services authentication allows users to authorize to CloudBeaver EE with IAM credentials. Once 1. Page 104 of 140. You can subscribe to CloudBeaver EE in the AWS Marketplace here: https://aws.amazon.com/marketplace/pp . /B08QTY2JTF There is a one month trial period. After launching EC2 instance databases (most of them are optional): STS (required): used for user authentication RDS: list RDS/Aurora instances for cloud databases explorer (describeDBInstances) Redshift: list Redshift clusters for

Reverse proxy access CloudBeaver EE AWS IAM access CloudBeaver User Guide 23.2. Page 30 of 182. Amazon Web Services authentication allows users to authorize to CloudBeaver EE with IAM credentials. Once 2. Page 121 of 182. You can subscribe to CloudBeaver EE in the AWS Marketplace here: https://aws.amazon.com/marketplace/pp . /B08QTY2JTF There is a one month trial period. After launching EC2 instance Server configuration IAM permissions CloudBeaver User Guide 23.2. Page 129 of 182. RDS: list RDS/Aurora instances for cloud databases explorer (describeDBInstances) Redshift: list Redshift clusters for