Feeds

xkoto powers up DB2

GRIDIRON enters the game

Intelligent flash storage arrays

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

Top 5 reasons to deploy VMware with Tegile

More from The Register

next story
Preview redux: Microsoft ships new Windows 10 build with 7,000 changes
Latest bleeding-edge bits borrow Action Center from Windows Phone
Google opens Inbox – email for people too thick to handle email
Print this article out and give it to someone tech-y if you get stuck
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
UNIX greybeards threaten Debian fork over systemd plan
'Veteran Unix Admins' fear desktop emphasis is betraying open source
Entity Framework goes 'code first' as Microsoft pulls visual design tool
Visual Studio database diagramming's out the window
Google+ goes TITSUP. But WHO knew? How long? Anyone ... Hello ...
Wobbly Gmail, Contacts, Calendar on the other hand ...
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
prev story

Whitepapers

Choosing cloud Backup services
Demystify how you can address your data protection needs in your small- to medium-sized business and select the best online backup service to meet your needs.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.
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.
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.