building exchange system - need help building worker drone!!!

[protech_systems]

Hello all, I am building an money exchange system as a project...basically like Paypal, but it will be different in many ways. The important part right now is getting a viable solution for tracking and updating account balances and handling transactions. It will run on a clustered MySQL or PostgreSQL database, and one of my Java programming buddies suggested that I create "robots/drones" ie multiple instances of a single handler script to update the database. My question is how should I approach adding and subtracing from account balances? I am trained as a database admin, so have that side down pretty well, but I need some suggestions on how to make the script perform this function. Any ideas, musings, etc are welcome and appreciated.

[cooldude832]

you shouldn't write it in mysql because the volume of work is outside the acceptable limits of mysql.  Oracle or somethign else is better

[protech_systems]

oracle might work...I'm pretty open to database options. My main concern right now is getting a production ready transaction handler. Are there any scripts available that might be adapted to do this? Scalability is priority 1. Thanks!

[cooldude832]

your asking for a random script that will manage million of dollars that you can trust from some random person.  I think you need to rethink your idea

[protech_systems]

:PNot really. Im just trying to get an idea how the handler would look and work. I can modify it for security. However, you're probably right in that I'll probably have to hire someone competent rather than try to depend on community hacks.