Amazon CloudWatch Database Insights now detects anomalies on additional metrics through its on-demand analysis experience. Database Insights is a monitoring and diagnostics solution that helps database administrators and application developers optimize database performance by providing comprehensive visibility into database metrics, query performance, and resource utilization patterns. The on-demand analysis feature utilizes machine learning to help identify anomalies and performance bottlenecks during the selected time period, and gives advice on what to do next. The Database Insights on-demand analysis feature now offers enhanced anomaly detection capabilities. Previously, database administrators could analyze database performance and correlate metrics based on database load. Now, the on-demand analysis report also identifies anomalies in database-level and operating system-level counter metrics for the database instance, as well as per-SQL metrics for the top SQL statements contributing to database load. The feature automatically compares your selected time period against normal baseline performance, identifies anomalies, and provides specific remediation advice while reducing mean time to diagnosis. Through intuitive visualizations and clear explanations, you can quickly identify performance issues and receive step-by-step guidance for resolution. You can get started with on-demand analysis by enabling the Advanced mode of CloudWatch Database Insights on your Amazon Aurora or RDS databases using the AWS management console, AWS APIs, or AWS CloudFormation. Please refer to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Overview.Engines.html and https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.Overview.Engines.html#USER_PerfInsights.Overview.PIfeatureEngnRegSupport for information regarding the availability of Database Insights across different regions, engines, and instance classes.

https://aws.amazon.com/rds/oracle/ is now available with R7i memory-optimized preconfigured instances that offer additional memory and storage I/O per vCPU. Powered by custom 4th Gen Intel Xeon Scalable processors with AWS Nitro System and DDR5 memory for high performance, these instances provide up to 64:1 memory-to-vCPU ratio. Many Oracle database workloads require high memory, but can safely reduce the number of vCPUs without impacting application performance. By running such Oracle database workloads on R7i pre-configured instances, customers can lower their Oracle database licensing and support costs while meeting high performance application requirements. Memory optimized R7i pre-configured instances are available for Amazon RDS for Oracle with Bring Your Own License (BYOL) license model supporting both Oracle Database Enterprise Edition and Oracle Database Standard Edition 2. To learn more about Amazon RDS for Oracle R7i memory-optimized preconfigured instances, read https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Concepts.InstanceClasses.html and visit https://aws.amazon.com/rds/oracle/pricing/ for available instance configurations, pricing details, and region availability.

Amazon CloudWatch Database Insights now supports tag-based access control for database and per-query metrics powered by RDS Performance Insights. You can implement access controls across a logical grouping of database resources without managing individual resource-level permissions. Previously, tags defined on RDS and Aurora instances did not apply to metrics powered by Performance Insights, creating significant overhead in manually configuring metric-related permissions at the database resource level. With this launch, those instance tags are now automatically evaluated to authorize metrics powered by Performance Insights. This allows you to define IAM policies using tag-based access conditions, resulting in improved governance and security consistency. Please refer to RDS and Aurora documentation to get started with defining IAM policies with tag-based access control on database and per-query metrics. This feature is available in all AWS regions where CloudWatch Database Insights is available. CloudWatch Database Insights delivers database health monitoring aggregated at the fleet level, as well as instance-level dashboards for detailed database and SQL query analysis. It offers vCPU-based pricing – see the pricing page for details. For further information, visit the Database Insights User Guide.

https://aws.amazon.com/rds/db2/ now offers Reserved Instances with up to 47% cost savings compared to On-Demand prices. The option to use Reserved Instances is available for all https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Db2.Concepts.General.InstanceClasses.html. Amazon RDS for Db2 Reserved Instances provide size flexibility for both Bring Your Own License (BYOL) and Db2 license purchased through AWS Marketplace. With Reserved Instances size flexibility, the discounted rate for Reserved Instances automatically applies to usage of any size in the same instance family. For example, if you purchase a db.r7i.2xlarge Reserved Instance in US East (N. Virginia), the discounted rate of this Reserved Instance can automatically apply to 2 db.r7i.xlarge instances. For information on RDS Reserved Instances, refer tohttps://aws.amazon.com/rds/reserved-instances/ You can purchase Reserved Instances through the AWS Management Console, AWS CLI, or AWS SDK. For detailed pricing information and purchase options, refer to https://aws.amazon.com/rds/db2/pricing/.

