SSD Update: this is the one session you MUST ATTEND at Percona MySQL in April

March 20, 2012

MySQL and SSD: usage and tuning

In this talk, Vadim Tkachenko (Percona CTO) will cover Solid State Drives internals and how they affect database performance.
IO level benchmarks for SATA (Intel 320 SSD) and PCI-e (FusionIO, Virident) cards
to show absolute performance and give an idea on performance per $.
And finally how you can use MySQL and Percona Server with SSD,
what tuning parameters are most important and what performance may expect in real
production usage.


Utilizing Hardware

Experience level:
Note from Steve:  This show is a MUST for anyone thinking about solid state memory extensions or SSDs.  Just take a look at the speakers, sponsors, and exhibitors!

Fusion-io Demo Runs the Equivalent of All Global Credit Card Transactions from a Single Server

November 30, 2011

Microsoft(R) SQL Server(R) Database Technology Enables High Scale Demonstration of 1.1 Million Transactions Per Second

SALT LAKE CITY, Nov. 30, 2011 /PRNewswire/ — Fusion-io (NYSE: FIO) today announced that its VSL software subsystem and four 1.2 TB Fusion ioDrive2s integrated into a single 64-core AMD Server were able to achieve 1.11 million transactions per second in a Microsoft SQL Server database. The demonstration delivered the data throughput projected to be required to run all credit card transactions on the planet, underlining new solutions for powering efficiency in retail data processing as the 2011 holiday shopping season kicks off with record sales.

“Today’s modern CPUs cannot be fed data fast enough with old approaches to application architecture,” said Thomas Kejser,SQL Server Customer Advisory Team enterprise database specialist. “To fully leverage the possibilities of the NAND flash revolution in a way that utilizes the hardware, IT professionals need to understand the properties of what we use to build our systems. For example, low latency architecture that uses NAND flash as part of the memory hierarchy helps avoid bottlenecks by integrating close to the CPU for low latency application performance, which is why Fusion-io was selected for this high scale demonstration.”

In the demonstration, inserts were done on 150 billion wide rows, into a single database table in Microsoft® SQL Server®, ultimately resulting in 1.1 million singleton inserts per second figure. The same test was run with update statements, achieving 2.5 million updates per second. Translating this throughput number to simplified credit card transactions, using the system in the testing, one transaction is one debit, one credit, and one update of account balance. When applied to daily transaction requirements, this amounts to approximately 25 billion simplified transactions per day. To put the transaction number into perspective, this is equivalent to all the credit card transactions projected to be made daily by every individual on the planet from now until 2050, when it is expected that the world will be inhabited by nine billion people.

“Given how consumers are embracing online shopping, especially on Cyber Monday and even Black Friday, we believe this achievement showcases how Fusion-io can help meet demand for servicing more digital transactions with an efficient, rapid and reliable solution,” said Neil Carson, Fusion-io Chief Technology Officer. “The transaction rates achieved in these tests demonstrate the high scalability and efficiency of today’s Microsoft SQL Server databases when powered by Fusion-io.”

To learn more about Fusion-io, go to Follow Fusion-io on Twitter at on Facebook at

MySQL Conference Santa Clara This Week

April 12, 2010


I’ll be there Tuesday…ping me it you’re going.

Consider Element-based Storage to Support Application-centric Strategies

March 29, 2010

What is Element-based storage?

Element-based storage is a new concept in data storage that packages caching controllers, self-healing packs of disk drives, intelligent power/cooling, and non-volatile protection into a single unit to create a building-block foundation for scaling storage capacity and performance. By encapsulating key technology elements into a functional ‘storage blade’, storage capability – both performance and capacity – can scale linearly with application needs. This building-block approach removes the complexity of frame-based SAN management and works in concert with application-specific function that resides in host servers (OSes, hypervisors and applications themselves).

How are Storage Elements Managed?

Storage elements are managed by interfacing with applications running on host servers (on top of either OSes or hypervisors) and working in conjunction with application function, via either direct application control or Web Services/REST communication. For example, running a virtual desktop environment with VMware or Citrix, or a highly-available database environment with Oracle’s ASM or performing database-level replication and recovery with Microsoft SQL Server 2008 – the hosts OSes, hypervisors, and applications control their own storage through embedded volume management and data movement. The application can directly communicate with the storage element via REST, which is the open standard technique called out in the SNIA Cloud Data Management Interface (CDMI) specification. CDMI forms the basis for cloud storage provisioning and cloud data movement/access going forward.

The main benefits of the element-based approach are:

  • Significantly better performance – more transactions per unit time, faster database updates, more simultaneous virtual servers or desktops per physical server.
  • Significantly improved reliability – self-healing, intelligent elements.
  • Simplified infrastructure – use storage blades like DAS.
  • Lower costs – significantly reduced opex, especially maintenance and service.
  • Reduced business risk – avoiding storage vendor lock-in by using heterogeneous application/hypervisor/OS functions instead of array-specific functions.

Action Item: Organizations are looking to simplify infrastructure, and an application-centric strategy is one approach that has merit. Practitioners should consider introducing storage elements as a means to support application-oriented storage strategies and re-architecting infrastructure for the next decade.

Rob Peglar is VP of Technology at Xiotech and a Xiotech Senior Fellow.  A 32-year industry veteran and published author, he leads the shaping of strategic vision, emerging technologies, defining future offering portfolios including business and technology requirements, product planning and industry/customer liaison. He is the Treasurer of the SNIA, serves as Chair of the SNIA Tutorials, as a Board member of the Green Storage Initiative and the Solid State Storage Initiative, and as Secretary/Treasurer of the Blade Systems Alliance.  He has extensive experience in storage virtualization, the architecture of large heterogeneous SANs, replication and archiving strategy, disaster avoidance and compliance, information risk management, distributed cluster storage architectures and is a sought-after speaker and panelist at leading storage and networking-related seminars and conferences worldwide.  He was one of 30 senior executives worldwide selected for the Network Products 2008 MVP Award.    Prior to joining Xiotech in August 2000, Mr. Peglar held key technology specialist and engineering management positions over a ten-year period at StorageTek and at their networking subsidiary, Network Systems Corporation. Prior to StorageTek, he held engineering development and product management positions at Control Data Corporation and its supercomputer division, ETA Systems.     Mr. Peglar holds the B.S. degree in Computer Science from Washington University, St. Louis Missouri, and performed graduate work at Washington University’s Sever Institute of Engineering.  His research background includes I/O performance analysis, queuing theory, parallel systems architecture and OS design, storage networking protocols, clustering algorithms and virtual systems optimization.

repost from WIKIBON: