… with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query. Data… this benchmark each of the original queries has been rewritten to conform to the new schema, and additionally two new test queries…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…, but before that, I want to give a quick preview, then explain exactly how Shard-Query works.Yes, Shard-Query scales very well at… learned how to distribute the computation of aggregation queries over time. I realised that I could apply these same mathematical concepts to distributed… speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies to the distributed processing. The results from…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… important to examine the differences in size. This will give us some interesting information about how Shard-Query will perform on each database. To…=latin1 COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… “sharded” MySQL the numbers are not that high – many what would be considered medium scale MySQL installations would get there. With MySQL we seems to…. How many of us are running 5TB per MySQL instance ? 20TB ? Over 50TB ? I believe this is to continue to be significant difference between MySQL…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… path than 4.1 to 5.1 just because so much more people have followed that road. So how do people approach… new shard and measuring its capacity) Setting up the Slave(s) If you want to minimize downtime it is best to use MySQL Replication… if something happens (like MySQL crashes) you have only one/few shard to deal with. P.S Happy New Year to all of you 
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
…(or at least interesting) results, how to do super-advanced and extreme things with MySQL, how to use MySQL for a Ruby on … partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, …
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… to technologies in MySQL space. First I think MongoDB is best compared no to MySQL Server but MySQL Cluster, especially in newer versions which implement “sharding… them to stabilize as well as later develop tools around them. How to check if 2 MongoDB nodes are indeed in sync ? How to do…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… example, just like the MySQL client. This will be a linear operation because Shard-Query has no idea how to add parallelism in this…. mysql> select min(id),max(id) from words; +———+———+ | min(id) | max(id) | +———+———+ | 1 | 3088896 | +———+———+ 1 row in set (0.00 sec) How to…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL…to think outside the box, even to think of things that seem “less advanced” than using a database. Sharding and Partitioning Sharding… have to think about how to avoid enormous tables that are hard to maintain,…
Post: Percona Server Scales Vertically with Virident tachIOn Drives
February 28, 2011 By Leave a Comment
We’ve published a new white paper that explains how to stop sharding and start scaling vertically with PCI-E flash drives, specifically… feeling to have an explicitly recommended reference architecture: buy flash storage first, shard as a last resort. From the summary: The sharding approach… up” is once again a viable and economical strategy for MySQL, and “scaling out” need no longer be the default database…
