AWS Database Blog

Your guide to Amazon RDS sessions, workshops, and chalk talks at AWS re:Invent 2019

AWS re:Invent is less than three weeks away. This post includes a complete list of Amazon RDS sessions, workshops, and chalk talks at AWS re:Invent 2019. Use the information on this page to help schedule your conference week in Las Vegas this year.

Level 200 – Introductory

DAT202-R – What’s new in Amazon Aurora

Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database with the speed, reliability, and availability of commercial databases at one-tenth the cost. In this session you get an overview of Aurora, including recently announced features, such as serverless, multi-master, and performance insights. We also help you get started using Aurora. (Note that this session will be repeated during the week)

DAT207-R – What’s new in Amazon RDS

Amazon Relational Database Service (Amazon RDS) is a fully managed database service that allows you to launch an optimally configured, secure, and highly available database with just a few clicks. It manages time-consuming database administration tasks, freeing you to focus on your applications and business. In this session, we look at all of the new capabilities launched for Amazon RDS across different engines and review the latest features available. (Note that this session will be repeated during the week)

DAT215-R – Build high-performing apps on Amazon Aurora Serverless with RDS Data API

Amazon Relational Database Service (Amazon RDS) Data API lets customers easily access their Amazon Aurora databases with web-services-based applications. In this session, we provide an overview of RDS Data API and show you how to create a microservice with it and Aurora Serverless and AWS Lambda. (Note that this session will be repeated during the week)

Level 300 – Advanced

DAT309-R – Amazon Aurora storage demystified: How it all works

Amazon Aurora is a high-performance, highly scalable database service with MySQL and PostgreSQL compatibility. One of its key components is an innovative storage system that is optimized for database workloads and specifically designed to take advantage of modern cloud technology. In this session, hear from the team that built Amazon Aurora’s storage system about how the system is designed, how it works, and what you need to know to get the most out of it. (Note that this session will be repeated during the week)

DAT311-R – Understanding durability & availability with Amazon RDS for SQL Server

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale SQL Server databases in the cloud. Even when using a fully managed service like Amazon RDS, durability and availability are always key considerations when deploying a database. In this session, you learn how to properly apply both snapshots and native backups to manage durability of your Amazon RDS for SQL Server instance. Additionally, you learn how to use Amazon RDS Multi-AZ to achieve high availability for your Amazon RDS for SQL Server deployment. (Note that this session will be repeated during the week)

DAT312-R – Running mission-critical databases on Amazon RDS for Oracle

Amazon Relational Database Service (Amazon RDS) for Oracle continues to be a popular choice for “lifting and shifting” mission-critical Oracle database workloads to the cloud. In this session, you learn how you can scale compute, storage, and databases to address changing database workload patterns and increasing business demands for cost optimization. We also cover best practices for new high availability, security, and performance monitoring features. Come ask questions and share your experiences. (Note that this session will be repeated during the week)

DAT316-R – MySQL options on AWS: Self-managed, managed, and serverless

In recent years, MySQL has become a top database choice for new application development and migration from overpriced, restrictive commercial databases. In this session, we provide an overview of the MySQL and MariaDB options available on AWS. We also do a deep dive on Amazon Relational Database Service (Amazon RDS), a fully managed MySQL service; Amazon Aurora, a MySQL-compatible database with up to five times the performance; and many additional innovations. (Note that this session will be repeated during the week)

DAT317-R – PostgreSQL options on AWS: Self-managed, managed, and serverless

In this session, we provide an overview of the PostgreSQL options available on AWS. We also do a deep dive on Amazon Relational Database Service (Amazon RDS) for PostgreSQL, a fully managed PostgreSQL service; and Amazon Aurora, a PostgreSQL-compatible database with up to three times the performance of standard PostgreSQL. Learn about the features, functionality, and many innovations in these two services. In doing so, you also gain the background to choose the right service to solve different technical challenges and the knowledge to easily move between services as your requirements change over time. (Note that this session will be repeated during the week)

DAT321-R – Deep dive on Amazon Aurora with MySQL compatibility

Amazon Aurora is a fully managed relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. With Aurora, we’ve completely reimagined how databases are built for the cloud, providing higher performance, availability, and durability than previously possible. In this session, we dive deep into the architectural details of Aurora with MySQL compatibility and review recent innovations, such as parallel query, backtrack, serverless, and multi-master. You also hear from PayPay Corporation, a joint venture between SoftBank and Yahoo Japan, about how it used Aurora MySQL for a modern payment service that serves 15 million users and 1.5 million merchants.

(Note that this session will be repeated during the week with Nintendo talking about their journey of launching Mario Kart)

