Category: Best Practices

In Part 1 of this series, we discussed database migration components, migration cost and its factors, and how to select right type of AWS DMS instance which determines the capacity of DMS jobs. In this post, we focus on how to regularly evaluate the AWS DMS instance size and scale up or down based on […]

In the realm of database migration, achieving cost optimization is paramount. It’s not just about moving data; it’s about doing so in a way that ensures every resource is utilized efficiently, infrastructure expenses are minimized, and the return on investment is maximized. Careful consideration of cost implications and the implementation of strategic measures are key. […]

Solana is a public blockchain built for mass adoption. It’s a high-performance network that is utilized for a range of use cases, including finance, NFTs, payments, and gaming. Solana operates as a single global state machine, and is open and interoperable. In this post, we look into the ways Solana blockchain works, the types of […]

Amazon ElastiCache is a fully managed in-memory caching service, compatible with popular open source projects, Redis and Memcached. Hundreds of thousands of customers use it to achieve real-time, cost-optimized performance. We built Amazon ElastiCache Serverless to satisfy some of the most common customer wish-list items, including simplifying the setup process, eliminating capacity planning and management, […]

Amazon Aurora MySQL-Compatible Edition version 3 (with MySQL 8.0 compatibility) is the most current major version supported on Amazon Aurora MySQL. You can use Amazon Aurora MySQL version 3 to get the latest MySQL-compatible features and performance improvements. MySQL 8.0 introduces several new features, including JSON functions, window functions, common table expressions (CTEs), and role-based […]

Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL version 11 end of standard support is February 29, 2024. See the Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL announcements to upgrade your databases: Announcement: Amazon Aurora PostgreSQL 11.x end of support is February 29, 2024 Amazon RDS for PostgreSQL 11 […]

Amazon DynamoDB offers high scalability and performance for applications with varying workloads. While DynamoDB excels at efficiently distributing data across multiple partitions, it inherently follows a specific sorting order based on the schema selected. In this post, we show two example data models, one designed to store e-commerce order information and one to store game […]

This is the first post of a two-part series. In this post, we discuss how to migrate SQL Server indexed views to materialized views in Amazon Aurora PostgreSQL-Compatible Edition or Amazon Relational Database Service (Amazon RDS) for PostgreSQL. The second post in this series will walk you through the migration of SQL Server indexed views […]

Most migrations from on-premises Oracle to Amazon Relational Database Service (Amazon RDS) for Oracle use EXPDP/IMPDB or Transportable Tablespaces using RMAN. Depending on the size and complexity, migrations are often split at the schema level and table level. In this post, we present a solution to help you identify missing schema objects in the target […]

Company policies usually do not allow database instances to have a public endpoint unless there is a specific business requirement. Although that protects those resources from public access over the internet, it also limits how users can connect to them from their computers. Frequently, database administrators and development teams try to overcome that restriction by […]