I've got 2 linodes, currently the application server connects to the database server using an IP '192.168.xxx.xxx' as the specified host, a MySQL user is also specifed with an IP for the host
'user_application@192.168.xxx.xxx'. What I'd like to do is set this up so I can connect to my database with 'mysql.serverhostname' and have mysql users as 'user_application@serverhostname'.
Do I need to register a FQDN first then set this up in Linode's DNS manager? I'll be registering a domain soon so if it's a great deal of work I won't bother getting this to work without the FQDN. I'm new to networking so any guidance/tips would be much appreciated

I've created a hostname in /etc/hostname for each server.
And my /etc/hosts has:
Code:
127.0.0.1 localhost.localdomain localhost
127.0.1.1 serverhostname
192.168.xxx.xxx mysql