Case Studies from Percona

Percona's MySQL case studies are objective technical stories of real user experiences with MySQL. They show how users leverage Percona's products and services to build cost-effective applications that perform and scale well. MySQL case studies are either authored or reviewed by an engineer who is familiar with the topic, preferably the consultant who worked with the systems mentioned. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.

Estante Virtual Leverages Percona for State-of-the-Art Solutions

Estante Virtual has created a revolution in Brazil's second-hand book market. The site is a trading portal for thousands of independent traders and bookstores, with a searchable inventory that grows enough to fill two bookstores every day. But as the site grew, the traffic exceeded the capabilities of the MySQL database and the web servers. Percona converted the site to a higher performance architecture using technologies such as Sphinx and lighttpd, and performed full-stack system optimization. The result is an excellent user experience for buyers and sellers, and a high-performance application that can scale significantly with future demand. Download Estante Virtual Leverages Percona for State-of-the-Art Solutions as a PDF.

Percona Server with XtraDB Puts Flash in ideeli's Flash Sales

ideeli is a members-only online shopping club that offers time-limited "flash sales" on designer brands. As traffic increased, ideeli's MySQL database experienced serious performance problems at peak load. Simple queries ran for orders of magnitude longer than they should have. The solution was to upgrade to Percona Server with XtraDB. After upgrading, ideeli has enjoyed higher throughput and stable performance, even though the application has become busier and the traffic to the database has nearly doubled. Download Percona Server with XtraDB Puts Flash in ideeli's Flash Sales as a PDF.