Feeds

xkoto powers up DB2

GRIDIRON enters the game

Secure remote control for conventional and virtual desktops

Comment xkoto is a relatively new company - it only came to market late last year — however, it has some neat technology. The company's product, called GRIDIRON, provides dynamic load balancing for DB2 in transaction processing environments.

In particular, what GRIDIRON allows you to do is to build out clustered DB2 environments horizontally, across low-cost Linux (Red Hat and SUSE) boxes, as opposed to having to scale upwards in a more vertical fashion. In other words, it provides high availability, scalability and performance capabilities for DB2 environments that are not dissimilar to Real Application Clusters (RAC) for Oracle.

Now, xkoto is not the first vendor into this market. There are also products from Avokia, Continuent and Resonate. However, there are a number of ways in which these differ from GRIDIRON. For example, Continuent is focused on open source database environments, Avokia has a master-slave architecture while xkoto is peer-to-peer, and other vendors may have consistency issues under certain circumstances whereas xkoto guarantees 100 per cent consistency.

The way that GRIDIRON works is that when a create, update or delete request comes into the system then it is despatched to all of the nodes in the cluster and each starts processing that transaction. The first one that finishes returns the results to the requesting application (so that you get the fastest possible response) while the other nodes conclude in their own time to ensure consistency. In other words, this is an asynchronous load balancing capability. If one node fails to commit, then that node is evicted from the cluster and a queue is established of transactions that need to be processed by the failed node once it comes back online. However, the queue will have a user-defined capacity and, if that is exceeded, then restoring the failed node will require conventional back-up procedures. For this reason, xkoto always recommends at least three nodes in a cluster: then if one fails and needs to be restored and synchronised one of the working nodes can be designated for that task.

Read requests are treated differently: GRIDIRON maintains knowledge of the table states on each node and, when a query comes in it is despatched to the node that can best execute that read. Note that clusters do not have to be co-located and disaster recovery (DR) systems can even be included within a cluster, though if the network connection is relatively slow, the DR system can be excluded from read requests.

GRIDIRON physically resides between the application server and the database and it parses all incoming transactions before (in the case of reads) routing them to the relevant node. This, as you may imagine, imposes an overhead, typically of around 15 per cent. In other words, in a three node system performance should be approximately 2.7 (less .15 for each node after the first) times the performance of a single node implementation.

This technology has some significant advantages when compared to both native DB2 and Oracle RAC. For example, it not only provides load balancing but also replication (which would require a separate product in the case of IBM) and native capabilities for both high availability and disaster recovery.

Finally, it is important to note that xkoto is highly competitive in commercial terms: it charges at a flat rate per cluster, which should compare favourably with the CPU-based pricing model adopted by most other vendors.

Put this all together and GRIDIRON is a tool worth investigating. It should help existing DB2 installations. It should also help IBM to compete with Oracle RAC.

Copyright © 2006, IT-Analysis.com

The essential guide to IT transformation

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Munich considers dumping Linux for ... GULP ... Windows!
Give a penguinista a hug, the Outlook's not good for open source's poster child
Intel's Raspberry Pi rival Galileo can now run Windows
Behold the Internet of Things. Wintel Things
Linux Foundation says many Linux admins and engineers are certifiable
Floats exam program to help IT employers lock up talent
Microsoft cries UNINSTALL in the wake of Blue Screens of Death™
Cache crash causes contained choloric calamity
Eat up Martha! Microsoft slings handwriting recog into OneNote on Android
Freehand input on non-Windows kit for the first time
Linux kernel devs made to finger their dongles before contributing code
Two-factor auth enabled for Kernel.org repositories
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Top 8 considerations to enable and simplify mobility
In this whitepaper learn how to successfully add mobile capabilities simply and cost effectively.
Rethinking backup and recovery in the modern data center
Combining intelligence, operational analytics, and automation to enable efficient, data-driven IT organizations using the HP ABR approach.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.