AWS Database Blog

Image

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
Image

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
Image

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
Image

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
Image

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

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 new feature provides a […]

Read More
Image

Near real-time processing with Amazon Kinesis, Amazon Timestream, and Grafana

As organizations adopt and deploy home-connected smart devices, they face challenges utilizing device telemetry data in narrow and broad contexts. Examples of such home-connected devices are smart meters and home sensors that emit telemetry and measurements as time series data. In a narrow context, operational teams use data to understand if devices are operating within […]

Read More
Image

Automate post-database creation scripts or steps in an Amazon RDS for Oracle database

In some cases, Database Administrators (DBAs) need to run post-database creation steps such as running SQL statements for creating users and database objects, resetting passwords, or standardizing Oracle database builds. This is mainly done during the database creation phase of new application deployment or during database refreshes that occur in non-production environments. AWS CloudFormation gives […]

Read More
Image

Reduce cost and boost throughput with Global Datastore for Amazon ElastiCache for Redis

Amazon ElastiCache for Redis is a Redis-compatible, fully managed caching service. ElastiCache for Redis helps you achieve extreme performance with microsecond latency at cloud scale with minimal management costs. Global Datastore is a feature of ElastiCache for Redis that provides fully managed, fast, reliable, and secure Cross-Region Replication. With Global Datastore, you can write to […]

Read More
Image

Validate Native Network Encryption on Amazon RDS for Oracle

Many organizations go through auditing, and have to meet auditing compliance policies that require data to be encrypted over the network from application servers to the database server. Oracle Database provides two types of network security encryption methods: native network encryption (NNE) and Secure Sockets Layer (SSL). Amazon RDS for Oracle supports both types of […]

Read More
Image

Migrate Azure SQL Database to Amazon Aurora using Azure Data Sync Agent and AWS DMS

Increasingly, customers are looking to break free from their legacy database (e.g., Oracle and Microsoft SQL Server) and move to a cloud-native database such as open-source engines running on AWS. One of the preferred destinations for this data is Amazon Aurora. In this post, we walk through a migration of a Microsoft Azure SQL database […]

Read More