Cisco Using Fusion-IO’s ioDrive2 Achieves TPC-H #1 Result

Following on the excellent results of Micron’s P320h we see that Fusion-IO is not sitting still.  A new TPC-H SAP Sybase IQ Benchmark offering up the best result by using Fusion-IO ioDrive2.  The Cisco UCS C420 M3 Rack Server used six Fusion ioDrive2 cards to achieve the result.



In flash PCIe cards, Fusion IO has developed an excellent record which they are legitimately promoting :

See also Six World Records and Nine of the Top Ten VMmark Scores Include Fusion-io

gotostorageGo to more posts on storage and flash storage at

Recommended (from Rails Conf 2013) : Postgres, the Best Tool You’re Already Using

There is a nice presentation by Adam Sanderson from LiquidPlanner discussing some of the things he has learned and some new unique features in Postgres.  He covers tagging, hierarchy and modeling tree structures, custom data (sparse data) and full text search.  He provides SQL code showing how to go about defining arrays in SQL which include tags. He also shows this in ActiveRecord. He shows how to use the contains and overlaps operators with these tag arrays and how to go about querying Tags in ActiveRecord and compositing new features. He also covers Hstore in Postgres which provides a way to creating custom data. He also shows how to query Hstore in ActiveRecord. He then also shows how to use Postgres’ full text search. He provides a lot of detail into these topics.

Don’t stop here. Visit his blog it has even more information on these topics :



Recommended Webinar : SkySQL MariaDB 10.0 Overview

If you are interested in MySQL and MariaDB – there is an excellent new webinar series on MariaDB 10.0.  The presentation offers an overview of MariaDB 10.0 features and topics :

  • replication improvements, including multi-source replication, Global Transaction ID (GTID), and more
  • connecting MariaDB to a Cassandra cluster using CassandraSE using the CONNECT storage engine to join ODBC data sources with other tables and more
  • using the built-in sharding features of the SPIDER storage engine
  • atomic write support for FusionIO DirectFS
  • improvements for DBAs around per-thread-memory-usage statistics, and more
  • MySQL Enterprise features that exist in MariaDB: PAM Authentication plugin, threadpool, Audit plugin

You have to sign up to see the webinar :




Recommended Reading : Systems Performance, SmartOS and the Cloud

There is a new book out, Systems Performance : Enterprise and the Cloud by Brenden Gregg, and if you have to put up with slow software, book_brendenthen on a Monday, you need this book.  If you don’t know who Brenden Gregg is, then you haven’t been paying attention to a revolution in some of he  software that came from his team at Sun just a few years back. And this book constitutes an excellent way at  looking at system performance.  As described on Amazon : “Large-scale enterprise, cloud, and virtualized computing systems have introduced serious performance challenges. Now, internationally renowned performance expert Brendan Gregg has brought together proven methodologies, tools, and metrics for analyzing and tuning even the most complex environments. Systems Performance: Enterprise and the Cloud focuses on Linux® and Unix® performance, while illuminating performance issues that are relevant to all operating systems. You’ll gain deep insight into how systems work and perform, and learn methodologies for analyzing and improving system and application performance. Gregg presents examples from bare-metal systems and virtualized cloud tenants running Linux-based Ubuntu®, Fedora®, CentOS, and the illumos-based Joyent® SmartOS™ and OmniTI OmniOS®. He systematically covers modern systems performance, including the “traditional” analysis of CPUs, memory, disks, and networks, and new areas including cloud computing and dynamic tracing. This book also helps you identify and fix the “unknown unknowns” of complex performance: bottlenecks that emerge from elements and interactions you were not aware of. The text concludes with a detailed case study, showing how a real cloud customer issue was analyzed from start to finish.”   You can get a quick overview of the book by looking at his presentation and for the first time being introduced to the DTrace pony (page 6, but we will come back to the DTrace pony later) you can experience modern performance tools.


Any so begins your magical mystery tour if you don’t know DTrace. If you haven’t experienced it you have missed out on a tool capable of literally

DTracegiving you deep observability into your system.  Though the best versions of DTrace run on open-source Solaris-based operating systems like SmartOS and illumos-based variants, their are also versions that run on Linux.  Couple with DTrace are utilization and latency heat maps and flame graphs which offer a visual view of what DTrace is reporting. As you get more interested in this tool you may want to examine what people like Brendan Gregg and Joyent are doing with DTrace in the Cloud –


Joyent is using a forked version of OpenSolaris based on the illumos (open source) version.  Joyent’s open source version, SmartOS,  which they have customized around cloud deployments provides a large number of features unavailable on Oracle’s version of Solaris. And because SmartOS leverages OpenSolaris, one more thing becomes useful, ZFS, one of the most sophisticated file systems available.


Another virtualization aspect of SmartOS is that it leverages Solaris zones (extremely lightweight) and Linux KVM (ported, debugged and tuned via DTrace).  And this all has given Joyent very special insight into dense virtualization and the architectures that virtualized clouds are built on.


All of this is very interesting and offers an alternative to the usual VMware cloud, it also offers very strong open source enterprise-tested features of virtualization, file systems, tracing software and a suite of great features both server, storage and software-centric.  You can learn more about Joyent’s cloud version of Solaris at

The Future of Java VM Languages : 2013 JVM Language Summit

Oracle has made available the presentations and the videos from the 2013 JVM Language Summit.  There is a wealth of information.


Increasingly, non-Java JVM-based languages are providing a differentiated sets of features.  Two more interesting links can be found here :


clojureiconGo to more posts on clojure or that are clojure-related at

Recommended Reading : A Use-Case-By-Use-Case Introduction to Node.js

I bumped into a very nice overview article suggesting use-cases for node.js.  One may argue that it is not comprehensive but it makes interesting reading and offers some suggestions. The article discusses how node.js works and some of the most popular NPM modules.   It’s approach to explaining node.js is actually quite nice and goes into how the module, Express.js, works. It discusses some use-cases like chat, as an API on top of an object database (like MongoDB),  queued inputs, data streaming and as a server-side proxy. It also looks at some dashboard applications like a stock trader’s dashboard, application monitoring dashboard and system monitoring dashboard.  Finally it goes through the pros and cons of using it in server-side web apps and where it should be used.


As a follow-on to the use-case article, eBay has written about their first node.js use-case around “talk” :


Recommended Viewing : Writing RESTful Web Services Using Node.js

I bumped into this wonderful talk that Jakob Mattson gave on node.js. In this video he introduces node.js in a really nice way. Moving from basic concepts to building web services and middleware.  Along the way he introduces frameworks and tools like passport that help you develop an approach to authentication.  This is a really nice introduction to node.js.

and in a second, slightly higher level talk he discusses web services and the need to adopt the Unix philosophy for web services (“Do one thing and do it well.”) and then allow the services to use each other.

You can find more on user authentication and passport.js from setup to adding routes to test and to error handling.  This nice write-up  provides a lot of information :


Recommended Reading : MariaDB 10.0 Beta

It’s worth noting that when Oracle bought Sun Microsystems, one of the big concerns was Oracle’s stewardship of the open source MySQL database. Michael Widenius spent tremendous energies trying to exclude the MySQL from the deal.  In the end, Oracle ended up with MySQL, but that didn’t prevent Widenius from forking MySQL, creating MariaDB and today taking away large swaths of business and mind-share from MySQL.  As many businesses including Google move to MariaDB – the question is whether it is over for Oracle MySQL ?  It is an open question.  There is certainly a large amount of suspicion with regards to Oracle’s motives with MySQL.  Now, Widenius’ team are releasing the latest and most feature-rich version of MariaDB to date.  Considering the Sun-Oracle deal closed in 2010 – they have moved fast and are offering what could be a serious competitive challenge to MySQL.  Consider that Red Hat is also switching its storage engine in Fedora 19 making MariaDB the default implementation of MySQL. Others like Mozilla are migrating to it.  Adoption by these large and influential companies set a trajectory for MariaDB that can only be described as ascendent.  The latest 10.0 release of MariaDB offers up feature after feature that is  absent in Oracle’s version of MySQL.  Widenius’ company,  skySQL just received $20 million Series B funding to add more fuel to the MariaDB growth. The focus of accelerating and providing further differentiation with Oracle’s MySQL is clearly a focus as MariaDB introduced support for Fusion-IO’s “atomic writes” feature earlier this year and as more features including global GIS support and improved master-slave replication.  With 10.0 there are a slew of features that further differentiates MariaDB from Oracle MySQL. In 10.0 there is over 1.5 million lines of new code.   Key new features around Parallel slave technology, parallel replication, integration with storage engines like Cassandra, Connect, Sequence, Spider and TokuDB.  It also has new ease-of-management features. Details of the release can be found in the MariaDB Press Release. You can see some of these in this presentation (slides) :

and in this benchmark you get a feel for the performance versus Oracle MySQL :


Widenius has mentioned that the skySQL now has over 300 customers including  large enterprise customers including Deutsche Telecom, Craigslist, the Financial Times, Home Depot and many others.

The question is can Oracle MySQL compete with MariaDB 10.0 ?  It will certainly require time for customers to migrate, so for the moment Oracle may have some breathing space – but without a direct software response to MariaDB that is not enough. Customers that have or are migrating are laying down both a technical path of best practices to migration and perception of the situation that is not favorable to Oracle MySQL in the long run.   Widenius feels there is no longer a need to use Oracle MySQL and the skySQL website demonstrates this with a nice competitive matrix comparing MySQL 5.6 and MariaDB 10.0 :


Recommended Viewing : Why Micron is 5 Times Faster Than Fusion-IO

This is a particularly interesting for those working with NoSQL databases. In a meet-up hosted by Aerospike some of results from recent testing were provided.  In the beginning there is a discussion by Brian Bulkowski, CTO of Aerospike who talks about why they are interested in fast flash implementation.  I wrote about this recently in the post, Aerospike Benchmark :  Micron PCIe P320h and P420hm Flash Cards “Blow Away The Competition. They recently benchmarked Micron’s PCIe flash cards and were stunned by the performance – it was considerably faster than every other competing implementation.  Scott Shadley, Jr. from Micron presented how Micron is able deliver the performance that surprised Aerospike and also covered the 2.5″ PCIe P320h form-factor that I discussed in the posting, Micron’s P320h 2.5″ Flash PCIe Form-Factor Offers Hot-Swap, which I recommended anyone buying a PCIe flash card should look at.



gotostorageGo to more posts on storage and flash storage at