How Mindbody improved query latency and optimized costs using Amazon Aurora PostgreSQL Optimized Reads

Mindbody, a cloud-based technology platform for fitness and wellness, significantly improved database performance and reduced costs by adopting Amazon Aurora PostgreSQL Optimized Reads.

• Initial challenges included slow query execution and high I/O costs on a 17 TB database
• Root cause analysis revealed low buffer cache hit ratio and high storage I/O usage
• Upgraded from PostgreSQL 13.8 to 14.9 using blue/green deployment
• Key performance improvements included:
• 50% reduction in CPU utilization
• 90% reduction in Read IOPS
• 85% Aurora Optimized Reads cache hit ratio
• Achieved approximately 23% cost reduction

By using Aurora Optimized Reads, Mindbody enhanced query performance, reduced latency, and improved cost-efficiency for their email marketing platform.