We have setup a highly available ArcGIS Server site in a DMZ network architecture using Esri's CloudFormation template on AWS, with a RDS Postgresql database. The ArcGIS Server instances are in an auto-scaling group where we can configure to scale in or out. But for the RDS, are there any issues with scaling the RDS horizontally or vertically, in terms of compatibility with ArcGIS Server?
Is it as easy as changing the RDS to a more powerful instance type??