Re: multiple DB and one APP

Hi,

That looks like an interesting project, but your requirements are not very clear.
Let me try to put in my words and see if I understand your requirement: You multiple systems connected to a data storage. Your so called "database server" runs in a coordinated fashion on these multiple machines. In a way your database server is a distributed application(server). When a DB request arrives it is distributed (in some manner) to the coordinating DB server nodes so that they parallely run the query and then finally coordinate to return one single result. So this is one way where your database server itself is ditributed.

Second way I can think of is that the same database server runs on multiple machines, not actually coordinating in any manner. All that functionality is now put into the application server running above the database server(s). That application when gets a DB request, recreate multiple requests for all servers such that they return non overlapping results and then the results from different servers is accumulated and parsed by the application server to finally return the result.

Which kind of system you plan to design? Also, is your storage also going to be distributed? If not, your storage can itself be a bottleneck in such a system. Hope it helps.

• Ajay Kumar