How to turbocharge your Web site by dumping your database
Possible? Not quite yet, but Terracotta takes a step in that direction
Computerworld - Databases are getting faster every day. But they're still a significant bottleneck for many Web applications or Web sites.
Why? Mechanical hard drives, impeded by the laws of physics, bog down the relational databases that read and write to them.
What are the solutions? Speeding up I/O by reading and writing to a faster solid-state disk rather than a spinning one can help. So can using an in-memory database to cache heavily accessed data in RAM.
Another solution combines a little of both, its backers say, allowing Java-based Web apps and sites to scale their performance while avoiding expensive and possibly less effective database upgrades.
Terracotta Inc.'s namesake software is an open-source Java clustering solution.
According to CEO Amit Pandey, the software ties multiple Java virtual machines (JVM) underpinning Java-based Web applications into one big cluster. That allows users to add more app servers to scale out at the application level. It caches all of the transactions going through the Java app while writing them to disk separate from the database.
This way, data generated during a transaction can be quickly stored and, if an app server fails, just as quickly recalled, without having to write each intermediate result to the database itself.
That's perfect for data that is vital during a transaction -- say, the items in your shopping cart -- but that does not necessarily need to be written to disk until the transaction (i.e. the purchase) is finished.
The largest group of those customers is using Terracotta with Oracle databases. According to Pandey, one company that does online testing was able to double the number of students it served from 10,000 to 20,000 by using Terracotta and adding 10 free open-source application servers. The company spent about $300,000 on Terracotta and the servers, he said, in contrast to the $2.1 million price tag the firm was quoted if it added more Oracle databases instead.
Yes, said Pandey, though he claimed that using TimesTen is "a little bit more disruptive. It doesn't give you the same [data] persistence as we would, since we are writing to disk in parallel." Also, Terracotta works in Java, meaning that there is no performance loss in translating data from Java objects to relational data formats, he said.
- Best iPhone, iPad Business Apps for 2014
- 14 Tech Conventions You Should Attend in 2014
- 10 Desktop Apps to Power Your Windows PC
- How to Add New Job Skills Without Going Back to School
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Aberdeen Group: Marketing Analytics for Manufacturing: Forging Customer Insights There are no recalls for poor marketing. Manufacturers need to get their customer intelligence and messaging right the first time. Learn how.
- SIEM: Keeping Pace with Big Security Data Learn how SIEM can have the right database back-end and offer security intelligence that leverages contextual data to achieve a strong security posture...
- Gartner 2013 Magic Quadrant for Enterprise Backup/Recovery Software See why CommVault was positioned as the #1 leader in Gartner's 2013 Magic Quadrant for Enterprise Backup/Recovery software for the 3rd year in...
- Forrester Report: CommVault is a Leader in Enterprise Backup and Recovery In this report, Forrester takes a deep dive into the evaluation criteria, how CommVault is positioned and the features and functionality that make...
- Four Myths of High-Productivity App Dev Debunked Debunk the main myths surrounding high-productivity application development and how both platforms have overcome them.
On-Demand Webcast: 7 Reasons to Choose VoIP
Thinking about a new phone system for your business?
Be sure to watch this informative webcast. Steve Strauss, small business columnist for USA...
All Databases White Papers |