Improving Website speed with Percona Server and Docker containers

1 . Improving Website speed with Percona Server and Docker containers In this real case scenario presentation we’re going to talk about how we improved our Websites speed with Percona Server and Docker containers. Leonardo Erpi Senior Web Developer Percona University Montevideo April 23rd 2019 1 © 2019 Percona 

2 .Percona Blog initial state Dedicated Webserver with 4 CPU’s and 4Gb RAM CPU usage > 75% 200K hits/month Percona Server 5.6 2 © 2019 Percona 

3 .Diagnosing performance Using PMM observed high concurrency (threads_running) 3 © 2019 Percona 

4 .Speeding things up - Percona Server 5.6 -> 5.7 (better concurrency management) - Docker container (better manageability) 4 © 2019 Percona 

5 .Percona Blog final state Webserver running in Docker on the same hardware CPU usage 40-50% (threads spent less time waiting for the DB) 220K hits/month Percona Server 5.7 5 © 2019 Percona 

6 .Performance monitored by Pingdom 6 © 2019 Percona 

7 .The aftermath SEO: improving page speed, increased a 5% the organic search inbound traffic in the first quarter Contingency: 2 blog Docker instances running in case of failover Deployment: we can easily deploy as many Blog Docker instances as we want 7 © 2019 Percona 

8 .Acknowledgments This was a combined effort between IT, DB and Development teams 8 © 2019 Percona 

9 . DATABASE Champions of Unbiased Database Performance Matters OpenPERFORMANCE Source Database Solutions MATTERS