AWS Database Blog

Category: Database

Set up scheduled backups for Amazon DynamoDB using AWS Backup

With customers scaling up their AWS workloads across hundreds, if not thousands of AWS resources, customers have expressed the need to centrally manage and monitor their backups. They want to have a standardized way to manage their backups at scale. AWS Backup enables you to centralize and automate data protection across AWS services. AWS Backup […]

Read More

Load and unload data without permanently increasing storage space using Amazon RDS for Oracle read replicas

Generally, DBAs use Oracle Data Pump to move data around for activities like migrating existing data from Oracle on-premises to Amazon Relational Database Service (Amazon RDS) for Oracle or refreshing Oracle on-premises by exporting data from Amazon RDS for Oracle. As of this writing, after you create an RDS DB instance, you can’t decrease the […]

Read More

Idea to product: PricewaterhouseCoopers launches Check-In within three months on Amazon Keyspaces

The COVID-19 pandemic presented enterprises with various challenges. Enterprises notably need to safeguard employees, partners, and customers when they return to the office. Holistic workforce strategies require a combination of preventative screening tools and detailed contact tracing solutions. PricewaterhouseCoopers LLP (PwC) quickly responded and adapted to develop Check-In, powered by AWS. Check-In provides companies with […]

Read More

Access Amazon Location Service from Amazon Aurora

Organizations typically store business and customer data in databases like Amazon Relational Database Service (Amazon RDS) and Amazon Redshift, and often want to enrich this data by integrating with external services. One such enrichment is to add spatial attributes such as location coordinates for an address. With the introduction of Amazon Location Service, you now […]

Read More

Implement Oracle Database Resident Connection Pool with Amazon RDS for Oracle

This post describes how to configure Oracle Database Resident Connection Pool (DRCP) in an Amazon Relational Database Service (Amazon RDS) for Oracle environment. You can use DRCP with application servers that can’t do middle-tier connection pooling. You can also use DRCP to manage hundreds or thousands of database connections from clients spread across multiple application […]

Read More

Get started with Amazon ElastiCache for Redis and Memcached: Introducing the ElastiCache learning path

Ready to get started with Amazon ElastiCache? Introducing the new learning path Amazon ElastiCache: In-memory data store fundamentals, use cases, and examples. ElastiCache is a managed in-memory caching service compatible with Redis and Memcached, enabling you to seamlessly set up, run, and scale in-memory data stores in the cloud. In this new learning path, follow […]

Read More

Monitor errors in Amazon Aurora MySQL and Amazon RDS for MySQL using Amazon CloudWatch and send notifications using Amazon SNS

Monitoring databases is essential for any DBA, from dev-test databases to mission-critical databases. You want to capture system and user-defined events for monitoring and troubleshooting problems related to your database instance. MySQL records these events in error logs. In this post, we show you how to monitor different events, such as deadlocks, access denied errors, […]

Read More

Schedule jobs with pg_cron on your Amazon RDS for PostgreSQL or Amazon Aurora for PostgreSQL databases

Scheduling jobs is an important part of every database environment. On a traditional on-premises database, you can schedule database maintenance jobs on the operating system where the database runs. When you migrate your databases to Amazon Relational Database Service (Amazon RDS) or Amazon Aurora, you lose the ability to log in to the host and […]

Read More

Migrate Amazon ElastiCache to Graviton2 processors

In late 2020, we announced the availability of Amazon ElastiCache for Redis and Memcached on Graviton2 M6g and R6g instance families. These instances offer up to 57% better price/performance improvement over previous generation instances. They’re based on AWS-designed AWS Graviton2 processors using 64-bit Arm Neoverse N1 cores. ElastiCache for Redis enhanced I/O handling, Global Datastore, […]

Read More

Managed disaster recovery with Amazon RDS for SQL Server using cross-Region automated backups

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports managed disaster recovery (DR) using Amazon RDS cross-Region automated backups. This feature extends the existing Amazon RDS backup functionality, giving you the ability to set up automatic replication of system snapshots and transaction logs from a primary AWS Region to a secondary Region. The […]

Read More