A stream's contents is part of the blockchain, which is stored in full by every node connected to that chain. Perhaps you want to explain on a higher level, in terms of application, what you are trying to achieve, and we can recommend the appropriate setup in terms of blockchains, nodes and streams.