AWS Database Blog

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

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

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

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

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 Relational Database Service (Amazon RDS) for Oracle […]

Read More

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

MYCOM OSI Service Impact Engine migration to Amazon ElastiCache for Redis

This is a guest post by Dirk Michel, SVP, SaaS Technology & Solutions Architecture at MYCOM OSI, in partnership with AWS Solutions Architect Specialist, Zach Gardner. MYCOM OSI offers assurance, automation, and analytics software as a service (Saas) applications for the digital era. The Assurance Cloud Service™ provides critical end-to-end performance, fault and service quality […]

Read More

Introducing binlog I/O cache in Amazon Aurora MySQL to improve binlog performance

Binlog replication is a popular feature serving multiple use cases, including offloading transactional work from a source database, replicating changes to a separate dedicated system to run analytics, and streaming data into other systems, but the benefits don’t come for free. Binary logging can limit database performance (higher commit latency and lower throughput) because the […]

Read More