1. Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

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

Discussion in 'News' started by btarunr, Dec 7, 2011.

  1. btarunr

    btarunr Editor & Senior Moderator Staff Member

    Joined:
    Oct 9, 2007
    Messages:
    28,225 (11.38/day)
    Thanks Received:
    13,580
    Location:
    Hyderabad, India
    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."

    [​IMG]

    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.
  2. de.das.dude

    de.das.dude Pro Indian Modder

    Joined:
    Jun 13, 2010
    Messages:
    7,501 (5.00/day)
    Thanks Received:
    1,947
    Amd ftw
  3. R_1

    Joined:
    Dec 1, 2006
    Messages:
    449 (0.16/day)
    Thanks Received:
    39
    Reasonable combo price, because 1.2 TB Fusion ioDrive2s is expensive.
  4. human_error

    human_error

    Joined:
    Nov 10, 2008
    Messages:
    1,721 (0.83/day)
    Thanks Received:
    458
    It would probably take all the credit card transactions on the planet to pay for the damned thing :p
  5. de.das.dude

    de.das.dude Pro Indian Modder

    Joined:
    Jun 13, 2010
    Messages:
    7,501 (5.00/day)
    Thanks Received:
    1,947
    ^lol
  6. NC37

    NC37

    Joined:
    Oct 30, 2008
    Messages:
    1,169 (0.56/day)
    Thanks Received:
    260
    Nah, that would be if it was Intel based ;)

    AMD...just takes a few continents :D
  7. D4S4

    D4S4

    Joined:
    Mar 27, 2008
    Messages:
    697 (0.30/day)
    Thanks Received:
    75
    Location:
    Zagreb, Croatia
    handling gazillions of transactions looks like exactly the workload bulldozer excels in.
  8. btarunr

    btarunr Editor & Senior Moderator Staff Member

    Joined:
    Oct 9, 2007
    Messages:
    28,225 (11.38/day)
    Thanks Received:
    13,580
    Location:
    Hyderabad, India
    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.
  9. Captain.Abrecan

    Captain.Abrecan New Member

    Joined:
    Oct 21, 2010
    Messages:
    175 (0.13/day)
    Thanks Received:
    64
    Location:
    MA
    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...
  10. suraswami

    suraswami

    Joined:
    Apr 5, 2005
    Messages:
    6,067 (1.79/day)
    Thanks Received:
    793
    Location:
    Republic of Asia (a.k.a Irvine), CA
    AMD and M$ SQL FTW :rockout:
  11. WarraWarra New Member

    Joined:
    Nov 23, 2010
    Messages:
    268 (0.20/day)
    Thanks Received:
    14
    @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.
  12. [H]@RD5TUFF

    Joined:
    Nov 13, 2009
    Messages:
    5,615 (3.28/day)
    Thanks Received:
    1,707
    Location:
    San Diego, CA
    pretty impressive

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page