A faster, sleeker way to do MySQL?

April 15, 2009, 10:07 AM —  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.

Sign up for ITworld's Daily newsletter
Follow ITworld on Twitter @IT_world

I like it!
Close

On Twitter now

mysql

Powered by Twitter
You are logged in | Sign out
Sign in and post to Twitter

What are you thinking?

Cancel Tweet sent

On Twitter now

Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
peer-to-peer

Esther Schindler
If the comments are ugly, the code is ugly

claird
SVG a graphics format for 21st century

pasmith
Take Chrome OS for a test spin

Sandra Henry-Stocker
Solaris Tip: Have Your Files Changed Since Installation?

sjvn
64-bits of protection?

jfruh
Android fragments vs. the iPhone monolith

mikelgan
What Gizmodo missed about the Pro WX Wireless USB disk drive

 

Where Google Chrome security fails: the password
I heard mention that the Chrome OS will have some sort of encryption available a la bitlocker. If it's possible to encrypt personal data using another password or key, then it may have potential for very secure data.... And Ubuntu has an 'encrypt home directory' option, perhaps google should follow suit.
- Dann

Join the conversation here

The Daily Tip

The Daily TipQuick, practical advice for IT pros. Made fresh daily.

Hot tips:

Want to cash in on your IT savvy? Send your tip to tips@itworld.com. If we post it, we'll send you a $25 Amazon e-gift card.

Newsletters

Subscribe to ITWORLD TODAY and receive the latest IT news and analysis.

I would like to receive offers via email from ITworld partners.
By clicking submit you agree to the terms and conditions outlined in ITworld's privacy policy.
Featured Sponsor

AISO founders envisioned a Web hosting company that was environmentally friendly. While the company employed energy-efficient innovations like solar panels, its infrastructure produced unacceptable power and cooling requirements. Find out how AISO leveraged AMD technology to overcome their challenge in this case study white paper.

In this whitepaper, Scalar explores the opportunity to change the landscape with respect to mission critical databases built around Oracle. Leveraging technologies such as Linux, high-end commodity processing power and Oracle RAC technology to architect, design, build and maintain database infrastructure that delivers maximum availability, reliability and performance at a fraction of traditional cost.

On a typical day, weather.com, the Web site for The Weather Channel in Atlanta, serves up between 15 million and 20 million page views. But in September 2004, when back-to-back hurricanes ransacked Florida, the peak traffic on one day more than tripled: over 70 million page views by more than 7 million unique visitors. Read the full success story now.

Marketplace