AWS Database Blog

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 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 total storage space by […]

Read More

Use Key Management Service (AWS KMS) to securely manage Ethereum accounts: Part 2

Ethereum is a popular public blockchain that makes it possible to create unstoppable applications in a permissionless fashion. It’s available to every user that has an Ethereum account. These Ethereum accounts consist of a private and an associated public key. The main challenge as a user participating in a public blockchain such as Ethereum is […]

Read More

Use Key Management Service (AWS KMS) to securely manage Ethereum accounts: Part 1

Ethereum is a popular public blockchain that makes it possible to create unstoppable applications in a permissionless fashion. It’s available to every user that has an Ethereum account. These Ethereum accounts consist of a private and an associated public key. The main challenge as a user participating in a public blockchain such as Ethereum is […]

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 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 servers. Solution overview DRCP […]

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