You'll never love an appliance like your old database

What stops you committing to the all-in-one hardware solution?


Appliance trade-offs

Much depends both on what’s in the box, and what’s outside it. An appliance may capitalise on the simplicity of its management layer, which enables and means to get a lot done with little effort. But in many data centres that already have their own management layer, that may be a moot point. In fact, they may want more visibility into the box than an appliance’s management API can provide.

This highlights one of the underlying complexities of the database appliance market: vendors take different approaches to the architectural designs of their products. For example, Oracle’s database appliance is known to be “hard-wired”, in the sense that it is a hermetically sealed stack, lovingly tweaked to squeeze as much performance out of the components therein as possible. It is not designed to be broken up in any way.

Other appliances – from companies such as HP, Dell or SAP – don’t have the same level of hard-wiring, although they offer the same kinds of benefits in terms of convenience and simplicity. “The difference with those things is that you can actually break them up if you want to, because they are based on standard components, but you have the advantage that they are preconfigured,” Vile says.

The level of engineering in the box will dictate the level of performance you get, but there’s always a price trade-off. You’re paying for that convenience. 451’s Stamper says there’s a ceiling for performance in these appliances.

“While the appliance vendors will be more than happy to sell ever-larger appliances, that obviously comes at a cost,” he explains. “This is one of the reasons that many companies attempt to keep some of their data in a cheaper platform – most commonly Hadoop – in order to keep as much capacity on the appliance free as they can, and delay an expensive upgrade to a larger appliance.”

Sizing the workload

Part of the problem with a database appliance is that workloads don’t always stay the same. Computing demand tends to peak in relation to business demand, which can make it difficult to make full use of the power in an appliance, or conversely, may lead to situations in which demand exceeds the capability of the box.

For this reason, businesses interested in a database appliance might want to consider purchasing models that go beyond simple capex. With its database appliance, Oracle offers a pay-as-you-grow software licensing option, which lets them turn on processor cores on demand, without needing to upgrade the hardware. That can help solve the scalability problem for small to mid-sized businesses that may be on a high growth path.

Whether they’re tightly bound, or simply a collection of parts preconfigured to save an IT team the hassle, database appliances still have a common issue: they’re usually siloed. This can make it harder for a database appliance to be integrated with a broader infrastructure. A database appliance may be excellent and provisioning storage for a testing environment, for example, but all of the storage is still located in or attached directly to that box. The management layer rarely sees beyond that storage into the broader ecosystem.

Moreover, the database appliance is a single-function box that will only ever do database work, suggesting that this seems like an artificial place to stop.

“Why would you stop at the database? Look at an IBM PureSystem or any of the preconfigured cloud-in-a-box type offerings that any of the vendors have, and they give you a whole VMware layer or HyperV layer, so you’re dealing with everything up the stack,” Vile says. “So database appliances to me still look pretty niche.”


Other stories you might like

  • North Korea pulled in $400m in cryptocurrency heists last year – report

    Plus: FIFA 22 players lose their identity and Texas gets phony QR codes

    In brief Thieves operating for the North Korean government made off with almost $400m in digicash last year in a concerted attack to steal and launder as much currency as they could.

    A report from blockchain biz Chainalysis found that attackers were going after investment houses and currency exchanges in a bid to purloin funds and send them back to the Glorious Leader's coffers. They then use mixing software to make masses of micropayments to new wallets, before consolidating them all again into a new account and moving the funds.

    Bitcoin used to be a top target but Ether is now the most stolen currency, say the researchers, accounting for 58 per cent of the funds filched. Bitcoin accounted for just 20 per cent, a fall of more than 50 per cent since 2019 - although part of the reason might be that they are now so valuable people are taking more care with them.

    Continue reading
  • Tesla Full Self-Driving videos prompt California's DMV to rethink policy on accidents

    Plus: AI systems can identify different chess players by their moves and more

    In brief California’s Department of Motor Vehicles said it’s “revisiting” its opinion of whether Tesla’s so-called Full Self-Driving feature needs more oversight after a series of videos demonstrate how the technology can be dangerous.

    “Recent software updates, videos showing dangerous use of that technology, open investigations by the National Highway Traffic Safety Administration, and the opinions of other experts in this space,” have made the DMV think twice about Tesla, according to a letter sent to California’s Senator Lena Gonzalez (D-Long Beach), chair of the Senate’s transportation committee, and first reported by the LA Times.

    Tesla isn’t required to report the number of crashes to California’s DMV unlike other self-driving car companies like Waymo or Cruise because it operates at lower levels of autonomy and requires human supervision. But that may change after videos like drivers having to take over to avoid accidentally swerving into pedestrians crossing the road or failing to detect a truck in the middle of the road continue circulating.

    Continue reading
  • Alien life on Super-Earth can survive longer than us due to long-lasting protection from cosmic rays

    Laser experiments show their magnetic fields shielding their surfaces from radiation last longer

    Life on Super-Earths may have more time to develop and evolve, thanks to their long-lasting magnetic fields protecting them against harmful cosmic rays, according to new research published in Science.

    Space is a hazardous environment. Streams of charged particles traveling at very close to the speed of light, ejected from stars and distant galaxies, bombard planets. The intense radiation can strip atmospheres and cause oceans on planetary surfaces to dry up over time, leaving them arid and incapable of supporting habitable life. Cosmic rays, however, are deflected away from Earth, however, since it’s shielded by its magnetic field.

    Now, a team of researchers led by the Lawrence Livermore National Laboratory (LLNL) believe that Super-Earths - planets that are more massive than Earth but less than Neptune - may have magnetic fields too. Their defensive bubbles, in fact, are estimated to stay intact for longer than the one around Earth, meaning life on their surfaces will have more time to develop and survive.

    Continue reading

Biting the hand that feeds IT © 1998–2022