DAT327-R – Accelerating application development with Amazon Aurora

In this session, learn how to leverage the unique features of the Amazon Aurora platform to build faster, more scalable database applications optimized for the cloud. We discuss architectural best practices and features designed to help increase agility so you can develop applications faster to reach the widest possible audience, such as Amazon Aurora Serverless, read-replica auto scaling, cross-region replicas, backtracking, fast database cloning, and performance insights. Through a hands-on lab, we help you understand how to best take advantage of the Aurora platform’s capabilities to effectively accelerate application development. (Note that this session will be repeated during the week)

DAT328-R – Deep dive on Amazon Aurora with PostgreSQL compatibility

Amazon Aurora with PostgreSQL compatibility is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. In this session, we review the functionality in order to understand the architectural differences that contribute to improved scalability, availability, and durability. You’ll also get a deep dive into the capabilities of the service and a review of the latest available features. Finally, we walk you through the techniques that you can use to migrate to Amazon Aurora. (Note that this session will be repeated during the week)

DAT337 – Running and tuning SQL Server on Amazon RDS

In this workshop, you learn to set up an Amazon RDS for SQL Server instance and migrate data, and you look at ways to monitor performance. You also see how easy it is to identify performance problems and test remediations in Amazon RDS. Additionally, we cover best practices with respect to performance and migration. To participate in this session, bring a laptop computer with Chrome or Firefox and a valid AWS account.

DAT342-R – Lessons from migrating Oracle databases to Amazon Aurora

AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS easily and securely, minimizing downtime to applications that rely on the database. AWS DMS can migrate your data to and from most widely used commercial and open-source databases and, along with AWS Schema Conversion Tool (AWS SCT), has helped multiple customers migrate off of their Oracle databases into Amazon Aurora. In this session, learn about common pitfalls, issues, the biggest differences between the engines, migration best practices, and how some of our customers have completed these migrations. (Note that this session will be repeated during the week)

DAT343-R – Lessons from migrating SQL server databases to Amazon Aurora

AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS easily and securely, minimizing downtime to applications that rely on the database. AWS DMS can migrate your data to and from most widely used commercial and open-source databases and, along with AWS Schema Conversion Tool (AWS SCT), has helped multiple customers migrate off of their SQL Server databases into Amazon Aurora. In this session, learn about common pitfalls, issues, the biggest differences between the engines, migration best practices, and how some of our customers have completed these migrations. (Note that this session will be repeated during the week)

DAT344-R – Deploying the CIA security triad model on Amazon RDS and Amazon Aurora

Data is an enterprise’s lifeblood, and as that data moves to the cloud, applying the CIA security model around confidentiality, integrity, and availability on the core data asset—relational databases—becomes critical. In this session, learn about security features available in Amazon Relational Database Service (Amazon RDS) and Amazon Aurora to build the CIA security triad principles. Delve deep into how native database security capabilities are applied to adhere to stringent governance and compliance models. We also cover integration with services like AWS Config, AWS Key Management Service (AWS KMS), AWS CloudTrail, and Amazon CloudWatch to implement security guardrails that control and monitor database usage. (Note that this session will be repeated during the week)

DAT345-R – Assessing and categorizing your database migrations

Estimating the level of effort and resources required for database migrations and building a business case for them can be challenging. AWS Workload Qualification Framework (AWS WQF), part of AWS Database Migration Service (AWS DMS), uses AWS Schema Conversion Tool (AWS SCT) to collect information to model existing Oracle and Microsoft SQL Server databases and provides instructions to convert them to Amazon Aurora. AWS WQF can conduct a fleet-wide analysis of your database portfolio and categorize migrations based on complexity and workload to determine migration effort. In this session, learn about different migration workload categories and get an overview and demo of AWS WQF. (Note that this session will be repeated during the week)

DAT346 – Planning proof of concept with Amazon Aurora

For relational-database workloads, customers are increasingly adopting Amazon Aurora to take advantage of Aurora’s performance, high availability, durability, manageability, and innovations. The proof of concept (PoC) is the main process and decision-making step to evaluate and adopt Aurora. In this session, learn about methodology and framework about planning PoCs with Aurora.

DAT348-R – Amazon Aurora global database in action

In this hands-on workshop, learn how to achieve multi-region resilience for your application backend by using Amazon Aurora global database. We focus on patterns for multi-region database rollout and real-world use cases. Get hands-on and learn how Aurora global database allows you to scale your infrastructure without having to implement complicated multi-region patterns and see how to best leverage Aurora global database for fast cross-region disaster recovery and low-latency global reads. (Note that this session will be repeated during the week)

