The MySQL Appliance

From Visual Basic to GNU C, this is the place to talk programming.

Moderators: SecretSquirrel, just brew it!

The MySQL Appliance

Postposted on Thu May 01, 2008 12:14 am

Over at O'Reilly...
Dustin Puryear wrote:Well, this is nifty. A start-up named Kickfire has released a MySQL appliance. There is nothing “nifty” about a network appliance of course; that is, unless the appliance has specialized hardware and software to outperform a similarly configured in-house configured server.

And that is the point behind Kickfire.

They have designed a specialized processor for SQL servers and integrated this with MySQL using customized code. Apparently, the box screams.

I first read about this on Jason Perlow’s blog, and he goes into greater detail, including notes about how this may set a trend for appliance based SQL servers running PostgreSQL, Oracle, and even Microsoft SQL Server. MS-SQL on an appliance? Now that would really be nifty.

Transaction Processing Performance Council
Kickfire

Looks pretty sweet.
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.
titan
Grand Gerbil Poohbah
 
Posts: 3276
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains

Re: The MySQL Appliance

Postposted on Thu May 01, 2008 3:39 am

With such a thing, is the loss of general processing capability an issue? I know very little about databases but I do know that specialized hardware does things outside of its specialization fairly poorly (i.e. telling a GPU to nonparallelizable tasks that are better suited for the CPU).
2600K @ 4.8GHz; XSPC Rasa/RX240/RX120 Phobya Xtreme 200; Asus P8Z68-V Pro; 16GB Corsair Vengeance 1333 C9; 2x7970 OC w/ Razor 7970; Force GT 120GB; 3x F3 1TB; Corsair HX750; X-Fi Titanium; Corsair Obsidian 650D; Dell 2408WFP Rev. A01; 2x Dell U2412m
mortifiedPenguin
Gerbil Elite
 
Posts: 812
Joined: Mon Oct 08, 2007 7:46 pm

Re: The MySQL Appliance

Postposted on Thu May 01, 2008 4:17 am

thats odd, if they can get better performance out of dedicated hardware it begs the question of why hasn't it happened sooner.. not like its a new market
blitzy
Gerbil Jedi
 
Posts: 1779
Joined: Thu Jan 01, 2004 6:27 pm
Location: New Zealand

Re: The MySQL Appliance

Postposted on Thu May 01, 2008 7:31 am

mortifiedPenguin wrote:With such a thing, is the loss of general processing capability an issue?

Probably not. Anyone who buys this thing is likely buying it because it's a better value than general processing. Companies that are sufficiently large will build servers to run just one database. Third party data warehouses would probably like that appliance too because that's all they need the thing to run.

blitzy wrote:thats odd, if they can get better performance out of dedicated hardware it begs the question of why hasn't it happened sooner.. not like its a new market

Dedicated hardware has always had better performance than general hardware when it comes to a specific task. I'm guessing it didn't happen sooner because SQL is a little more difficult to process.
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.
titan
Grand Gerbil Poohbah
 
Posts: 3276
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains

Re: The MySQL Appliance

Postposted on Thu May 01, 2008 7:42 am

Of what database work I've done, none of it being of an enterprise level, I'd imagine that this would be useful for very large databases and the applications they interface with to dedicate processing and memory resources to. So your web server is only serving pages and content and the database itself has a dedicated work horse behind it. Am I understanding it properly?
Corsair 600T | ASUS P8P67 PRO | Intel 2500k @ 4.4Ghz | EVGA 560 TI | G.SKILL Ripjaws Series 8GB | Corsair HX650 650W
steelcity_ballin
Gerbilus Supremus
Silver subscriber
 
 
Posts: 11916
Joined: Mon May 26, 2003 5:55 am
Location: Pittsburgh PA

Re: The MySQL Appliance

Postposted on Thu May 01, 2008 8:46 am

pete_roth wrote:Am I understanding it properly?

That seems to be the idea. Although I think it's more for data warehouses than Web sites, it shouldn't be a big deal. NewEgg.com might become a little quicker if they used this.
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.
titan
Grand Gerbil Poohbah
 
Posts: 3276
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains

Re: The MySQL Appliance

Postposted on Thu May 01, 2008 3:12 pm

blitzy wrote:thats odd, if they can get better performance out of dedicated hardware it begs the question of why hasn't it happened sooner.. not like its a new market


Simply put: The separation between hardware vendors and software developers.
Intel i7 860, Asus P7P55D Pro, 4x2GB Corsair XMS3 1600 (CMX4GX3M2A1600C9), EVGA GTX 560 Ti Superclocked
Seagate 7200.7 160GB, WD Caviar Black 640GB, WD Caviar Green 1TB, WD Caviar Green 2TB
Dell 2408WFP and Dell 2407WFP-HC for dual-24" goodness
emorgoch
Gerbil Elite
 
Posts: 690
Joined: Tue Mar 27, 2007 11:26 am
Location: Toronto, ON

Re: The MySQL Appliance

Postposted on Thu May 01, 2008 3:16 pm

titan wrote:NewEgg.com might become a little quicker if they used this.

Sorry, but NewEgg is based in .NET and uses MS SQL. That said, what it already does is quite impressive for a .NET-based storefront. They seem to have done a phenomenal job of getting it to scale.
JdL
286DX > Pentium Pro 200 > Athlon 1000 @ 1.4 GHz > Athlon 64 2.2 GHz > Athlon XP 3200+ > Core 2 Duo 3300 @ 4.0 GHz > Core 2 Quad 6600 G0 @ 3.2 > Core i7 3770 @ stock
JdL
Gerbil Elite
 
Posts: 999
Joined: Thu Aug 29, 2002 11:45 am
Location: United States of America

Re: The MySQL Appliance

Postposted on Fri May 02, 2008 7:56 am

Is this thing going to be cheaper than a regular box?
Image
The Model M is not for the faint of heart. You either like them or hate them.

Gerbils unite! Fold for UnitedGerbilNation, team 2630.
Flying Fox
Gerbil God
 
Posts: 24497
Joined: Mon May 24, 2004 2:19 am

Re: The MySQL Appliance

Postposted on Fri May 02, 2008 11:11 am

Flying Fox wrote:Is this thing going to be cheaper than a regular box?

That's what I'm guessing. I haven't emailed them for a quote or anything because I don't need something like that. (My PII 233MHz is quite capable for the moment.)
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.
titan
Grand Gerbil Poohbah
 
Posts: 3276
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains


Return to Developer's Den

Who is online

Users browsing this forum: No registered users and 0 guests