There have been a couple of recent blog articles (here and here) asking for parallel replication based on something other than schemas. These articles both focus on the problem of parallelizing updates within a single MySQL schema. I read these with great interest, not least because they both mentioned Tungsten (thanks!) and also found that our schema-based parallelization approach [...] [...more]
A couple of weeks ago, when Mozilla released firefox 4, i watched glow.mozilla.org – a site made to visualize the firefox downloads in real time. I figured this could be quite a neat use case for my old drizzle to web socket replicator. So, the compontents involved: Drizzle with the rabbitmq plugin, see this blog [...] [...more]
Combating “data drift” In my first post in this series, I described materialized views (MVs). An MV is essentially a cached result set at one point in time. The contents of the MV will become incorrect (out of sync) when the underlying data changes. This loss of synchronization is sometimes called drift. This is conceptually [...] [...more]
In my previous post I introduced materialized view concepts. As a reminder, the first post covered the following topics: What is a materialized view(MV)? It explained that an MV can pre-compute joins and may aggregate and summarize data. Using the aggregated data can significantly improve query response times compared to accessing the non-aggregated data. Keeping [...] [...more]
If you know me, then you probably have heard of Flexviews. If not, then it might not be familiar to you. I’m giving a talk on it at the MySQL 2011 CE, and I figured I should blog about it before then. For those unfamiliar, Flexviews enables you to create and maintain incrementally refreshable materialized [...] [...more]
