Search the Community

Don’t be surprised if you have seen the Certificate Update in the Amazon Relational Database Service (Amazon RDS) console. If you use or plan to use Secure Sockets Layer (SSL) or Transport Layer Security (TLS) with certificate verification to connect to your database instances of Amazon RDS for MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and Amazon Aurora, it means you should rotate new certificate authority (CA) certificates in both your DB instances and application before the root certificate expires. Most SSL/TLS certificates (rds-ca-2019) for your DB instances will expire in 2024 after the certificate update in 2020. In December 2022, we released new CA certificates that are valid for 40 years (rds-ca-rsa2048-g1) and 100 years (rds-ca-rsa4096-g1 and rds-ca-ecc384-g1). So, if you rotate your CA certificates, you don’t need to do It again for a long time... View the full article

Today, AWS Backup announces support for Amazon Aurora continuous backup, allowing specific point-in-time restore within customers’ retention period of up to 35 days. AWS Backup is a fully managed service that centralizes and automates data protection across AWS services and hybrid workloads. With this launch, Aurora customers using AWS Backup can now meet their Recovery Point Objective (RPO) to a granularity of 1 second. View the full article

This post is part of our Week in Review series. Check back each week for a quick roundup of interesting news and announcements from AWS! A new week starts, and Spring is almost here! If you’re curious about AWS news from the previous seven days, I got you covered. Last Week’s Launches Here are the launches that got my attention last week: Amazon S3 – Last week there was AWS Pi Day 2023 celebrating 17 years of innovation since Amazon S3 was introduced on March 14, 2006. For the occasion, the team released many new capabilities: S3 Object Lambda now provides aliases that are interchangeable with bucket names and can be used with Amazon CloudFront to tailor content for end users. S3 now support datasets that are replicated across multiple AWS accounts with cross-account support for S3 Multi-Region Access Points. You can now create and configure replication rules to automatically replicate S3 objects from one AWS Outpost to another. Amazon S3 has also simplified private connectivity from on-premises networks: with private DNS for S3, on-premises applications can use AWS PrivateLink to access S3 over an interface endpoint, while requests from your in-VPC applications access S3 using gateway endpoints. We released Mountpoint for Amazon S3, a high performance open source file client. Read more in the blog. Note that Mountpoint isn’t a general-purpose networked file system, and comes with some restrictions on file operations. Amazon Linux 2023 – Our new Linux-based operating system is now generally available. Sébastien’s post is full of tips and info. Application Auto Scaling – Now can use arithmetic operations and mathematical functions to customize the metrics used with Target Tracking policies. You can use it to scale based on your own application-specific metrics. Read how it works with Amazon ECS services. AWS Data Exchange for Amazon S3 is now generally available – You can now share and find data files directly from S3 buckets, without the need to create or manage copies of the data. Amazon Neptune – Now offers a graph summary API to help understand important metadata about property graphs (PG) and resource description framework (RDF) graphs. Neptune added support for Slow Query Logs to help identify queries that need performance tuning. Amazon OpenSearch Service – The team introduced security analytics that provides new threat monitoring, detection, and alerting features. The service now supports OpenSearch version 2.5 that adds several new features such as support for Point in Time Search and improvements to observability and geospatial functionality. AWS Lake Formation and Apache Hive on Amazon EMR – Introduced fine-grained access controls that allow data administrators to define and enforce fine-grained table and column level security for customers accessing data via Apache Hive running on Amazon EMR. Amazon EC2 M1 Mac Instances – You can now update guest environments to a specific or the latest macOS version without having to tear down and recreate the existing macOS environments. AWS Chatbot – Now Integrates With Microsoft Teams to simplify the way you troubleshoot and operate your AWS resources. Amazon GuardDuty RDS Protection for Amazon Aurora – Now generally available to help profile and monitor access activity to Aurora databases in your AWS account without impacting database performance AWS Database Migration Service – Now supports validation to ensure that data is migrated accurately to S3 and can now generate an AWS Glue Data Catalog when migrating to S3. AWS Backup – You can now back up and restore virtual machines running on VMware vSphere 8 and with multiple vNICs. Amazon Kendra – There are new connectors to index documents and search for information across these new content: Confluence Server, Confluence Cloud, Microsoft SharePoint OnPrem, Microsoft SharePoint Cloud. This post shows how to use the Amazon Kendra connector for Microsoft Teams. For a full list of AWS announcements, be sure to keep an eye on the What's New at AWS page. Other AWS News A few more blog posts you might have missed: Women founders Q&A – We’re talking to six women founders and leaders about how they’re making impacts in their communities, industries, and beyond. What you missed at that 2023 IMAGINE: Nonprofit conference – Where hundreds of nonprofit leaders, technologists, and innovators gathered to learn and share how AWS can drive a positive impact for people and the planet. Monitoring load balancers using Amazon CloudWatch anomaly detection alarms – The metrics emitted by load balancers provide crucial and unique insight into service health, service performance, and end-to-end network performance. Extend geospatial queries in Amazon Athena with user-defined functions (UDFs) and AWS Lambda – Using a solution based on Uber’s Hexagonal Hierarchical Spatial Index (H3) to divide the globe into equally-sized hexagons. How cities can use transport data to reduce pollution and increase safety – A guest post by Rikesh Shah, outgoing head of open innovation at Transport for London. For AWS open-source news and updates, here’s the latest newsletter curated by Ricardo to bring you the most recent updates on open-source projects, posts, events, and more. Upcoming AWS Events Here are some opportunities to meet: AWS Public Sector Day 2023 (March 21, London, UK) – An event dedicated to helping public sector organizations use technology to achieve more with less through the current challenging conditions. Women in Tech at Skills Center Arlington (March 23, VA, USA) – Let’s celebrate the history and legacy of women in tech. The AWS Summits season is warming up! You can sign up here to know when registration opens in your area. That’s all from me for this week. Come back next Monday for another Week in Review! — Danilo View the full article

