AWS Database Blog

Category: Compute

Running AWS Lambda-based applications with Amazon DocumentDB

Microservices-based applications architectures are the norm for building scalable applications. AWS makes creating these types of applications easier with Amazon DocumentDB (with MongoDB compatibility). Just bring your code and deploy an application with this fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. You can use the same MongoDB application […]

Read More

Best storage practices for running production workloads on hosted databases with Amazon RDS or Amazon EC2

AWS offers multiple options to host your databases serving OLTP workloads – host your own managed database on Amazon EC2 instances or use Amazon RDS managed by AWS. RDS manages high availability, automated backups, database upgrades, OS patches, security, and read replica. RDS also offers the cloud-native option Amazon Aurora database engine, which is compatible […]

Read More

Upgrade your end-of-support SQL Server instances in VMware Cloud on AWS with ease

If you still have Microsoft SQL Server 2008 and 2008 R2 instances deployed, now is the time to upgrade them. Microsoft end of support (EoS) date for each is almost upon us—July 9, 2019. This means that after that there are no further security updates, which has security and also compliance implications, so don’t wait! Today, I’m excited […]

Read More

Running highly available Microsoft SQL Server containers in Amazon EKS with Portworx cloud native storage

In this blog post, we explain the deployment of Microsoft SQL Server on containers using Amazon Elastic Container Service for Kubernetes (Amazon EKS). The same approach and principles discussed here also apply to any other stateful application that needs high availability (HA) and durability combined with a reusable and repeatable DevOps practice. Example use cases […]

Read More

How to manage AWS Auto Scaling policies easily with tag-based scaling plans

AWS Auto Scaling can scale your AWS resources up and down dynamically based on their traffic patterns. However, a typical application stack has many resources, and managing the individual AWS Auto Scaling policies for all these resources can be an organizational challenge. With scaling plans, you can automate the creation of AWS Auto Scaling policies […]

Read More

Stream changes from Amazon RDS for PostgreSQL using Amazon Kinesis Data Streams and AWS Lambda

In this post, I discuss how to integrate a central Amazon Relational Database Service (Amazon RDS) for PostgreSQL database with other systems by streaming its modifications into Amazon Kinesis Data Streams. An earlier post, Streaming Changes in a Database with Amazon Kinesis, described how to integrate a central RDS for MySQL database with other systems […]

Read More

How to configure SQL Server 2017 on Amazon Linux 2 and Ubuntu AMIs

When you deploy Microsoft SQL Server on AWS, you have many choices for how to optimize the performance, availability, reliability, and costs of your applications. Amazon offers multiple SQL Server versions, broad compute options, and numerous licensing options to optimize usage and reduce costs. You can choose the pay-as-you-go model and use the AWS license-included […]

Read More

How to architect a hybrid Microsoft SQL Server solution using distributed availability groups

Migrating monolithic mission-critical Microsoft SQL Server databases from on-premises to AWS (that is, to SQL Server based on Amazon EC2) is often a challenging task. The challenge comes mostly from the following: A prolonged downtime window during cutovers that can have an adverse impact on the business Challenges involved in keeping the databases (both on-premises […]

Read More

Bootstrapping Your Large Production On-Premises SQL Server Databases to Amazon EC2

This blog post explains how to use PowerShell and native Microsoft SQL Server backups to migrate an on-premises SQL Server database to an Amazon EC2 instance. In general, we recommend that where possible you should make every attempt to migrate your on-premises SQL Server databases to Amazon RDS. You can find more details on how […]

Read More

New, Memory-Optimized Amazon EC2 Instance Types Drive Database Workloads

Perfectly sized instances for maximizing Microsoft SQL Server Standard In September, Amazon Web Services announced availability of the new Amazon EC2 x1e.32xlarge instance type with 128 vCPU and 3,904 GiB of memory. Since that announcement, we have heard from customers that they want more instance configuration choices with fewer vCPUs, while maintaining a high ratio […]

Read More