The Moneta project: Next generation EVCache for better cost optimizationWith the global expansion of Netflix earlier this year came the global expansion of data. After the Active-Active project and now with the N+1 architecture, the latest personalization data needs to be everywhere at all times to serve any member from any region. Caching plays a critical role in the persistence story for member personalization as detailed in this earlier blog post.
There are two primary components to the Netflix architecture. The first is the control plane that runs on the AWS cloud for generic, scalable …
10 Older Entries »
ScaleArc recently hired Percona to perform various tests on its database traffic management product. This post is the outcome of the benchmarks carried out by me and ScaleArc co-founder and chief architect, Uday Sawant.
The goal of this benchmark was to identify ScaleArc’s overhead using a real-world application – the world’s most popular (according to wikipedia) content management system and blog engine: WordPress.
The tests also sought to identify the benefit of caching for this type of workload. The caching parameters represent more real-life circumstances than we applied in the sysbench performance tests – the goal here was not just to saturate the cache. For this reason, we created an artificial WordPress blog with generated data. …[Read more]
A special extended edition of Tech Messages for 2013-03-07 through 2013-03-10:
Really looking forward to trying this out. Anyone interested in weighing in with their experiences?
How to selectively kill queries in MySQL? — dba
square | A resource on MySQL
Especially helpful when you have hundreds of queries that need to die.
- Redis with an SSD swap, not what you want - Antirez weblog
It is time for christmas presents: some sharding support and cache locality optimizations are coming with PECL/mysqlnd_ms 1.5. PECL/mysqlnd_ms is a plugin for the mysqlnd library. The plugin adds replication and load balancing support to any PHP MySQL API (mysql, mysqli, PDO_MySQL) if compiled to use the mysqlnd library.
As a MySQL user you can choose between a wide variety of clustering solutions to scale-out. Your options range from eventual consistent solutions to strong consistent ones, from built-in (MySQL Replication, MySQL Cluster) to third party or home-grown. PECL/mysqlnd_ms is a client side load balancer that aims to serve all. …[Read more]
Read the original article at 5 Tips to Cache Websites and Boost Speed
There's much more we can do to speed things up, if we only turn over the right stones. Whether you're using WordPress or not, many of these principals can be applied. However we'll use WordPress as our test case.
Test Your Website speed
There are web-based speed testing tools that will help with this step. Take a look at Webpagetest , …[Read more]
WHAT TIME IS IT?
This post started with a simple question: “Does the function NOW() get executed every time a row is examined?” According to the manual, “Functions that return the current date or time each are evaluated only once per query …. multiple references to a function such as NOW() … produce the same result. …. (However,) as of MySQL 5.0.12, SYSDATE() returns the time (the row is) executes. “
- CURDATE() returns the current date.
- CURTIME() returns the current time.
- UTC_DATE() returns the current UTC date.
- UTC_TIME() returns the current UTC time.
- NOW() return the current date and time.
- UTC_TIMESTAMP() returns the current UTC date and time.
- SYSDATE() returns the date and …
For decades the debate between shared-disk and shared-nothing
databases has raged. The shared-disk camp points to the laundry
list of functional benefits such as improved data consistency,
high-availability, scalability and elimination of
partitioning/replication/promotion. The shared-nothing camp
shoots back with superior performance and reduced costs. Both
sides have a point.
First, let’s look at the performance issue. RAM (average access time of 200 nanoseconds) is considerably faster than disk (average access time of 12,000,000 nanoseconds). Let me put this 200:12,000,000 ratio into perspective. A task that takes a single minute in RAM would take 41 days in disk. So why do I bring this up?
Shared-Nothing: Since the shared-nothing database has sole ownership of its data—it doesn’t share the data with other nodes—it can operate in the machine’s local RAM, only writing infrequently to disk (flushing the data …
Having a reverse-proxy web cache as one of the major infrastructure elements brings many benefits for large web applications: it reduces your application servers load, reduces average response times on your site, etc. But there is one problem every developer experiences when works with such a cache – cached content invalidation.
It is a complex problem that usually consists of two smaller ones: individual cache elements invalidation (you need to keep an eye on your data changes and invalidate cached pages when related data changes) and full cache purges (sometimes your site layout or page templates change and you need to purge all the cached pages to make sure users will get new visual elements of layout changes). In this post I’d like to look at a few techniques we use at …[Read more]
The slides for my presentation at FOSDEM 2010 are now available online at slideshare. In this presentation I describe a successful client implementation with the result of 10x performance improvements. My presentation covers monitoring, reviewing and analyzing SQL, the art of indexes, improving SQL, storage engines and caching.
The end result was a page load improvement from 700+ms load time to a a consistent 60ms.
10 Older Entries »