AWS Database Blog

Get started with the Multi-Tenant feature of Amazon RDS for Oracle

Many organizations have a large number of Oracle databases running on multiple physical servers or virtual machines. They invest substantial resources in the operation and administration of these databases, incurring expenses for infrastructure, management, and licensing. In many cases, these physical servers and virtual machines are under-utilized due to improvements in hardware technology, increase in […]

Create and run AWS DMS tasks using AWS Step Functions

AWS Database Migration Service (AWS DMS) is a managed service that helps you migrate databases to AWS easily and securely. It supports various database sources and targets, including Amazon Relational Database Service (Amazon RDS), Amazon Aurora, Amazon Redshift, Amazon Simple Storage Service (Amazon S3), and more. With AWS DMS, you can migrate your data to […]

Create a Virtual Knowledge Graph with Amazon Neptune and an Amazon S3 data lake

It’s common in an enterprise for data that logically fits together to be separated into different databases. Some data is better suited for one storage than another, and it may not be feasible to locate all your data in one data store. But this data often needs to be linked back together to provide a […]

Understand and optimize replication for Amazon Redshift with AWS DMS

In this post, we deep dive into using AWS Database Migration Service (AWS DMS) to load data to Amazon Redshift and discuss how to optimize data loading. In a world where data is always growing and larger datasets need to be processed, it’s important to use the right tool for the right job. Amazon Redshift […]

Migrate tables from Microsoft Access to Amazon RDS for MySQL

Microsoft Access can fulfill your small-scale database needs, but you may encounter limitations related to scalability, reliability, security, and performance as the data grows. For instance, state and local government entities often employ Microsoft Access for tasks like inventory management and timesheet maintenance. As data volume expands, you might consider transitioning to a more robust […]

Predictive Analytics with Time-series Machine Learning on Amazon Timestream

Capacity planning for large applications can be difficult due to constantly changing requirements and the dynamic nature of modern infrastructures. Traditional reactive approaches, for instance, relying on static thresholds for some DevOps metrics like CPU and memory, fall short in such environments. In this post, we show how you can perform predictive analysis on aggregated […]

Monitor Amazon Aurora Global Database replication at scale using Amazon CloudWatch Metrics Insights

Amazon Aurora is a high-performance, fully managed relational database service offered by AWS. It is compatible with MySQL and PostgreSQL, providing exceptional scalability, availability, and durability for your data. Amazon Aurora Global Database allows you to replicate up to five different AWS Regions and provides robust disaster recovery capabilities. To ensure the resilience and recovery […]

Use Amazon RDS Proxy and AWS PrivateLink to access Amazon RDS databases across AWS Organizations at American Family Insurance Group

The American Family Insurance Group of companies includes American Family Insurance, CONNECT (powered by American Family Insurance), The General, Homesite, and Main Street America Insurance. It is the nation’s twelfth-largest property and casualty insurance group, ranking number 301 on the Fortune 500 list. Across these companies, the group has nearly 13,000 employees nationwide. The group […]

Perform near real time analytics using Amazon Redshift on data stored in Amazon DocumentDB

In this post, we learn how to stream data from Amazon DocumentDB (with MongoDB compatibility) to Amazon Redshift, unlocking near-real-time analytics and insights. We cover using Amazon DocumentDB change streams and Amazon Redshift streaming ingestion, along with AWS Lambda and Amazon Kinesis Data Streams. We also provide an AWS CloudFormation template for easy deployment of […]

Connect external applications to an Amazon RDS instance using Amazon RDS Proxy

Amazon RDS Proxy is a fully managed, highly available database proxy for Amazon Relational Database Service (Amazon RDS) that makes applications more scalable, more resilient to database failures, and more secure. With RDS Proxy, you can handle unpredictable surges in database traffic that might otherwise cause issues due to oversubscribing connections or creating new connections […]