Home | Click here to send an email to the editor of this weblog. Updated: 5/1/2003; 12:32:46 PM. 

  Synthetic Morpheme
Christopher Taylor's editorials on Science, Technology, Salsa dancing and more

daily link  Wednesday, April 30, 2003

Disk RAID is a way to take multiple inexpensive harddrives and to use them together to provide improved performance, redundancy and fault tolerance. Now, the basic concepts of RAID have been applied to SQL databases with Clustered JDBC (C-JDBC) [Slashdot]. The basic idea is to put a thin JDBC layer in front of any JDBC compliant database. All JDBC calls are proxied by C-JDBC and replicated to the underlying databases themselves.

The potential advantages in load balancing, redundancy and fault tolerance are clear. For instance, queries can be handled by any single box, thus minimising the load on a per-database basis. Inserts and updates will still need to be performed on all boxes, but this could also be optimized. Plus, if any of the database systems goes down, the other boxes in the cluster will assure that the overall system keeps running, though possibly in a degraded state.

MySQL has been working to add these features and Oracle has had much of this for years. But, with C-JDBC, it is now a simple matter to slap this functionality on top of any database you like. 10:50:17 AM  permalink  comment []  


 
April 2003
Sun Mon Tue Wed Thu Fri Sat
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      
Mar   May

PicoSearch

A photo taken along the road from Edmonton to Salt Lake City. Photo Credit: Chris Winstead

Click to see the XML version of this web page.

Click here to visit the Radio UserLand website.


Copyright 2003 © Christopher Taylor. Click here to send an email to the editor of this weblog.
This work is licensed under a Creative Commons License
Last update: 5/1/2003; 12:32:46 PM.