Our goal in reality is to help people to build and operate quality systems, typically web sites, which means we help customers with performance, scalability, high availability as the whole, not just MySQL related issues.
Indeed if you look at MySQL driven web site its properties will likely depend on a lot of factors – good web side configuration, which is about caching, proxying, using multiple data centers or CDN, serving static content reliably and efficiently. Then it comes to efficient web application architecture and code – being scalable, efficient, highly available, secure and fault tolerant. Caching in particular as memcache plays important role here besides MySQL though quite typical you also would see external queue, message parsing, search systems etc being important components besides MySQL.
MySQL is important component but just a component, though due to its complexity it is often where
professional help is looked for dealing with scaling and high availability.
Even more. Everything what we’ve described is only part of the problem. It is all about generating dynamic content quickly or serving static files which is only one side of the problem. The other side is making things fast from the client prospective where our new service – front end performance optimization comes to play.
We look to reduce number of requests and transfer size. Browser and HTTP Caching (Request not made is far better than even fastest serviced request), making content download as parallel as possible and making page to start render as soon as possible.
Front End performance optimization is often needed to change your site from good to great. Market leaders such as Google tend to do it a lot and it is well known fast loading web pages improve user experience and make people to stay on site longer and return more likely which in the end improves business goals such as showing advertisements, product downloads or purchases.
Some people make a mistake by thinking their site are already great by looking at their web site from location which is close to the data center. This gives huge available bandwidth with pretty much no packet loss as well as very low latency.
Most likely these conditions are not the case for all of your users and customers – some may be accessing the system from remote location with high latency and packet loss. Others may be accessing it via crowded public wireless connections and there is class of mobile users with less than perfect latency and download speeds a lot slower than home/office broadband.
This especially comes as important issue to me personally then I’m traveling or using mobile Internet for other reasons – so many web sites become so painfully slow they are barely usable even though their backend does not perform any slower in this case.
By adding front end optimization services we are able to help to deliver great performing web sites whatever performance limiting factors are.
P.S As this is the new service we’re looking for feedback on how to make it better. If you’re interested in your site evaluation and would be willing to provide us feedback about recommendations and general service delivery, drop us a note and we’ll pick couple of sites to review free of charge.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below.