AWS Database Blog
Implementing bulk CSV ingestion to Amazon DynamoDB
June 2023: Amazon DynamoDB can now import Amazon S3 data into a new table. DynamoDB import from S3 helps you to bulk import terabytes of data from Amazon S3 into a new DynamoDB table with no code or servers required. November 2022: This post was reviewed and updated for accuracy. This post reviews what solutions […]
Moving on from Amazon RDS for PostgreSQL Versions 9.4
Historically, the PostgreSQL community releases a new major version yearly, and with that, has a defined end of life (EOL) policy of older major versions. This allows version and upgrade decisions to be made on dates known well into the future. The community EOL policy is to support a major version for 5 years after […]
Introducing role-based access control for Amazon DocumentDB (with MongoDB compatibility)
Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB 3.6 or 4.0 or 5.0 workloads. You can use the same MongoDB application code, drivers, and tools as you do today to run, manage, and scale workloads on Amazon DocumentDB without worrying about the underlying […]
Using $dateFromString and executionStats in Amazon DocumentDB (with MongoDB compatibility)
Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. Amazon DocumentDB makes it easy and intuitive to store, query, and index JSON data. If you are new to Amazon DocumentDB, see Ramping up on Amazon DocumentDB (with MongoDB compatibility). Amazon DocumentDB continues to […]
Graphing investment dependency with Amazon Neptune
Storing and querying investment dependencies as a graph in Amazon Neptune reveals new relationships. EDGAR (Electronic Data Gathering, Analysis, and Retrieval) is an online public database from the U.S. Securities and Exchange Commission (SEC). EDGAR handles automated collection, validation, indexing, acceptance, and submission forwarding by entities that are required by law to file forms with […]
Migrating to Amazon Aurora MySQL with fallback option using GTID-based replication
When migrating production applications, it is often important to have a fallback option. This blog post demonstrates how to use global transaction identifier (GTID)-based replication to migrate Amazon RDS MySQL workloads to Amazon Aurora MySQL. We also discuss how to use a fallback mechanism in case you encounter any issues. For more information about GTID-based […]
Aurora PostgreSQL Disaster Recovery solutions using Amazon Aurora Global Database
Amazon Aurora with PostgreSQL compatibility combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Aurora provides this by scaling storage across three Availability Zones in the same Region, and supports up to 15 read replica instances for scaling out read workloads and high availability within a […]
Ramping up on Amazon DocumentDB (with MongoDB compatibility)
This blog post was last reviewed and updated February, 2022. Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. As a document database, Amazon DocumentDB makes it easy to store, query, and index JSON data. Amazon DocumentDB is compatible with MongoDB 3.6, 4.0 […]
Migrating legacy PostgreSQL databases to Amazon RDS or Aurora PostgreSQL using Bucardo
If you are using PostgreSQL earlier than 9.4, you are using an unsupported version of PostgreSQL, and may have limited options to migrate or replicate your databases in Amazon RDS or Amazon Aurora PostgreSQL. This is primarily because PostgreSQL versions older than 9.4 can’t perform logical replication. Bucardo is an open-source utility that can replicate […]
Validate your expertise in AWS purpose-built databases with new AWS Certification
Today, we are announcing the new AWS Certified Database – Specialty certification, which validates an individual’s expertise in recommending, designing, and maintaining the optimal AWS database solution to improve performance, reduce costs, and enable innovation. This certification is the first to validate technical skill in AWS purpose-built databases. To create new AWS Certifications, we work […]