Amazon RDS for MariaDB now supports MariaDB Innovation Release 11.7 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MariaDB. You can deploy MariaDB 11.7 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases. MariaDB 11.7 is the latest Innovation Release from the MariaDB community, and includes support for vector datatype, indexing, and search capabilities. MariaDB Innovation releases are supported by the community until the next Innovation release, whereas MariaDB Long Term Maintenance Releases, such as MariaDB 10.11 and MariaDB 11.4, are supported by the community for up to five years. Please refer to the MariaDB 11.7 release notes for more details about this release. The Amazon RDS Database Preview Environment supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes. Amazon RDS Database Preview Environment database instances are retained for a maximum period of 60 days and are automatically deleted after the retention period. Amazon RDS database snapshots that are created in the preview environment can only be used to create or restore database instances within the preview environment. Amazon RDS Database Preview Environment database instances are priced the same as production RDS instances created in the US East (Ohio) Region.

Amazon RDS for PostgreSQL introduces Extended Support minor versions 12.22-rds.20250814 and 11.22-rds.20250814, which include important security updates and bug fixes for PostgreSQL databases.We recommend upgrading your RDS instances to these latest versions to maintain optimal security and performance of your PostgreSQL deployments. Amazon RDS Extended Support provides you more time, up to three years, to upgrade to a new major version to help you meet your business requirements. During Extended Support, Amazon RDS will provide critical security and bug fixes for your RDS for PostgreSQL databases after the community ends support for a major version. You can run your PostgreSQL databases on Amazon RDS with Extended Support for up to three years beyond a major version’s end of standard support date. You can use automatic minor version upgrades to automatically upgrade your databases to more recent minor versions during scheduled maintenance windows. You can also use Amazon RDS Blue/Green deployments for RDS for PostgreSQL using physical replication for your minor version upgrades. Learn more about upgrading your database instances, including automatic minor version upgrades and Blue/Green Deployments in the Amazon RDS User Guide. Amazon RDS for PostgreSQL makes it simple to set up, operate, and scale PostgreSQL deployments in the cloud. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. Create or update a fully managed Amazon RDS database in the Amazon RDS Management Console.

Aurora PostgreSQL Limitless enables massive horizontal scaling for write throughput and storage by distributing workloads across multiple Aurora instances while using standard PostgreSQL queries and s...

Amazon Relational Database Service (RDS) for DB2 now supports read replicas. Customers can add up to three read replicas for their database instance, and use the replicas to support read-only applications without overloading the primary database instance. Customers can setup replicas in the same region or in a different region from the primary database instance. When a read replica is setup, RDS replicates changes asynchronously to the read replicas. Customers can run their read-only queries against the read replica without impacting performance of the primary database instance. Customers can also use read replicas for disaster recovery procedures by promoting a read replica to support both read and write operations. Read replicas require IBM Db2 licenses for all vCPUs on replica instances. Customers can obtain On-Demand Db2 licenses from the AWS Marketplace, or use Bring Your Own License (BYOL). To learn more, refer to Amazon RDS for Db2 documentation and pricing pages.

Amazon RDS (Relational Database Service) Performance Insights now allows customers to monitor queries run through the RDS Data API for Aurora MySQL clusters. The RDS Data API provides an HTTP endpoint to run SQL statements on an Amazon Aurora DB cluster. With this launch, customers are now able to use Performance Insights to monitor the impact of the queries run through the RDS Data API on their database performance. Additionally, customers can identify these queries and their related statistics by slicing the database load metric using the host name dimension, and filtering for 'RDS Data API'. Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS that allows you to visually assess the load on your database and determine when and where to take action. With one click in the Amazon RDS Management Console, you can add a fully-managed performance monitoring solution to your Amazon RDS database. To learn more about RDS Performance Insights, read the Amazon RDS User Guide and visit Performance Insights pricing for pricing details and region availability.

