I am running a small hosting service and from time to time I have a new user using cloudflare.
To use cloudflare users
1) copy the DNS zone via the cloudflare interface
2) set cloudflare nameservers
In the DNS zone there is a bunch of A records such as
apex.com A 6.6.6.6
www A 6.6.6.6
However from time to time I need to move websites across servers with different IPs.
I would replace A records with CNAME records eg.
apex.com CNAME apex.hosting.com
www CNAME apex.hosting.com
if it weren't for the SOA/NS vs zone apex CNAME issue.
What alternative is open to overcome this problem at DNS zone level?
It's beyond me why I can't find a solution to such a problem at DNS zone level.
Load balancer/virtualization are not an option unfortunately.