March 18, 2020

AWS Product News – Amazon Redshift expands, Amazon RDS on MySQL and Amazon Aurora with PostgreSQL compatibility

Ian Lewis

Here’s an update on recent news from AWS. This week, Amazon Redshift adds a materialized view feature, Amazon RDS Performance Insights supports Amazon RDS for MySQL Version 8, and Amazon Aurora with PostgreSQL compatibility supports Amazon Aurora Database.

  • Amazon Redshift now supports materialized views functionality. Materialized views provide significantly faster query performance for repeated and predictable analytical workloads such as dashboarding, queries from business intelligence tools and ELT (Extract, Load, Transform) data processing. Read more here.

Why it matters: This new feature allows customers to significantly improve query performance of often executed queries and reduce database utilization. These technical benefits allow customer reports to run faster and for less cost than they do today. 

  • Amazon RDS Performance Insights now supports Amazon RDS for MySQL Version 8. Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS that helps you quickly assess the load on your database and determine when and where to take action.

Why it matters: Monitoring is key to any successful IT operations team. Performance Insights will allow customers to closely monitor and tune the database operations of their Amazon RDS MySQL 8.0 instances.

  • Amazon Aurora Global Database is now available for the PostgreSQL-compatible edition of Amazon Aurora. Aurora Global Database is designed for applications with a global footprint, allowing a single Aurora database to span multiple AWS regions with as many as five secondary regions. Read more here.

Why it matters: Amazon Aurora provides up to five times better performance than the typical MySQL database and three times better performance than PostgreSQL, together with increased scalability, durability, and security.

If you have any questions about these product updates and how we can help optimize your AWS environment, please contact us at hello@navisite.com.

We’ll be back next week with another update.