The AWS Advanced NodeJS Wrapper has support for Amazon RDS Multi-AZ DB Cluster Deployments. By leveraging the topology information within the RDS Multi-AZ DB Cluster, the wrapper is capable of switching over the connection to a new writer host in approximately 1 second or less, given there is no replica lag during minor version upgrades or OS maintenance upgrades.
The process of using the AWS Advanced NodeJS Wrapper with RDS Multi-AZ DB Clusters is the same as using it with an RDS Aurora cluster. All properties, configurations, functions, etc., remain consistent. Instead of connecting to a generic database endpoint, replace the endpoint with the Cluster Writer Endpoint provided by the RDS Multi-AZ DB Cluster.
To prepare a connection with MySQL in a Multi-AZ Cluster, please refer to this example.
The topology information is populated in Amazon RDS for PostgreSQL versions 13.12, 14.9, 15.4, or higher, starting from revision R3. Ensure you have a supported PostgreSQL version deployed.
Per AWS documentation, the rds_tools extension must be manually installed using the following DDL before the topology information becomes available on target cluster:
CREATE EXTENSION rds_tools;To prepare a connection with PostgreSQL in a Multi-AZ Cluster, please refer to this example.
Amazon RDS Multi-AZ with two readable standbys supports minor version upgrades with 1 second of downtime.
See feature announcement here.
During minor version upgrades of RDS Multi-AZ DB clusters, the failover plugin switches the connection from the current writer to a newly upgraded reader. If minimizing downtime during switchover is critical to your application, consider adjusting the failoverClusterTopologyRefreshRateMs to a lower value such as 100ms, from the default 2000ms. However, be aware that this can potentially increase the workload on the database during the switchover.
For more details on the failover plugin configuration, refer to the Failover Configuration Guide.
The following plugins have been tested and confirmed to work with Amazon RDS Multi-AZ DB Clusters:
The compatibility of other plugins has not been tested at this time. They may function as expected or potentially result in unhandled behavior. Use at your own discretion.