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 […]
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 […]
Near real-time processing with Amazon Kinesis, Amazon Timestream, and Grafana
August 30, 2023: Amazon Kinesis Data Analytics has been renamed to Amazon Managed Service for Apache Flink. Read the announcement in the AWS News Blog and learn more. 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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Verify delivery conditions with the Accord Project and Amazon Quantum Ledger Database – Part 2
This is part two of the two-part series of blog posts discussing how to apply smart legal contracts technology to verify delivery conditions with open-source Accord Project and Amazon Quantum Ledger Database service. In the first part we introduced the smart legal contract technology, a sample delivery process, and reviewed the solution to run smart legal contracts on AWS with Accord Project. […]