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. ○ 400GB SSD tikv-server x3 c5d.4xlarge 16 vCPU 32 GB mem 400GB SSD tidb-server x3 All tests are done in AWS TiDB environment: TiKV configuration modifications: https://gist.github.com/c4pt0r/b0c39f9da9360af2fb2c41ace274b30e

Configure connection Network configuration settings DBeaver Ultimate User Guide 24.1. Page 3 of 1169. AWS SSM configuration Shell commands Changing current user password Authentication models overview authentication models Authentication Salesforce Mysql two-factor authentication Cloud Explorer overview AWS Cloud Explorer Azure Cloud Explorer Google Cloud Explorer System operations and security Databases Ultimate User Guide 24.1. Page 4 of 1169. Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Google Cloud Explorer credentials Database drivers

connection Network configuration settings DBeaver Ultimate User Guide 24.2.ea. Page 3 of 1171. AWS SSM configuration Shell commands Changing current user password Authentication models overview authentication models Authentication Salesforce Mysql two-factor authentication Cloud Explorer overview AWS Cloud Explorer Azure Cloud Explorer Google Cloud Explorer System operations and security Databases User Guide 24.2.ea. Page 4 of 1171. Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Google Cloud Explorer credentials Database drivers

Network configuration settings DBeaver User Guide 24.2.ea. Page 3 of 1171. Kubernetes configuration AWS SSM configuration Shell commands Changing current user password Authentication models overview authentication models Authentication Salesforce Mysql two-factor authentication Cloud Explorer overview AWS Cloud Explorer Azure Cloud Explorer System operations and security Databases authentication models 4 of 1171. Google Cloud Explorer Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Google Cloud Explorer credentials Database drivers

Network configuration settings DBeaver User Guide 24.1. Page 3 of 1171. Kubernetes configuration AWS SSM configuration Shell commands Changing current user password Authentication models overview authentication models Authentication Salesforce Mysql two-factor authentication Cloud Explorer overview AWS Cloud Explorer Azure Cloud Explorer System operations and security Databases authentication models 4 of 1171. Google Cloud Explorer Cloud Storage Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Google Cloud Explorer credentials Database drivers

authentication models Authentication Salesforce Mysql two-factor authentication Cloud Explorer overview AWS Cloud Explorer Azure Cloud Explorer Google Cloud Explorer System operations and security Databases Guide 24.0. Page 4 of 1099. Cloud File Explorer Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Google Cloud Explorer credentials Database drivers authentication PostgreSQL SSPI authentication Redis Salesforce Salesforce authentication SQLite Teradata AWS Athena DocumentDB Cloud DBeaver User Guide 24.0. Page 6 of 1099. DynamoDB Keyspaces Redshift

authentication models Authentication Salesforce Mysql two-factor authentication Cloud Explorer overview AWS Cloud Explorer Azure Cloud Explorer Google Cloud Explorer System operations and security Databases Guide 24.1.ea. Page 4 of 1099. Cloud File Explorer Managing AWS permissions Working with AWS SSO Working with Google Cloud Explorer SSO AWS credentials Google Cloud Explorer credentials Database drivers authentication PostgreSQL SSPI authentication Redis Salesforce Salesforce authentication SQLite Teradata AWS Athena DocumentDB Cloud DBeaver User Guide 24.1.ea. Page 6 of 1099. DynamoDB Keyspaces Redshift

management Task scheduler Composite tasks Cloud Explorer AWS AWS Credentials AWS SSO MongoDB Cassandra InfluxDB Redis AWS (Amazon Web Services) DynamoDB DocumentDB Keyspaces GCP (Google Cloud typical interactive debugger delivered as an extension. It requires a shared debugger debugger library preload in Postgres to operate the shared_preload_libraries parameter in the settings. The debugger work with their databases. The JDBC driver consists of one or multiple files. The Jar file is a library which contains program code and jar some other files. You need to download the driver's jar files

Composite tasks Sending results by e-mail Cloud Explorer AWS AWS Credentials AWS SSO MongoDB Cassandra InfluxDB Redis AWS (Amazon Web Services) DynamoDB DocumentDB Keyspaces GCP (Google Cloud typical interactive debugger delivered as an extension. It requires a shared debugger debugger library preload in Postgres to operate the shared_preload_libraries parameter in the settings. The debugger work with their databases. The JDBC driver consists of one or multiple files. The Jar file is a library which contains program code and jar some other files. You need to download the driver's jar files

Composite tasks Sending results by e-mail Cloud Explorer AWS AWS Credentials AWS SSO MongoDB Cassandra InfluxDB Redis AWS (Amazon Web Services) DynamoDB DocumentDB Keyspaces GCP (Google Cloud typical interactive debugger delivered as an extension. It requires a shared debugger debugger library preload in Postgres to operate the shared_preload_libraries parameter in the settings. The debugger work with their databases. The JDBC driver consists of one or multiple files. The Jar file is a library which contains program code and jar some other files. You need to download the driver's jar files