DAT350-R – Migrating open-source databases from Amazon EC2 to Amazon Aurora MySQL

Running your open-source database on Amazon Elastic Compute Cloud (Amazon EC2) is convenient, but can it be easier, more scalable, and more cost effective? You bet it can. In this session, learn how to effectively and efficiently migrate a MySQL database from Amazon EC2 to Amazon Aurora, increase availability, and reduce cost. (Note that this session will be repeated during the week)

DAT355-R – How to choose between Amazon Aurora MySQL and PostgreSQL

Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database built for the cloud that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases. In this session, hear about some of the unique as well as common features of Aurora MySQL and PostgreSQL and learn about the design considerations for choosing one over the other for a given workload. (Note that this session will be repeated during the week)

DAT359 – How Amazon.com migrated its applications from Oracle to AWS databases

Amazon.com recently completed its enterprise database migration to AWS. In this session, Amazon.com leaders relay how they achieved database freedom with AWS. They discuss the enterprise program they built, and they share the lessons they learned and the benefits they realized. They also share how they reduced third-party and scaling risks to deliver peak retail events, such as Amazon Prime Day, Amazon Black Friday, and Cyber Monday.

DAT362-R – Dive deep into AWS SCT and AWS DMS

In this session presented by AWS and Autodesk, learn how to convert and migrate your relational databases, non-relational databases, and data warehouses to the cloud. AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) can help with homogeneous migrations as well as migrations from different database engines, such as Oracle or SQL Server, to Amazon Aurora. We demo the latest features added to AWS DMS and AWS SCT. (Note that this session will be repeated during the week)

DAT364-R – Deep dive on Amazon RDS for SQL Server

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale SQL Server databases in the cloud. This session dives deep into the new features and best practices that make your Amazon RDS for SQL Server database deployments highly available, scalable, and secure. (Note that this session will be repeated during the week)

DAT365-R – What’s new in Amazon RDS for Oracle

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale Oracle databases in the cloud. This session dives deep into the new features and best practices that make your Amazon RDS for Oracle database deployments highly available, scalable, and secure. (Note that this session will be repeated during the week)

DAT366-R – Running Oracle on Amazon RDS and migrating to Aurora PostgreSQL

If you’d like to move your Oracle databases to the cloud, this workshop is for you. We review the basics of Amazon Relational Database Service (Amazon RDS) and how Oracle databases run in Amazon RDS. We then leverage the combination of AWS Schema Conversion Tool and AWS Database Migration Service (AWS DMS), and we show you how to migrate your databases to Amazon Aurora PostgreSQL. You need a laptop with a Firefox or Chrome browser and a working AWS account. (Note that this session will be repeated twice during the week)

DAT367-R – Running SQL Server on Amazon RDS and migrating to Aurora MySQL

If you’d like to move your SQL Server databases to the cloud, this workshop is for you. We review the basics of Amazon Relational Database Service (Amazon RDS) and how SQL Server databases run in Amazon RDS. We then leverage the combination of AWS Schema Conversion Tool and AWS Database Migration Service (AWS DMS), and we show you how to migrate your databases to Amazon Aurora MySQL. You need a laptop with a Firefox or Chrome browser and a working AWS account. (Note that this session will be repeated twice during the week)

DAT381 – How Verizon moves databases to Amazon RDS with zero downtime

Learn how Verizon Wireless is moving mission-critical databases from on premises to Amazon RDS. Verizon’s workloads, including VZW.com, demand high availability, data consistency, and low latency at all times to service millions of customers every day. In this session, Verizon engineers share how they achieved a zero-downtime migration to AWS by setting up a multi-region active-active architecture and ensuring data synchronization across on-premises and cloud environments during the transition phase. They dive deep into the specific features and tools used and share the challenges and lessons learned during the migration process.

FSI309 – Relational databases: Performance, scale, and availability

Relational databases have long been the heart and soul of Financial Services. Despite their popularity, operating these databases at scale to meet the strict performance and availability requirements of the industry can be difficult. In this session, we look at applying these demanding principals to Amazon Aurora, a MySQL and PostgreSQL-compatible relational database built for the cloud. Learn how to integrate Amazon Aurora into your existing applications or design from the very beginning to achieve new levels of performance, availability, and scale.

GAM304 – Migrating the live Pokémon database to Aurora PostgreSQL

Learn how the Pokémon Company International stores and supports data for more than 300 million players with the help of AWS. In this session, Jeff Webb (development manager) and David Williams (senior DevOps engineer) discuss how they migrated to Amazon Aurora PostgreSQL and Amazon DynamoDB, resulting in zero downtime for operations. Hear about best practices for migration and get a glimpse into the services supporting Pokémon Go, including AWS Lambda, Amazon Kinesis, Amazon Redshift, and more.

