AWS Database Blog

Category: Compute

Migrating your on-premises SQL Server Windows workloads to Amazon EC2 Linux

For decades, IT administrators could only run their SQL Server workloads on Windows. However, as of SQL Server 2017, SQL Server is now available to run in the Linux operating system. For IT administrators, this represents an opportunity to run SQL Server workloads on their preferred operating system, save on Windows Server licensing costs, and […]

Read More

IAM role-based authentication to Amazon Aurora from serverless applications

Storing user names and passwords directly in applications is not a best practice. Saving credentials as plaintext should never occur in a secure application. As a solution, AWS Identity and Access Management (IAM) policies can assign permissions that determine who is allowed to manage Amazon Aurora resources. For example, you can use IAM to determine […]

Read More

Deploying Always On availability groups between Amazon EC2 Windows and Amazon Linux 2 instances

Microsoft SQL Server 2017 supports Always On availability groups between Windows and Linux to create read-scale workloads without high availability (HA). Unfortunately, you cannot achieve HA between Windows and Linux because there is no clustered solution that can manage that cross-platform configuration. To use HA with Always On availability groups, consider using a Windows Server […]

Read More

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

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