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. ○ --db-driver=mysql oltp_common prepare --tables=16 --table-size=10000000 --auto-inc=false Thread TiDB 3.0 Amazon Aurora 150 158,908.53 496,746.62 300 279,335.92 727,939.27 600 422,278.72 763,700.65 900 484,304

Page 19 of 252. Server information Configuration Custom connections Navigator simple view Services AWS Authentication settings Security Save credentials Save users credentials CloudBeaver offers like. Database navigator You can read more about Simple and Advanced mode . here Enables AWS Services. Define different authentication methods. You can read more about authentication methods . here here Server information Configuration Custom connections Navigator simple view Services AWS Authentication settings Security Save credentials CloudBeaver User Guide 23.3. Page 21 of 252. Allow

like. Database navigator You can read more about Simple and Advanced mode . here Enables AWS Services. Define different authentication methods. You can read more about authentication methods . here saving credentials for the pre-configured database. Allow saving credentials for non-admin users. Services AWS Authentication settings Security Save credentials Save users credentials CloudBeaver 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 an

navigator structure will look like. You can read more about Simple and Advanced mode here. Enables AWS Services. Define different authentication methods. You can read more about authentication methods here. Server configuration Server information Configuration Custom connections Navigator simple view Services AWS Authentication settings Security Save credentials Save users credentials CloudBeaver 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 an IAM

You can connect to databases using secure authentication via Kerberos or GCP, AWS, and Azure cloud services. Kerberos is an authentication protocol, the default authentication technology used in Microsoft supported databases Learn more about authentication via Kerberos Users can connect to all company services using only one login and password. This is possible if you use SSO - Single Sign-On authentication When a user connects to the database, DBeaver opens a web browser with SSO authentication. DBeaver supports the following SSO authentication services: AWS SSO Password for one project Secure authentication

You can connect to databases using secure authentication via Kerberos or GCP, AWS, and Azure cloud services. Kerberos is an authentication protocol, the default authentication technology used in Microsoft supported databases Learn more about authentication via Kerberos Users can connect to all company services using only one login and password. This is possible if you use SSO - Single Sign-On authentication When a user connects to the database, DBeaver opens a web browser with SSO authentication. DBeaver supports the following SSO authentication services: AWS SSO Password for one project Secure authentication

You can connect to databases using secure authentication via Kerberos or GCP, AWS, and Azure cloud services. Kerberos is an authentication protocol, the default authentication technology used in Microsoft supported databases Learn more about authentication via Kerberos Users can connect to all company services using only one login and password. This is possible if you use SSO - Single Sign-On authentication When a user connects to the database, DBeaver opens a web browser with SSO authentication. DBeaver supports the following SSO authentication services: AWS SSO GCP SSO Azure Password for one project

You can connect to databases using secure authentication via Kerberos or GCP, AWS, and Azure cloud services. Kerberos is an authentication protocol, the default authentication technology used in Microsoft supported databases Learn more about authentication via Kerberos Users can connect to all company services using only one login and password. This is possible if you use SSO - Single Sign-On authentication When a user connects to the database, DBeaver opens a web browser with SSO authentication. DBeaver supports the following SSO authentication services: AWS SSO GCP SSO Azure Password for one project

Simple and Advanced mode . here Enables AWS Services. Server configuration Server information Configuration Custom connections Navigator simple view Services AWS CloudBeaver User Guide 22.3. Page 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 an IAM test Container ID CloudBeaver User Guide 22.3. Page 66 of 121. CloudBeaver is a web server which provides a rich web interface. It consists of two parts: Server back-end. It is written in Java and reuses

Simple and Advanced mode . here Enables AWS Services. Server configuration Server information Configuration Custom connections Navigator simple view Services AWS CloudBeaver User Guide 23.1. Page 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 an IAM /etc/cloudbeaver/ But in most cases it is redefined for each server by the command line parameter, . -web-config The server configuration is in the JSONC format (JSON with comments and without