GPSTEC315 – Oracle to Amazon Aurora migration workshop

Although this Global Partner Summit workshop is open to anyone, it is geared toward current and potential members of the AWS Partner Network. Amazon Aurora is a MySQL- and PostgreSQL-compatible relational database built for the cloud that combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. In this hands-on workshop, you learn to migrate Oracle databases to Aurora PostgreSQL with minimum downtime using AWS Schema Conversion Tool and AWS Database Migration Service (AWS DMS). We also discuss sizing, performance tuning, and cost optimization while migrating your database workloads to AWS.

GPSTEC319 – Migrating to Aurora: Design patterns for a cloud-native database platform

Although this Global Partner Summit chalk talk is open to anyone, it is geared toward current and potential AWS Partner Network Partners. In this chalk talk, we dive into common application architecture design patterns with Amazon Aurora. We share what it takes to either replatform or rearchitect your application when coming from Oracle, SQL Server, or any other relational database into Aurora. We also talk about migration strategies, application code changes, commonly used tools, and do’s and don’ts for a smooth ride in your migration journey. Finally, we talk about common application architecture design patterns with Aurora to answer some of your toughest questions on high availability, disaster recovery, performance, scalability, security, and operational excellence.

GPSTEC345 – Operational excellence with Amazon Aurora PostgreSQL

Although this Global Partner Summit session is open to anyone, it is geared toward current and potential AWS Partner Network Partners. While database migrations are a hot topic, a common inhibitor for adoption is operational excellence. Common customer feedback is that they want their staff to be operationally ready before they take the solution to market. This means that the customers don’t just want to choose the best technology based on features and cost, they want to also be operationally successful with that technology to provide a continuous value to their business. In this session, we discuss the top questions of operations teams as well as the top mistakes to avoid when running Amazon Aurora in production.

WPS304 – Pushing Amazon RDS to the limit

Is Amazon EC2 the only option for your legacy customized Oracle DB on AWS? Want to move your legacy Oracle database on AWS but aren’t sure that Amazon Relational Database Service (Amazon RDS) can handle the custom developments you have on top of your business-critical database? In this session, learn how you can leverage Amazon Oracle RDS to accommodate specifics of your legacy database in the cloud. We also discuss when and how to choose between Amazon EC2 and Amazon RDS, outline remediation and migration steps for Amazon RDS, and share practice-proven experience from providing FTP and SMTP from Amazon RDS.

Level 400 – Expert

DAT401-R – Running on-premises and cloud databases with Amazon RDS on VMware

In this chalk talk, we explain how to prepare your local environment to start using Amazon RDS on VMware, how to create your first database, and how to manage and monitor a hybrid fleet of databases that runs both on premises and on AWS. We also go over examples of how to take manual snapshots, take automatic backups, and restore from those backups. (Note that this session will be repeated during the week)

DAT402-R – Going deep on Amazon Aurora Serverless

Amazon Aurora Serverless is a configuration for Amazon Aurora (MySQL and PostgreSQL-compatible editions) where the database automatically starts up, shuts down, and scales capacity up or down based on your application’s needs. In this session, we discuss how Aurora Serverless supports infrequent, intermittent, or unpredictable workloads, and we provide tips for building your next application on a serverless database. (Note that this session will be repeated during the week)

DAT404-R – Amazon Aurora Multi-Master: Scaling out database write performance

In this session, learn how the Multi-Master capability of Amazon Aurora MySQL enables applications to scale out write performance and achieve continuous read/write availability. Engineering experts dive into the design concepts of Aurora Multi-Master and provide real-world advice on deploying high-throughput, highly available workloads in Aurora. (Note that this session will be repeated during the week)

Builder Sessions

These are 60-minute small group sessions with up to six customers and one AWS expert, who is there to help, answer questions, and provide guidance. It’s just you, your laptop, and the AWS expert.

DAT216-R – Build on Amazon RDS for MySQL and MariaDB

DAT217-R – Build on Amazon RDS for PostgreSQL

DAT218-R – Build on Amazon RDS for Oracle

DAT219-R – Build on Amazon RDS for SQL Server

DAT339-R – Build on Amazon Aurora with MySQL compatibility

DAT340-R – Build on Amazon Aurora with PostgreSQL compatibility

 


About the Author

 

Saurabh Jain is a Senior Product Manager with the Relational Database Services (RDS) team at Amazon Web Services.