YES!!!
I haven't gotten the chance to poke around too much, but so far it seems like OpenSSI and OpenMOSIX is the exactly type of application/system that I'm looking for.
I guess that this whole time I wasn't perhaps looking for a "load balance cluster" but a "Single-system image or SSI cluster" as I found this term defined on wikipedia. So that could be the reason why I couldn't find the right application that needed when I did a google search.
One other thing that I did find interesting while reading about Single-system image on wikipedia, is that DragonFly BSD has SSI (Single-system image) as one of its long term goal.
Things should be very interesting for next couple of months (maybe less) as I'll be trying to implement a Single-system image cluster.
Please let me know if any of guys has ever done something like that. I would like know if its working for you.
Thanks once again guys! You really helped me out to know what I need to use.