Mysql – How to calculate AWS RDS Data Transfer Pricing

Changing Instance Class:

From the documentation "Modifying a DB Instance and Using the Apply Immediately Parameter", changing the instance class and setting "Apply Immediately" to false will result in:

• The change being applied during the next maintenance window.
• The change causing an outage to occur.

Since the instance is Multi-AZ and you're changing the instance class, your outage will be minimized to the amount of time it takes to failover to the standby replica. That isn't very long; likely worst-case a minute or two. You won't lose data that is already in the DB. Any existing connections will be dropped during failover. You should verify that applications connected to your database can withstand these conditions, or alternatively take them down for maintenance during this time.

Identifying RDS instance storage capacity:

You can identify how much of the RDS storage is currently in use by either:

1) Simply selecting your RDS instance from the RDS web console and viewing the "Storage" bar under the "Monitoring" header.

2) Viewing the "FreeStorageSpace" RDS cloudwatch metric for your RDS instance.

Further Reading:

• RDS Documentation - Viewing DB Instance Metrics

You can use several ETL tools for this, it could be on premies, or cloud based, final decision always depends from cost, corporate standards and many other moments

good starting point as most close to Your request:

• Informatica Cloud - https://marketplace.informatica.com/mpresources/docs/Implementing_DWH_on_AWS_in_Hybrid_Env.pdf
• Talend Cloud - https://www.talend.com/products/integration-cloud
• Community version of Talend as well could be installed on any VPS and connect to cloud databases

Any tools and recommendations always depends from personal experience and of course on the market You can find more commercial and open source tools