A faster, sleeker way to do MySQL?
Start-up offers appliance delivering high-performance data warehousing
Computerworld - The archetypal MySQL database chugs along in the server room of a Web 2.0 start-up, powering a small but promising Web site. In fact, a quarter of the 12 million MySQL installations are data warehouses doing business intelligence and analytics for companies.
The problem is that without labor-intensive retuning, MySQL performs poorly as a data warehouse.
"If you've got a lot of time on your hands, you could mess around with MySQL," said James Kobielus, an analyst at Forrester Research Inc. Otherwise, "it's just not optimized for BI."
Today, a start-up is officially unveiling a MySQL-based appliance boasting proprietary chip and software technology that it claims delivers high-performance data warehousing out of the box.
Santa Clara, Calif.-based Kickfire Inc. is starting to ship its appliance in earnest this week. Kickfire is targeting what it says is the mass market for MySQL data warehousing -- smaller-than-10TB warehouses used for Web analytics.
Based on a SQL chip developed by Kickfire's founders, the Kickfire appliance starts at $32,000 with 1TB of storage.
Karl Van den Bergh, Kickfire's vice president of marketing, admits that the figure is about twice the price of a general-purpose server running the open-source database.
However, he also claims that Kickfire more than makes up for that price by delivering far faster performance than typical MySQL servers. He credits its SQL chip, which accelerates the database by running commands in silicon, as well as its columnar storage engine tuned to read data quickly, which is key for data warehouses.
Mamasource is a five-year-old Web start-up in Corte Madera, Calif., that is Kickfire's first named customer. (Kickfire has also claimed several unnamed customers in the past.) The company, which operates an online community for moms, was running a 300GB MySQL data warehouse to analyze its user clickstream data. Performance was sluggish. For instance, it took about four hours a day to upload 1GB of clickstream data into the data warehouse, during which time the data warehouse was fully occupied, according to Steve Ketchpel, director of research and analytics at Mamasource.
Now that it has switched to a 1TB Kickfire appliance, Mamasource can load the data in less than an hour while simultaneously querying the data warehouse, Ketchpel said. Moreover, queries generally run 20 times faster, he said.
Kobielus generally likes Kickfire. "It brings a lot of different things into one package," he said. He also likes the company's targeting of the large MySQL user base.
Kobielus did note that Kickfire's technology can't be "scaled out" into a grid of Kickfire appliances. That could be a problem for users whose data warehouses are growing into the "dozens of terabytes," he said.
That won't be an immediate issue for Mamasource, added Ketchpel, who plans to upgrade to a Kickfire appliance with more storage after several years while depreciating the cost of its existing appliance.
The biggest potential obstacle for Kickfire, which raised $20 million in Series B funding last summer, is that the "data warehousing appliance market is already so crowded," with competitors such as Greenplum Inc., Dataupia Inc. and Sybase Inc.'s IQ database all coming in slightly cheaper than Kickfire on a price-per-terabyte basis, Kobielus said.
Data warehousing vendors such as Kickfire are also starting to face competition from cloud-based providers, with their low start-up costs, Kobielus said.
"The environment is rapidly commoditizing," he said. "As impressive as Kickfire's technology is, a lot of users will just say, 'So what? There are other ways to skin a cat.' "
Clarification: After the story was posted, Kickfire clarified that contrary to an analyst comment, its appliance relies on Intel x86 chip technology and not Sun Microsystems'. As a result, incorrect information was deleted.
Read more about Business Intelligence/Analytics in Computerworld's Business Intelligence/Analytics Topic Center.
- Virtually Delivered High Performance 3D Graphics "A picture is worth a thousand words." That old phrase is as true today as it ever was. Pictures (i.e., those with heavy...
- Who does NSS Labs "Recommend" for NGFW? In 2012, NSS Labs found that most available NGFW solutions "fell short in performance and security effectiveness." In 2013 NSS Labs noted "marked...
- CIOs Deliver Productivity Breakthroughs with Intelligent Digital Signage Retailers have long recognized the influence that digital signage provides over a shopper's point-of-purchase decision making process.
- Improving Business Value of WAN Optimization Want to achieve faster ROI with WAN optimization? Read the latest IDC report and discover how you can cut IT costs without compromising...
- Live Webcast IBM FlashSystem V840: Leveraging Software-Defined Flash to Drive Your Business With end-to-end, tightly integrated functionality and super-fast flash technology, products like IBM FlashSystem V840 Enterprise Performance Solution empower businesses to leverage the efficiency...
- What should I look for in a Next Generation Firewall? SANS Provides Guidance With so many vendors claiming to have a Next Generation Firewall (NGFW), it can be difficult to tell what makes each one different....
- IBM FlashSystem V840: Leveraging Software-Defined Flash to Drive Your Business With end-to-end, tightly integrated functionality and super-fast flash technology, products like IBM FlashSystem V840 Enterprise Performance Solution empower businesses to leverage the efficiency... All Networking White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!