Case Study: Promovacances.com boosts website performance and scalability with MySQL Enterprise & the Query Analyzer

Promovacances.com boosts its performance with MySQL Enterprise & the Query Analyzer

Promovacances.com, part of the Karavel group and a leading online vacation-packages provider in France since 1998, serves about 40 million visitors a year (up to 250,000 per day in peak season). Growing traffic exposed limits in their Microsoft SQL Server replication setup, so the engineering team redesigned the web architecture and evaluated MySQL to achieve better scalability and manageability.

They adopted MySQL Enterprise (Platinum) for 24/7 support, the Enterprise Monitor and the Query Analyzer. Working with MySQL support and using the Query Analyzer to correlate slowdowns with specific SQL, DBAs quickly identified and fixed problem queries, drastically reducing troubleshooting time and improving performance and scalability to meet high-volume demand.

Promovacances.com

Guillaume Postaire

Infrastructure Manager