Category: Advanced (300)

Amazon Relational Database Service (Amazon RDS) makes it simple to set up, operate, and scale a relational database in AWS Cloud. Amazon RDS Custom is a new deployment type that provides granular control capabilities that enable you to access and customize the database environment, and provides an operating system that allows you to run third-party […]

Database audit logs are records of activities and events that occur within a database system. These logs capture details about user interactions, system changes, and data modifications, providing a comprehensive trail of actions performed on the database. By maintaining a meticulous record of these activities, organizations gain valuable insights into who accessed the database, what […]

When migrating your database to the cloud, you should prepare a failback plan (or recovery plan) if the migration fails. To provide failback functionality, AWS Database Migration Service (AWS DMS) supports reverse replication, which you can use as a minimal downtime failback strategy while migrating from Oracle on premises to Amazon Relational Database Service (Amazon […]

Amazon Relational Database Service (Amazon RDS) for MySQL now supports the Group Replication plugin for active/active replication. You can use the plugin to set up active/active replication between your RDS for MySQL database instances to provide continuous availability for your applications. Writing to two or more database instances in an active/active cluster can help maximize […]

Organizations are migrating their Microsoft SQL Server workloads to AWS managed database services like Amazon Relational Database Service (Amazon RDS) for SQL Server or Amazon RDS Custom for SQL Server, which makes it easy to set up, operate, and scale SQL Server deployments in the cloud. Customers often ask us how they can optimize SQL […]

In this post, we explore how to use ProxySQL to achieve a downtime of typically 1 second or less when performing a minor version upgrade on Amazon RDS for MySQL Multi-AZ deployments with two readable standbys (Amazon RDS Multi-AZ DB cluster). ProxySQL is an open source proxy for MySQL. Currently, minor version upgrades or system […]

When upgrading minor versions of RDS Multi-AZ clusters the connections are switched from the current writer to a newly upgraded reader. Clients have the option to connect to either the cluster writer endpoint or the cluster reader endpoint. Normally, they would connect to the writer endpoint. This endpoint is directed to the current writer instance. […]

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports Microsoft SQL Server 2022 for Express, Web, Standard, and Enterprise Editions. You can use SQL Server 2022 features such as accelerated database recovery, intelligent query processing, intelligent performance, monitoring improvements, and resumable online index creations. In this post, we summarize the new features on […]

In this post, we demonstrate how to modify the Amazon Aurora reader auto scaling configuration on a schedule using AWS Application Auto Scaling, on top of the existing auto scaling policies. When your application grows, the load on your database will most likely grow as your application saves larger amounts of data. Whether it’s the […]

Amazon Relational Database Service (Amazon RDS) Custom is a managed database service that automates the setup, operation, and scaling of databases in the cloud while granting you access to the underlying operating system and database environment. You can provision a Multi-AZ Amazon RDS Custom for SQL Server instance for a highly available environment with automatic […]