Wednesday, December 7th 2011

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

Fusion-io recently 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."

For more information, visit the Fusion-io website.
Add your own comment

11 Comments on Fusion-io Runs Equivalent of All Global Credit Card Transactions from a Single Server

#2
R_1
by: de.das.dude
Amd ftw
Reasonable combo price, because 1.2 TB Fusion ioDrive2s is expensive.
Posted on Reply
#3
human_error
The demonstration delivered the data throughput projected to be required to run all credit card transactions on the planet
It would probably take all the credit card transactions on the planet to pay for the damned thing :p
Posted on Reply
#5
NC37
by: human_error
It would probably take all the credit card transactions on the planet to pay for the damned thing :p
Nah, that would be if it was Intel based ;)

AMD...just takes a few continents :D
Posted on Reply
#6
D4S4
handling gazillions of transactions looks like exactly the workload bulldozer excels in.
Posted on Reply
#7
btarunr
Editor & Senior Moderator
by: D4S4
handling gazillions of transactions looks like exactly the workload bulldozer excels in.
Bingo. That's what AMD processors have been good at in general. Pushing bits around quickly with minimal number crunching. Intel processors with QPI can do that just as well, but they tend to have higher price/throughput ratios than AMD.

But servers that require heavy number crunching (say Flickr's servers that run countless instances of imagemagic (resizing, image manipulation), or YouTube (video transcoding/compression)), Intel all the way.
Posted on Reply
#8
Captain.Abrecan
btarunr, I want you to know that I blame you for my intense chocolate craving right now. :cry:
Guess I'm going out for lunch today...
Posted on Reply
#10
WarraWarra
@Captain, you should divert that to cocoa flavored body lotion that your girlfriend / wive uses then you would really get addicted. Not sure if you can get it in USA, they have it in Mexico for dry skin, smells marvelous.

@OP, This is great news, surely there would be better results if you use a properly optimized system / not using MS SQL. Seems like there is a long road ahead to optimize programs for the Interlagos / Magny-Cours.

Wonder what Intel Xeon's would be able to do in a similar config.
Posted on Reply
Add your own comment