AWS Database Blog
Load RDF data into Amazon Neptune with AWS Glue
In this post, we present a design for a common technical requirement: ingest data from multiple sources to a target Resource Description Framework (RDF) graph database. Our target is Amazon Neptune, a managed graph database service. RDF is one of two graph models supported by Neptune. The other is Labeled Property Graph (LPG). Each graph […]
Optimize the storage costs of your workloads with Amazon DynamoDB Standard-IA table class
You can use Amazon DynamoDB to build internet-scale applications that support user-content metadata and caches that require high concurrency and connections for millions of users and millions of requests per second using the default DynamoDB Standard table class. For example, Amazon.com uses DynamoDB to deliver consistently low latency for mission critical and extreme-scale events such […]
Security best practices for Amazon RDS for MySQL and MariaDB instances
At AWS, cloud security is the highest priority. The implementation of security and compliance is a shared responsibility. While AWS is responsible for the security of the cloud, it provides multiple features to help you manage the security of your databases in the cloud. For example, you can integrate services like AWS Identity and Access […]
Introducing token-based access to Ethereum node APIs on Amazon Managed Blockchain
On October 22, 2022, Amazon Managed Blockchain for Ethereum launched an alternative way for interoperable access to Ethereum nodes JSON-RPC APIs for HTTPs and secure WebSockets using token-based access. In this post we demonstrate how to deploy an Ethereum node and access its JSON-RPC APIs using an accessor token. Managed Blockchain is a fully managed […]
Increase write throughput on Amazon RDS for MariaDB using the MyRocks storage engine
In 2022, Amazon Relational Database Service (Amazon RDS) for MariaDB introduced several new features to enhance the performance, scalability, reliability, and manageability of your workloads, including the MyRocks storage engine, AWS Identity and Access Management (IAM) integration, delayed replication, and multi-major upgrades. Open-source database engines like MySQL and MariaDB implement a pluggable storage engine architecture. […]
Federated query support between SQL Server and Amazon Aurora PostgreSQL
When you have a business need to integrate the data between Microsoft SQL Server and Amazon Aurora PostgreSQL-Compatible Edition, you can use the open-source TDS_FDW PostgreSQL extension to create federation between these two databases. With TDS_FDW with Aurora PostgreSQL-Compatible, you can modernize and extend the functionality of your existing applications to meet changing business needs. […]
Your guide to Amazon DynamoDB sessions at AWS re:Invent 2022
AWS re:Invent 2022 is almost here! This post includes a complete list of sessions dedicated to Amazon DynamoDB at re:Invent, November 28 through December 2, 2022. Use the information on this page to help schedule your conference week in Las Vegas this year. Keynotes and leadership sessions Swami Sivasubramanian, Vice President of AWS Data and […]
A serverless architecture for analyzing PostgreSQL logs with pgBadger
PostgreSQL is one of the most popular open-source relational database systems. AWS offers services that make PostgreSQL database deployments easy to set up, manage, and scale in a cost-efficient manner. These services are Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition. Optimizing database performance is an important task for DevOps […]
Back up an AWS DMS task using the AWS CLI and a JSON processor
In this post, we demonstrate how to use the AWS Command Line Interface (AWS CLI) and jq (a JSON processor) to back up AWS Database Migration Service (AWS DMS) task settings and other artifacts to a file. This backup file could be modified (if required) and reused to setup a new AWS DMS task. One […]
Use vertical partitioning to scale data efficiently in Amazon DynamoDB
Amazon DynamoDB is a fully managed and serverless NoSQL cloud database service that provides consistent performance at any scale, with zero-downtime for maintenance or scaling. While there is a maximum item size of 400 KB (inclusive of both attribute names and values), you can use a technique called vertical partitioning to scale your data beyond […]