Web analytics provider dramatically cuts pay-per-click (PPC) and slashes server footprint with Fusion ioMemory PCIe solutions.
BrainPad, Inc. provides Web-based data mining, business analytics, operational research, and mathematical solutions for businesses. BrainPad’s L2MixerTM service provides business intelligence on end-user, pay-per-click behavior, allowing companies to optimize product pricing. Its RtoasterTM service, used by various global companies, provides end-users product recommendations based on a behavioral analysis of their browsing patterns as well as targeted pricing recommendations based on geo-specific, behavioral, and attributes-based data from imported ERP databases.
As BrainPad’s customer base and product line expanded, so did the load on both systems’ databases, which in turn slowed the performance of its services.
BrainPad’s innovative engineering teams wasted no time researching solutions that would demonstrate why BrainPad is a leader in Web analytics and research. BrainPad needed systems that overcame the following challenges:
The SanDisk® Solution
Powering Pay-Per-Click intelligence
Batch Job Benchmarking
Having heard about SanDisk’s industry-leading performance from its OEM vendor, Tsuyoshi decided to give Fusion ioMemoryTM products a try. To benchmark performance, Tsuyoshi installed a 160GB Fusion ioMemory ioDrive® card on one of BrainPad’s PostgreSQL databases and ran some of its heavier reporting jobs. The results spoke for themselves.
Tsuyoshi said, “One batch job, which used to take over four hours to complete, ran in less than 30 minutes. The ioDrive cards also doubled the number of threads we could run in parallel—from three to four threads up to eight to 10 threads, which meant we could run more jobs at the same time. We were genuinely impressed.”
Raising the Roof on L2MixerTM Reporting
Speeding performance in a benchmark environment is one thing, but the ioDrive cards demonstrated they were more than capable of handling BrainPad’s heaviest, real-world workloads.
Tsuyoshi said, “Moving the L2Mixer databases from hard disks to ioDrive cards cut the I/O wait time for our pay-per-click processing by more than half—from 18% to just 8%.”
This reduction in I/O wait time resulted in the following performance benefits:
Tsuyoshi said, “Performance is high enough that we can now meet the most demanding customer SLAs. This ensures our customers always get reports quickly so they can make timely business decisions on factors like pricing to maximize their profitability.”
Real-time RtoasterTM Recommendations
Satoshi Shinohara had heard about the phenomenal results Tsuyoshi’s team had with BrainPad’s L2Mixer system. After consulting with Tsuyoshi, Satoshi decided to add some ioDrive cards to Rtoaster’s PostgreSQL database—and achieved similarly impressive results.
Satoshi said, “The ioDrive cards improved our analysis times tremendously. We reduced batch job processing times from 60 minutes on a system with a 24 x 15k RPM SAS disk array in a RAID 10 to just over two minutes.”
Chief Engineering Architect, BrainPad Inc.
Satoshi said, “The ioDrive cards have improved performance so much that we can meet all customers SLAs with plenty of headroom for future growth. When we do need to scale out, we can do so easily, and with far less hardware.”
Simpler Systems that are Easier to Maintain
In addition to eliminating performance problems, the ioDrive cards also reduced BrainPad’s maintenance workload.
Tsuyoshi noted the Fusion ioMemory solution’s cost benefits to the L2Mixer system: “The L2Mixer database now uses 50% less rack space and has no disks or enclosures for us to monitor and maintain. It also lowers our energy costs.”
Tsuyoshi added that the database’s high performance makes the system much easier to maintain: “Before implementing SanDisk, we had to run database maintenance tasks once a week or more just to avoid a serious performance degradation. Now, we can eliminate these tasks altogether, which is quite significant.”
The Rtoaster system realized similar benefits. “The Rtoaster database now uses 33% less rack space, and we’ve eliminated the disk enclosures,” said Satoshi. “Our system is smaller and more flexible, which makes tuning and maintenance easier. The ioDrive Duo card even reduced the time of our daily PostgreSQL vacuum job from one and a half hours to just 15 minutes.”
Enabling More Reliable and Available Architectures
Tsuyoshi told us, “Our procurement group initially had some reservations about how we could create a highly available and reliable system with the Fusion ioMemory solution’s server-based memory.”
However, after speaking with some experts at SanDisk, Tsuyoshi learned that reliability is built into SanDisk’s enterprise technology and that the ioDrive card’s performance enables simpler, more powerful systems, with fewer failure points.
“Our new system is simpler, more flexible, and easier to modify and improve,” explained Tsuyoshi. “Our engineers decided to push the purchase through. We have been deployed for some time now, and we all agree it was a sound investment.”
Implementing ioDrive cards gave BrainPad the following benefits:
Tsuyoshi is thrilled with the performance and consolidation SanDisk has enabled and told us, “We are very happy and are actively deploying ioDrive cards in several other systems.”
BrainPad helps improve enterprises’ productivity and profitability by rationalization and optimization of the marketing activities utilizing data mining and constraints- optimization technologies. BrainPad provides comprehensive support to companies who intend to improve their business activities with data analysis, system building and SaaS services provision.
Whether you'd like to ask a few initial questions or are ready to discuss a SanDisk solution tailored to your organizations's needs, the SanDisk sales team is standing by to help.
We're happy to answer your questions, so please fill out the form below so we can get started.
Thank you. We have received your request.