Customers running Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB databases can now purchase Reserved Instances for R7i and M7i instances. These instances are powered by custom 4th Generation Intel Xeon Scalable processors and provide larger sizes up to 48xlarge with an 8:1 ratio of memory to vCPU and the latest DDR5 memory. Reserved Instances offer significant savings over On-Demand rates with three flexible payment options: All Upfront providing the highest discount, Partial Upfront balancing between upfront and hourly payments, and No Upfront requiring no initial payment. Reserved Instances provide instance size flexibility within the same family and automatically apply to both Single-AZ and Multi-AZ configurations, making them ideal for varying production workloads. These 1-year Reserved Instances are available for Aurora MySQL, Aurora PostgreSQL, RDS for MySQL, RDS for PostgreSQL, and RDS for MariaDB in all AWS regions where R7i and M7i instances are offered with On-Demand pricing. For information on specific engine versions that support these DB instance types, refer to Aurora and RDS documentation. To get started, purchase Reserved Instances through the AWS Management Console, AWS CLI, or AWS SDK. For detailed pricing information and purchase options, visit Aurora and RDS pricing pages. For additional questions related to Reserved Instances, refer to RDS FAQs.

Amazon RDS now supports Redo Transport Compression, a feature that compresses redo data before it is transmitted to a standby database. By reducing the amount of data sent over the network, it improves redo transport performance. Because of faster redo log transport, customers can achieve a lower Recovery Point Objective (RPO), which is the amount of data loss that may occur when promoting a replica in situations where the primary instance becomes unavailable. Compression and decompression of redo data consumes CPU resources on both the primary and standby databases. Customers should ensure that sufficient CPU capacity is available to handle this increased workload, and use Redo Transport Compression in situations where reduced network traffic and improved RPO outweigh the CPU overhead of compression. To enable the feature, set redo_compression parameter in the Parameter Group for your database instance. Redo Log Compression is available for both mounted and read replicas, and requires Oracle Enterprise Edition with Oracle Advanced Compression Licensing. Redo Transport Compression is available in all AWS Regions where Amazon RDS for Oracle is available. To learn more about using Redo Transport Compression, visit the Amazon RDS User Guide.

Amazon Relational Database Service (Amazon RDS) Blue/Green Deployments now support managed initialization of Green storage volumes that accelerates the loading of storage blocks from Amazon S3. This ensures that the volumes are fully performant prior to switchover of the Green databases. Blue/Green Deployments create a fully managed staging environment, or Green database, by restoring the Blue database snapshot. The Green database allows you to deploy and test production changes, keeping your current production database, or Blue database, safer. Previously, you had to manually initialize the storage volumes of the Green databases. With this launch, RDS Blue/Green Deployments will proactively manage and accelerate the storage initialization for your green database instances. You will be able to view the progress of storage initialization using the RDS Console and command line interface (CLI). Managed storage initialization of the Green databases is supported for Blue/Green deployments created for RDS for PostgreSQL, RDS for MySQL, and RDS for MariaDB engines. Amazon RDS Blue/Green Deployments are available for Amazon RDS for PostgreSQL major versions 12 and higher, RDS for MySQL major versions 5.7 and higher, and Amazon RDS for MariaDB major versions 10.4 and higher. In a few clicks, update your databases using Amazon RDS Blue/Green Deployments via the Amazon RDS Console. Learn more about RDS Blue/Green Deployments and the supported engine versions here.

Find information on upgrading your database engine version.

