I've got a domain name and hosting web content with a provider, so have for example server.example.com hosted in the cloud. The provider also manage my DNS.
Now I would like to run nextcloud on my home server (and expose it to the internet) and could be called cloud.example.com
From outside my home network I can connect to cloud.example.com as I've setup a DNS entry to point to my ADSL IP Address (Static)
The problem I'm having is on my home wifi I need to connect to cloud.example.com which is on my private network (192.168.1.2) and when I'm external to this cloud.example.com points to my public IP.
Is it possible to setup a bind9 server on my home network so I have a entry for cloud.example.com to point to 192.168.1.2, while all other entries (www.example.com and server.example.com) forward DNS requests to my hosting NS.