AWS Database Blog
Category: Amazon Aurora
Achieve cost-effective multi-Region resiliency with Amazon Aurora Global Database headless clusters
Many organizations with critical workloads and global footprints need a strategy to tolerate Region-wide outages. This requires making a trade-off between availability, Recovery Time Objective (RTO), and cost. You should consider using a tiered approach to meet your compliance and budgetary needs. When developing a cross-Region disaster recovery (DR) strategy, an important consideration is the […]
Read MoreAutomate interval partitioning maintenance, and monitoring in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL
Modernizing database workloads and architecture is the optimal way to increase efficiencies and reduce licensing and infrastructure costs. To achieve this, you can use an Amazon Aurora relational database to break free from legacy database solutions. Several large-scale companies are migrating Oracle databases to Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora […]
Read MorePostgreSQL psql client tool commands equivalent to Oracle SQL*Plus client tool
When you’re working as an application developer or database administrator, you often need to deal with SQL statements to explore your database for various reasons. You need to connect to the database to build or run the SQL code, generate reports, and diagnose application problem related to the database. There are various ways to connect […]
Read MoreAmazon Aurora PostgreSQL blue/green deployment using fast database cloning
In a traditional approach to application deployment, you have no real opportunity to validate new versions or features in a realistic, live deployment while continuing to run the old version in production environment. In some situations, recovering from a failed upgrade or failures in the schema modification process can impact your production environment, which in […]
Read MoreMigrate self-managed MariaDB to Amazon Aurora MySQL
Amazon Aurora is a fully managed MySQL and PostgreSQL-compatible relational database, offered as part of the Amazon Relational Database Service (Amazon RDS). With a managed service like Aurora, customers can free their teams from time-consuming database tasks like server provisioning, patching, and backups. Amazon Aurora provide continuous monitoring, self-healing storage, and automated scaling to help […]
Read MoreScale applications using multi-Region Amazon EKS and Amazon Aurora Global Database: Part 1
AWS offers a breadth and depth of services that helps you run and scale your critical workloads in multiple Regions on AWS’ global footprint. Whether you need a multi-Region architecture to support disaster recovery or bring your applications and the backend database into close proximity to your customers to reduce latency, AWS gives you the […]
Read MoreSchema and code validator for Oracle to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL migration
Database migration is a sequence of steps from assessment through cutover. One of the key challenges that a migration engineer or an application team may face is validating the migrated database objects like tables, indexes, constraints, procedures, and functions. It is a time-consuming manual task to validate database objects during heterogeneous migration. You have to […]
Read MoreDeploy Amazon RDS databases for applications in Kubernetes
The Kubernetes container orchestration system provides numerous resources for managing applications in distributed environments. Many of these applications need a searchable storage system for their data that is secure, durable, and performant. Developers want to focus on continuously improving their apps rather than having to worry about the operational functions of their databases. They also […]
Read MoreProfile Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL PL/pgSQL code using plprofiler
PostgreSQL is considered to be the primary open-source database choice when migrating from commercial databases such as Oracle. AWS provides two managed PostgreSQL options: Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition. Identifying slow queries and tuning for better performance is an important task for developers and database administrators managing […]
Read MoreHidden dangers of duplicate key violations in PostgreSQL and how to avoid them
A common coding strategy is to have multiple application servers attempt to insert the same data into the same table at the same time and rely on the database unique constraint to prevent duplication. The “duplicate key violates unique constraint” error notifies the caller that a retry is needed. This seems like an intuitive approach, […]
Read More