Amazon CloudWatch Database Insights now collects the query execution plans of top SQL queries running on Aurora PostgreSQL instances, and stores them over time. This feature helps you identify if a change in the query execution plan is the cause of performance degradation or a stalled query. Execution plan capture for Aurora PostgreSQL is available exclusively in the Advanced mode of CloudWatch Database Insights. A query execution plan is a sequence of steps that database engines use to retrieve or modify data in a relational database management system (RDBMS). The RDBMS query optimizers may not always choose the most optimal execution plan from a set of alternative ways to execute a given query. Hence, database users sometimes need to manually examine and tune the plans to improve performance. This feature allows you to visualize multiple plans of a SQL query and compare them. It can help you determine if a change in performance of a SQL query is due to a different query execution plan within minutes. You can get started with this feature by enabling Database Insights Advanced mode on your Aurora PostgreSQL clusters using the RDS service console, AWS APIs, or the AWS SDK. CloudWatch Database Insights delivers database health monitoring aggregated at the fleet level, as well as instance-level dashboards for detailed database and SQL query analysis. CloudWatch Database Insights is available in https://aws.amazon.com/about-aws/global-infrastructure/regional-product-services/ and offers vCPU-based pricing – see the https://aws.amazon.com/cloudwatch/pricing/ for details. For further information, visit thehttps://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/Database-Insights.html

Customers running Amazon Aurora and RDS for PostgreSQL, MySQL, and MariaDB databases can now purchase Reserved Instances for R7i and M7i instances. These instances are powered by custom 4th Generation Intel Xeon Scalable processors and provide larger sizes up to 48xlarge with an 8:1 ratio of memory to vCPU and the latest DDR5 memory. Reserved Instances offer significant savings over On-Demand rates with three flexible payment options: All Upfront providing the highest discount, Partial Upfront balancing between upfront and hourly payments, and No Upfront requiring no initial payment. Reserved Instances provide instance size flexibility within the same family and automatically apply to both Single-AZ and Multi-AZ configurations, making them ideal for varying production workloads. These 1-year Reserved Instances are available for Aurora MySQL, Aurora PostgreSQL, RDS for MySQL, RDS for PostgreSQL, and RDS for MariaDB in all AWS regions where R7i and M7i instances are offered with On-Demand pricing. For information on specific engine versions that support these DB instance types, refer to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.DBInstanceClass.SupportAurora.html and https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.Support.html documentation. To get started, purchase Reserved Instances through the https://console.aws.amazon.com/rds/home, AWS CLI, or AWS SDK. For detailed pricing information and purchase options, visit https://aws.amazon.com/rds/aurora/pricing/ and https://aws.amazon.com/rds/pricing/ pricing pages. For additional questions related to Reserved Instances, refer to https://aws.amazon.com/rds/faqs/#awt-content-topics.

https://aws.amazon.com/rds/postgresql/ 18 Beta 2 is now available in thehttps://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/create-db-instance-in-preview-environment.html allowing you to evaluate the pre-release of PostgreSQL 18 on Amazon RDS for PostgreSQL. You can deploy PostgreSQL 18 Beta 2 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database. PostgreSQL 18 includes "skip scan" support for multicolumn B-tree indexes and improves WHERE clause handling for OR and IN conditions. It introduces parallel GIN index builds and updates join operations. Observability improvements show buffer usage counts and index lookups during query execution, along with per-connection I/O utilization metric. Please refer the https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-versions.html#postgresql-version18 for more details. Amazon RDS Database Preview Environment database instances are retained for a maximum period of 60 days and are automatically deleted after the retention period. Amazon RDS database snapshots that are created in the preview environment can only be used to create or restore database instances within the preview environment. You can use the PostgreSQL dump and load functionality to import or export your databases from the preview environment. Amazon RDS Database Preview Environment database instances are priced as per the https://aws.amazon.com/rds/postgresql/pricing/ in the US East (Ohio) Region.

米IBMは年月日米国現地時間AmazonRDSforDbを提供開始したと発表した米AmazonWebServicesAWSのマネージド型データベースサーバーAmazonRelationalDatabaseServiceRDSで動作するこれでAmazonRDSで選択可能なDBMSは種類になった

