AWS Database Blog
Category: Database
Validate database objects after migrating from IBM Db2 LUW to Amazon RDS for MySQL, Amazon RDS for MariaDB, or Amazon Aurora MySQL
Migrating your database from IBM Db2 LUW to Amazon Relational Database Service (Amazon RDS) for MySQL, Amazon RDS for MariaDB, or Amazon Aurora MySQL-Compatible Edition is a complex, multistage process, which usually includes assessment, database schema conversion, data migration, functional testing, performance tuning, and many other steps spanning across the stages. You can use AWS […]
Read MoreDeploy Amazon ElastiCache for Redis using AWS CDK
Need for Speed—No, it’s not the video game, but rather a critical requirement for the success of your website in this competitive world. Although we might think that subsecond delay is acceptable, the New York Times noted in For Impatient Web Users, an Eye Blink Is Just Too Long to Wait that humans can notice […]
Read MoreReduce read I/O cost of your Amazon Aurora PostgreSQL database with range partitioning
This blog post was last updated June 8, 2022. Amazon Aurora PostgreSQL-Compatible Edition offers a SQL database with enterprise-grade speed, availability, and scale at a cost comparable to open-source databases. With Aurora, you pay for storage I/O operations that you consume. This pay-per-use model makes Aurora low-cost compared to traditional enterprise databases. However, it’s important […]
Read MoreImproved performance for lightweight transactions with Amazon Keyspaces
Amazon Web Services (AWS) customers migrating their Apache Cassandra workloads to Amazon Keyspaces (for Apache Cassandra) have rediscovered Cassandra’s lightweight transactions (LWT) API. Amazon Keyspaces LWTs have consistent performance, reliable scalability, and improved isolation that allow developers to use LWTs with mission critical workloads. With Amazon Keyspaces, LWTs have similar single digit millisecond latencies as […]
Read MoreOptimize application memory usage on Amazon ElastiCache for Redis and Amazon MemoryDB for Redis
Amazon MemoryDB for Redis and Amazon ElastiCache for Redis are in-memory data stores. While ElastiCache is commonly used as a cache, MemoryDB is a durable database designed for applications with high performance requirements. Customers love Redis as an in-memory data engine. As data used and accessed grows exponentially, making the most of the memory available […]
Read MoreUpgrading from Amazon RDS for MariaDB version 10.2
Amazon Relational Database Service (Amazon RDS) for MariaDB 10.2 major version is reaching end of life (EOL) on October 15, 2022. The end-of-life process ends standard support for this version. We recommend that you upgrade all MariaDB 10.2 DB instances to MariaDB 10.3 or higher as soon as possible. Amazon Relational Database Service (Amazon RDS) […]
Read MoreUse native SQL Server log shipping and PowerShell scripts to synchronize data to Amazon RDS for SQL Server
Enterprises are migrating their Microsoft SQL Server workloads to AWS fully managed database services like Amazon Relational Database Service (Amazon RDS) for SQL Server, which makes it easy to set up, operate, and scale SQL Server deployment in the cloud. There are a few native Microsoft SQL Server tools available if you want to migrate your […]
Read MoreUnlocking JSON workloads with ElastiCache and MemoryDB
Application developers love Redis because it has a large and vibrant open source community, provides blazing-fast in-memory performance, and has a developer-friendly yet powerful API that provides native support for multiple data structures. These traits make Redis a great fit for building and running high-performance, scalable web applications. At AWS, we offer two fully-managed, Redis-based […]
Read MorePrepare for Babelfish migration with the AWS SCT assessment report
Database migrations typically consist of converting the database schema and loading the data from the source database to the target database. After the migration, developers still need to change the application to use the target database drivers, and they often need to rewrite the application code to make it all work. With Babelfish for Aurora […]
Read MoreHandle empty strings when migrating from Oracle to PostgreSQL
An Oracle-to-PostgreSQL migration in the AWS Cloud can be a multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. AWS offers services that make PostgreSQL database deployments easy to set up, manage, and scale for the cloud in a cost-efficient manner. These services are Amazon Relational Database Service (Amazon RDS) […]
Read More