AWS Database Blog
Category: Learning Levels
Migrate or upgrade your like-to-like databases using AWS DMS homogeneous migration
In this post, we highlight common challenges encountered during homogeneous database migrations and how using AWS DMS homogeneous migration can help address them.
Visualize vector embeddings stored in Amazon Aurora PostgreSQL and explore semantic similarities
In this post, we show how you can visualize vector embeddings and explore semantic similarities. We use PCA for dimensionality reduction. PCA is a well-known dimensionality reduction technique that transforms high-dimensional data into a lower-dimensional space while preserving as much of the original variance as possible. By projecting data onto orthogonal axes called principal components, PCA enables you to visualize the underlying structure of the data in a more manageable form
Evaluating the right fit for your Amazon Aurora workloads: provisioned or Serverless v2
In this post, we cover important concepts of Aurora provisioned and Aurora Serverless v2 databases including cost, performance, features, and how to determine which to use for your workload type.
Build containerized applications for Amazon DocumentDB that run on Amazon ECS on AWS Fargate
In this post, we explore the fundamentals of building containerized applications for Amazon DocumentDB using Quarkus with the Panache ORM library. We cover the processes of containerizing your code, building an image, and deploying it using Amazon ECS with AWS Fargate.
How Scopely scaled “Stumble Guys” for millions of players around the globe with Amazon RDS for SQL Server
Scopely is a global games developer, operator, and publisher with operations across North America, Central America, EMEA, and Asia, and additional studio partners spanning four continents. Over the past year, Scopely has served more than 500 million players with major titles such as “MONOPOLY GO!,” “Stumble Guys,” “MARVEL Strike Force,” “Star Trek Fleet Command,” and “Scrabble GO.” In this post, we showcase how Scopely used CloudBasix to enable migration of “Stumble Guys” high-volume backend transactional databases with minimal downtime from Azure SQL database to Amazon RDS for Server.
Amazon RDS Custom for SQL Server now supports Windows Authentication for DB instances
Amazon RDS Custom for SQL Server now allows you to directly join your DB instances to the domains of Microsoft Active Directory (AD). In this post, we show how to join RDS Custom DB instances to an AD for Windows Authentication. This applies to AD domains running in a self-managed environment either on premises or Amazon Elastic Compute Cloud (Amazon EC2) and AWS Managed Microsoft AD.
Automatic reconnection to Amazon RDS for Oracle read replicas during disaster recovery
Amazon RDS for Oracle offers ease of operability, maintenance, scalability, and reliability while migrating Oracle workloads to AWS. The read replica in Amazon RDS for Oracle is a physical copy of the primary database that can be set up either in mounted or read-only mode. In mounted mode, the replica instance isn’t open for read operations, however in read-only mode, it allows read operations on the replica instance. During managed Oracle Data Guard Switchover with Oracle RDS for Oracle, the database role reversal takes place between the RDS for Oracle primary database and its replica. Similarly, in case of a disaster, you can promote the read replica to a standalone instance. In both scenarios, the application needs to point to the endpoint of the new primary database to establish connectivity. In this post, we provide guidance to configure the automatic reconnection of the application to a standby database during a disaster recovery incident while using replication with Oracle Data Guard using Oracle services and a TNS names connection alias.
Troubleshoot INCOMPATIBLE_CREATE issues due to missing instance profile permissions during Amazon RDS Custom instance creation
In this post, we discuss how to determine the causes of an INCOMPATIBLE_CREATE state of an RDS Custom instance because of incorrect instance profile permissions.
Use IAM authentication with Amazon DocumentDB (with MongoDB compatibility)
Amazon DocumentDB now supports authentication of database users using IAM – users and applications can authenticate to Amazon DocumentDB clusters using IAM users and roles. In this post, we discuss this new feature and provide you resources on how to enable IAM authentication in your Amazon DocumentDB cluster.
Migrating tables from IBM Db2 for z/OS to Amazon RDS for Db2
Amazon RDS for Db2 is the latest addition to the Amazon RDS family of database engines. When it comes to selecting the relational database to migrate data from Db2 for z/OS, RDS for Db2 provides the best compatibility among other relational database management systems (RDBMSs) thereby minimizing the migration effort and timelines. In this post, we outline the migration methodology for converting schema and data from Db2 on z/OS to RDS for Db2.