Amazon RDS for Oracle and Amazon RDS Custom for Oracle now support bare metal instances. You can use M7i, R7i, X2iedn, X2idn, X2iezn, M6i, M6id, M6in, R6i, R6id, and R6in bare metal instances at 25% lower price compared to equivalent virtualized instances. With bare metal instances, you can combine multiple databases onto a single bare metal instance to reduce cost by using the Multi-tenant feature. For example, databases running on a db.r7i.16xlarge instance and a db.r7i.8xlarge instance can be consolidated to individual pluggable databases on a single db.r7i.metal-24xl instance. Furthermore, you may be able to reduce your commercial database license and support costs by using bare metal instances since they provide full visibility into the number of CPU cores and sockets of the underlying server. Refer to Oracle Cloud Policy and Oracle Core Factor Table, and consult your licensing partner to determine if you can reduce license and support costs. Bare metal instances are available with Bring Your Own License (BYOL) license for Oracle Enterprise Edition. Refer to Amazon RDS for Oracle Pricing and Amazon RDS Custom for Oracle Pricing for available instance configurations, pricing, and region availability.

Amazon CloudWatch Database Insights now provides lock contention diagnostics for Aurora PostgreSQL instances. This feature helps you identify the root cause behind both ongoing and historical lock contention issues within minutes. The lock contention diagnostics feature is available exclusively in the Advanced mode of CloudWatch Database Insights. With this launch, you can visualize a locking condition in the Database Insights console, which shows the relationship between blocking and waiting sessions. The visualization helps you quickly identify the dominating sessions, queries, or objects causing lock contention. Additionally, this feature persists historical locking data for 15 months, allowing you to analyze and investigate historical locking conditions. You no longer need to manually run custom queries or rely on application logs to diagnose lock contention issues, streamlining the troubleshooting process. You can get started with this feature by enabling the Advanced mode of CloudWatch Database Insights on your Aurora PostgreSQL clusters using the Aurora service console, AWS APIs, or the AWS SDK. CloudWatch Database Insights delivers database health monitoring aggregated at the fleet level, as well as instance-level dashboards for detailed database and SQL query analysis. CloudWatch Database Insights is available in all public AWS Regions and offers vCPU-based pricing – see the pricing page for details. For further information, visit the Database Insights documentation.

はじめにこの記事はDevOpsonAWS大全の一部ですDevOpsonAWS大全の一覧はこちらこの記事ではRDSとAuroraを耐障害性の観点から超詳細解説しています具体的には

https://aws.amazon.com/rds/sqlserver/ now supports linked servers to Teradata databases. Linked server is a SQL Server feature that enables customers to read data and execute commands on remote database servers outside of the SQL Server instance. With this launch, customers can link their RDS for SQL Server instance to a Teradata database running on AWS or on premises. To start setting up a linked server for Teradata, add the ODBC_TERADATA option to your RDS for SQL Server instance's Option Group. Amazon RDS automatically installs and configures the Teradata ODBC driver, enabling you to run distributed queries, and execute SQL commands on your Teradata database from your RDS for SQL Server instance. Linked servers on RDS support distributed transactions through Microsoft Distributed Transaction Coordinator (MSDTC) and use TLS (Transport Layer Security) encryption for secure connections. To learn more about setting up and using Teradata linked servers, refer to the https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerTeradata.html. This feature is available in all AWS Regions where Amazon RDS for SQL Server is available. See https://aws.amazon.com/rds/sqlserver/pricing/ for pricing details and regional availability.

https://aws.amazon.com/rds/db2/ now enables the creation of multiple Db2 databases within a database instance. This enhanced capability offers greater flexibility in managing databases and optimizing licenses for various enterprise workloads. Customers can now provision and manage up to 50 Db2 databases within a single RDS for Db2 instance, eliminating the need to deploy and license databases individually for each RDS instance. Customers using multiple databases can quickly create, activate, deactivate or drop databases, enabling them to reduce the overhead of managing separate RDS for Db2 instances. To create multiple databases within an Amazon RDS for Db2 instance, simply set up an RDS instance in the AWS Management Console or using the AWS CLI, then use the create_database stored procedure to create multiple Db2 databases on that RDS instance. Amazon RDS makes it simple to set up, operate, and scale Db2 deployments in the cloud. To learn more about Amazon RDS for Db2, check https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Db2.html and https://aws.amazon.com/rds/db2/pricing/ page for pricing details and regional availability.