Is there a way to have an self-hosted instance that syncs data to hosted instance (so if self-hosted goes down, we switch to use hosted)?

I would suggest that you support the existing featue request: