ScaleArc Boosts eBusiness Transactions with the World's First ACID-compliant Database Caching Mechanism for MySQL, SQL Server and Oracle

SANTA CLARA, Calif., March 16, 2015 /PRNewswire/ -- ScaleArc today announces support for automatic cache invalidation, the world's first transparent ACID-compliant caching mechanism for dynamic data. A key feature in ScaleArc's database load balancing software, automatic cache invalidation increases website and application performance by making it safe to cache data that frequently changes, such as shopping cart and user profile information for eCommerce applications. The ScaleArc software tracks data changes to invalidate a cache entry, ensuring outdated data is never served. ScaleArc also provides the ability to handle more workload, reducing page download speeds and increasing website performance while protecting data.

ScaleArc's auto cache invalidation capability was recently put to the test through an extensive evaluation program conducted by a leading eCommerce company. The company tested the feature across two query sizes, measuring the query-per-second (QPS) rate and response time both with and without ScaleArc's database load balancing software. Throughout the testing, the company observed that response time with ScaleArc's software increased 6x to 12x, depending on the query response size. Learn more about ScaleArc's auto cache invalidation testing and results.

"For any company conducting business online, poor website or application performance can result in users failing to complete a transaction or abandoning the eCommerce site all together," said Justin Barney, president and CEO of ScaleArc. "With ScaleArc's database load balancing software and automatic cache invalidation, companies can now cache data that was previously believed to be too risky to cache. By now making this data safe to cache, ScaleArc can bolster business for companies with dynamic data, by reducing their page download times and increasing their overall site availability."

The predominant use cases for auto cache invalidation include:

• Shopping cart data is tracked for a user in an eCommerce application on every page load. Users browse through several items before the final checkout, which places significant load on the database. Shopping cart data, despite being unique for each user, can now be cached since the auto cache invalidation feature will ensure the shopping cart will reflect changed items immediately.
• User profile data, that is personal data associated with a specific user, is typically the most accessed data for the majority of applications. User profile databases need to have 100% uptime because they are validating users before any transactions can be performed. Data tracking by the auto cache invalidation feature ensures user details are up to date while significantly offloading the database from processing such highly repetitive queries.
• Financial data includes eCommerce sites where users can buy and sell items in an auction and require the auction price and associated data, such as current bidders, to be fetched and updated frequently. Database resources are heavily taxed towards the end of an auction period, when many more users are watching an item and starting a bidding war. Each item has a unique identifier that is used to query the bidding data, making it a prime candidate for auto cache invalidation. Other frequently changing financial data such as stock and option prices or banking information that always needs to be consistent also benefits from the offload offered by ScaleArc's cache.

ScaleArc's database load balancing software is available for SQL Server, MySQL, and Oracle database environments. For more information on evaluating ScaleArc's software, click here.

About ScaleArc
ScaleArc is the leading provider of database load balancing software. The ScaleArc software inserts transparently between applications and databases, creating an agile data tier that provides continuous availability and increased performance for all apps. With ScaleArc, enterprises also gain instant database scalability and a new level of real-time visibility for their application environments, both on premise and in the cloud. Learn more about ScaleArc, our customers, and our partners at www.ScaleArc.com.

ScaleArc and the ScaleArc logo are trademarks or registered trademarks of ScaleArc in the United States and other countries. All brand names, product names, or trademarks belong to their respective holders.

ScaleArc Contact:
Suzanne Panoplos
[email protected]
+1 415 640 7475

SOURCE ScaleArc

Related Links

http://www.ScaleArc.com