AWS Database Blog
Perform Amazon Aurora PostgreSQL minor version upgrades with minimal downtime via minor version update improvements
When using Amazon Aurora PostgreSQL-Compatible Edition, managing updates is an ongoing management process for database administrators. Minor version updates are a component of this process—they contain database patches, and bug fixes are a much more common management task to orchestrate. AWS provides mechanisms that assist in applying updates, but you are able to decide when […]
Track engine version upgrades in Amazon RDS for Oracle using the customer visible events
In Amazon Relational Database Service (Amazon RDS), an RDS event indicates a change in the environment. These events are delivered in real-time to Amazon CloudWatch and Amazon EventBridge. RDS events are notifications that are triggered by specific database events in Amazon RDS. These events can include automated backups, security updates, maintenance windows, and other changes […]
Make configuration changes to an Amazon RDS Custom for Oracle instance: Part 3
With the flexibility of Amazon Relational Database Service (Amazon RDS) Custom for Oracle, you can customize your database, underlying server, and operating system configurations to support the various requirements of your workloads. In this series, we discuss best practices and step-by-step instructions to perform common customizations on Amazon RDS Custom for Oracle without breaking the […]
Federated query support for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL – Part 2
This post is a continuation of Federated query support for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL – Part 1. To recap, in 2003, the SQL standard added a new specification called SQL/MED (SQL Management of External Data). In 2011, PostgreSQL 9.1 was released with read-only support of this standard, and PostgreSQL 9.3 added […]
Code conversion patterns to migrate Sybase SQL Anywhere database schemas to Amazon RDS for SQL Server or Microsoft SQL Server on Amazon EC2
SAP SQL Anywhere (also known as Sybase SQL Anywhere) is a database which is widely used in Information Technology and Services industry. Migration from SAP SQL Anywhere to Amazon Relational Database Service (RDS) for SQL Server or Microsoft SQL Server on Amazon Elastic Compute Cloud (Amazon EC2) is challenging because as of writing this post, […]
Automate high availability setup in Amazon RDS Custom for Oracle
Amazon Relational Database (Amazon RDS) Custom automates database administration tasks and operations. RDS Custom makes it possible for you as a database administrator to access and customize your database environment and operating system. With RDS Custom, you can customize to meet the requirements of legacy, custom, and packaged applications. Amazon RDS Custom for Oracle supports […]
Use Amazon Aurora Global Database to set up disaster recovery within India
Disaster recovery (DR) ensures that businesses can continue to operate in the event of an unexpected disruption, such as a natural disaster, power outage, or cyberattack. Maintaining resilience is key to operational success for your business, and disaster recovery planning plays a vital role in that. Many regulators across multiple industries are mandating disaster recovery […]
Improve query performance and reduce cost using scheduled queries in Amazon Timestream
In this post, we show you how to use scheduled queries in Amazon Timestream to improve your query performance and reduce cost. Scheduled queries make real-time analytics more performant and cost-effective, so you can derive additional insights from your data and continue to make better business decisions. Timestream is a serverless time series database that […]
Accelerate large database migrations to Amazon RDS Custom Oracle using Tsunami UDP
One of the steps in migrating a database to the cloud involves transferring existing data from the source (on premises) to the target (cloud). For medium and large databases, such as those ranging from hundreds of gigabytes to 5 terabytes, speed of data transfer matters. One of the challenges is to minimize the downtime of […]
Building AI-powered search in PostgreSQL using Amazon SageMaker and pgvector
Organizations across diverse sectors are exploring novel ways to enhance user experiences by harnessing the potential of Generative AI and large language models (LLMs). In the fashion industry generative AI is revolutionizing the creative process. By analyzing user preferences and data, AI algorithms can generate unique apparel patterns and designs, bringing a new level of […]