Support
USA
Contact Us
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.

About Ian Lewis

Ian is a Solution Architect specializing in migrating customer workloads into the public cloud. With over 25 years of experience in the IT field, he has worked in government, financial, telecoms, retail and banking sectors with a wide exposure to many different business and technical environments. Prior to joining Navisite, Ian worked at companies ranging from start-ups to Big-5 global consultancies and spent many years as a freelance consultant. Ian's diverse background enables him to understand and deliver genuine value to Navisite's customers. Ian is an AWS certified Solution Architect - Professional and runs Well-Architected Reviews and AWS Immersion days globally. He is based in London.