I want to install an SQL instance on a server, lets call it NODE1. Single server for now but I want the option of chaning it into a cluster at a later date, so I was planning to use an additional name for the server, i.e. DATABASE1 (with another IP if needs be).Would this configuration work without any problems?
The idea is if we change it to a cluster later, we add NODE2 and make DATABASE1 the virtual name, meaning we dont need to change all the applications to point to a new server name.
So basically the question is; is it OK to have two hostnames for the same server (via dns) and use SQL without any problems? Any alternatives?