Use cloud server's network to serve local server's content

I am trying to build a web application for a local community. I'd like to host a postgres database, a SSR frontend server, a REST backend server. The internet and electricity are pretty cheap here and I have a PC lying around. I have a few hard disks and I can raid them for redundancy. A similar spec AWS machine comes out to 170 USD and I think I can do much cheaper than that. I don't expect the application to scale to any level for the forseeable future (50 concurrent users max, same region). The only problem is that I don't have a static IP. IPv6 routing is not prevalent in my area. I can go for simpler BaaS but I want to learn as well.

I have a server on linode (single shared core, 1 GB RAM) with a static IPv4. How can I host everything on my local machine (maybe multiple KVM machines) and serve everything to people?

I have used this script to setup wireguard servers before. Can I use something like `nginx? Are there alternatives? How will my whole setup look like? If I were to use separate virtual machines for frontend, backend and database, how should I network them?

I understand there are many ways to approach this problem, I'm trying to get a feel of "if I can do it". I'd be happy if I can host my own server.

Ignore the server you have. Useless. Use Cloudflare Tunnel and you are done. A small docker level agent initiates all necessary connections to cloudflare and acts as router.

Another more general setup would be to use the linode server as a router and then establish a vpn from your server to it - I ran a company behind residential internet for ages like that (not the website, but people dialling in), for there was no real way to get anything else at that time... stupid limitation in some areas and countries.

It was possible with wireguard and nginx. Right now, the linode server has an ip address of say, 123.123.123.123 and the linode server has a wireguard ip address of 10.66.66.1. If my local server is connected to the same wiregaurd network, it has an ip of 10.66.66.10. Based on this answer, I created an nginx config

stream {
        upstream ssh1 {
                server 10.66.66.10:22;
        }
        server {
                listen 4575;
                proxy_pass ssh1;
        }
}

Now, if I ssh with ssh [email protected] -p 4575, the ssh connection is proxied by nginx to my local server. I think I can expose whatever service I want this way with nginx.

Ideally, I'd like to have a separate domain for my local server eg. (server1.example.com) and all connections go directly to the local machine. Let me know if that's possible.

Connect to the cloud server: Using a remote access tool like SSH, connect to the cloud server and configure it to retrieve the content from the local server. You can use a tool like rsync to transfer the content from the local server to the cloud server.

Serve the content: Once the content is transferred to the cloud server, configure it to serve the content to clients. This can be done using a web server like Apache or Nginx, or any other server software that can serve the content.

server's network to serve local server's content, making it accessible to clients from anywhere in the world. However, it's important to ensure that you have proper security measures in place to protect the content and prevent unauthorized access.