Amazon Aurora now supports R6i instances powered by 3rd generation Intel Xeon Scalable processors. R6i instances are the 6th generation of Amazon EC2 memory optimized instances, designed for memory-intensive workloads. These instances are built on the AWS Nitro System, a combination of dedicated hardware and lightweight hypervisor, which delivers practically all of the compute and memory resources of the host hardware to your instances. R6i instances are currently available when using Amazon Aurora PostgreSQL-Compatible Edition. View the full article

AWS Database Migration Service (AWS DMS) has expanded functionality by adding support for Babelfish for Aurora PostgreSQL as a target. Babelfish for Aurora PostgreSQL is a new translation layer for Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for Microsoft SQL Server. Using AWS DMS, you can now perform full load migrations to Babelfish for Aurora PostgreSQL with minimal downtime. View the full article

Amazon Aurora PostgreSQL-Compatible Edition now supports PostgreSQL major version 14 (14.3). PostgreSQL 14 includes performance improvements for parallel queries, heavily-concurrent workloads, partitioned tables, logical replication, and vacuuming. PostgreSQL 14 also improves functionality with new capabilities. For example, you can cancel long-running queries if a client disconnects and you can close idle sessions if they time out. Range types now support multiranges, allowing representation of non-contiguous data ranges, and stored procedures can now return data via OUT parameters. This release includes new features for Babelfish for Aurora PostgreSQL version 2.1. Please refer to Amazon Aurora PostgreSQL updates for more information. View the full article

Amazon Aurora Serverless v1 now supports in-place upgrade from MySQL 5.6 to 5.7. Instead of backing up and restoring the database to the new version, you can upgrade with just a few clicks using the Amazon RDS Management Console or using the latest AWS SDK or CLI. No new cluster is created in the process which means you keep the same endpoints and other characteristics of the cluster. The upgrade completes in minutes as no data needs to be copied to a new cluster volume. The upgrade can be applied immediately or during the maintenance window. Your database cluster will be unavailable during the upgrade. Review the Aurora documentation to learn more. View the full article

Following the announcement of updates to the PostgreSQL database by the open source community, we have updated Amazon Aurora PostgreSQL-Compatible Edition to support PostgreSQL 13.7, 12.11, 11.16, and 10.21. These releases contain bug fixes and improvements by the PostgreSQL community. Refer to the Aurora version policy to help you to decide how often to upgrade and how to plan your upgrade process. View the full article

Amazon Aurora PostgreSQL-Compatible Edition now supports the Large Objects (LO) module. The LO module provides support for managing Large Objects (also called LOs or BLOBs). View the full article

Amazon Aurora PostgreSQL-compatible edition now supports zero-downtime patching (ZDP). With ZDP, customers can upgrade to a new PostgreSQL version and apply patches to their Aurora cluster without any downtime. View the full article

AWS Graviton2-based database instances are now available in preview for Amazon Aurora with PostgreSQL compatibility and Amazon Aurora with MySQL compatibility. Graviton2 instances are already generally available for Amazon RDS for MySQL, Amazon RDS for PostgreSQL, and Amazon RDS for MariaDB. View the full article

Amazon Aurora with PostgreSQL compatibility can now make calls to AWS Lambda functions. AWS Lambda lets you run code without provisioning or managing servers, and without worrying about scalability. View the full article

Following the announcement of updates to the PostgreSQL database by the open source community, we have updated Amazon Aurora with PostgreSQL compatibility to support PostgreSQL versions 11.9, 10.14, and 9.6.19. These releases contain bug fixes and improvements by the PostgreSQL community. View the full article

Amazon Aurora Serverless v1 with PostgreSQL compatibility is now available in Asia Pacific (Singapore), Asia Pacific (Sydney) Asia Pacific (Seoul), Asia Pacific (Mumbai), Canada (Central), Europe (London), Europe (Paris), and US West (N. California) regions. View the full article

Amazon RDS Performance Insights supports additional dimensions to identify the source of high-frequency, long-running, and stuck SQL queries faster. The new Performance Insights dimensions are available on Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility. View the full article

Amazon RDS Performance Insights supports an additional dimension to identify the source of high-frequency, long-running, and stuck SQL queries faster. The new Performance Insights dimension is available on Amazon RDS for MySQL, Amazon Aurora with MySQL compatibility, and Amazon RDS for MariaDB. View the full article

AWS Database Migration Service (AWS DMS) has expanded functionality by adding support for Amazon Aurora Serverless (PostgreSQL-compatible edition) as a target. Amazon Aurora Serverless (PostgreSQL-compatible edition) is an on-demand, auto-scaling configuration where the database will automatically start up, shut down, and scale capacity up or down based on your application's needs. Using AWS DMS, you can now perform live migrations from any AWS DMS supported sources to Amazon Aurora Serverless (PostgreSQL-compatible edition) with minimal downtime. View the full article

Patches 1.7.6 / 2.5.6 / 3.2.6 are now available for customers using Amazon Aurora PostgreSQL. For detailed release notes visit our version documentation. You can apply the new patch version in the AWS Management Console, via the AWS CLI, or via the RDS API. For detailed instructions, please see our technical documentation. View the full article

Amazon Aurora now supports T3.large and medium instances as well as R5 class instances in AWS GovCloud (US) Regions. Using T3.large instances with Amazon Aurora is a cost-effective option for smaller workloads such as test, development, and QA, while still giving you the option to use larger class instances for production deployments. View the full article

Starting today, Amazon Aurora Global Database is expanding its manageability capabilities to more closely match the in-region versions of Aurora. Fast Database Cloning and AWS CloudFormation are both supported. View the full article

Amazon Aurora with PostgreSQL compatibility now supports importing data stored in Amazon Simple Storage Service (S3) buckets to PostgreSQL tables in AWS GovCloud (US) Regions. A new extension, aws_s3, has been added to perform the import operation. You can import any data format that is supported by the PostgreSQL COPY command, using the ARN role association method or using Amazon S3 credentials. View the full article

Amazon Aurora with PostgreSQL compatibility now supports PostgreSQL minor versions 10.12 and 9.6.17 in AWS GovCloud (US) Regions. These releases contains bug fixes and improvements from the PostgreSQL community, as well as bug fixes and improvements specific to Amazon Aurora for PostgreSQL. View the full article

You can now create Amazon Aurora PostgreSQL read replicas for Amazon RDS for PostgreSQL instances in AWS GovCloud (US) Regions. This helps minimize downtime when migrating live workloads from Amazon RDS for PostgreSQL to Amazon Aurora for PostgreSQL, keeping instances in sync until you're ready to move your applications and users to Amazon Aurora for PostgreSQL. View the full article

The storage space allocated to your Amazon Aurora database cluster will now dynamically decrease when you delete data from the cluster. The storage space already automatically increases up to a maximum size of 128 tebibytes (TiB), and will now automatically decrease when data is deleted. You only pay for the storage you use. Starting September 21, 2020, dynamic resizing for storage space is being enabled region by region for Aurora MySQL versions 1.23 and 2.09, and Aurora PostgreSQL versions 10.13 and 11.8, and is expected to be enabled across all Aurora regions by end of November 2020. View the full article

Amazon Aurora now supports Database Activity Streams in the South America (Sao Paulo), Middle East (Bahrain), Africa (Cape Town), and Europe (Milan) regions. Database Activity Streams for Amazon Aurora with MySQL compatibility and Amazon Aurora with PostgreSQL compatibility provides a near real-time stream of database activities in your relational database. When integrated with third party database activity monitoring tools, Database Activity Streams can monitor and audit database activity to provide safeguards for your database and help you meet compliance and regulatory requirements. View the full article