It sounds like you're trying to reinvent distributed DBMSes here. Why not use an existing system such as [Bedrock](https://bedrockdb.com/)? At the very least, study its design and understand why it is designed that way before you begin work on your reinvented wheel. Distributed computing is **seriously hard.**