AWS Brings More Automation to Database Management

Amazon Web Services announced new tools on Wednesday bringing more automation to database management. The new Amazon DevOps Guru for RDS can automatically find and troubleshoot database issues in Amazon Aurora databases. Additionally, the new AWS Database Fleet Advisor automates migration planning for an entire database fleet.

Last year, AWS introduced DevOps Guru, a service that uses machine learning to automatically detect and alert customers of application issues, including database issues. Amazon DevOps Guru for RDS builds on this, helping developers using Aurora detect, diagnose, and resolve database performance issues.

The service “gets you to a solution in minutes,” said Swami Sivasubramanian, vice president of AI and ML for AWS, in a speech at the re: Invent conference.

DevOps Guru for RDS can help address a range of issues, such as overuse of host resources, database bottlenecks, or bad SQL query behavior. When an issue is detected, users can view it in the DevOps Guru console or through notifications from Amazon EventBridge or Amazon Simple Notification Service (SNS).

Meanwhile, AWS has also introduced database tools to aid in the migration process. The new AWS Database Fleet Advisor, previewed, automates migration for an entire database fleet.

“Creating a migration plan for an entire database fleet is a difficult task,” said Sivasubramanian, noting that it involves taking an inventory of the databases, creating the right migration path for each and determining the good service target AWS. The process is very manual, can take weeks or months, and often requires the assistance of a third party.

With AWS DMS Fleet Advisor, the process can take a few hours, Sivasubramanian said. The service collects and analyzes schemas and database objects, including information about feature metadata, schema objects, and usage metrics. It then allows the customer to create a custom migration plan by determining the complexity of migrating from source databases to target services in AWS.

Amazon also announced general availability of Amazon RDS Custom for SQL Server on Wednesday, allowing customers to customize databases so they can run critical SQL Server applications, such as Microsoft SharePoint, in the cloud. This will help customers activate features that require elevated privileges like SQL Common Language Runtime (CLR), install specific drivers to activate heterogeneous linked servers, or have more than 100 databases per instance.

The new service follows the launch of Amazon RDS Custom for Oracle.

“Support for Oracle and SQL Server will unlock the benefits of managed databases for many more,” said Sivasubramanian.

Maria H. Underwood