PDA

View Full Version : Way to create the equivalent of a "SQL ALIAS" for Lianja SQL connections



HankFay
2018-05-12, 00:25
In MSSQL it's possible to create a SQL Alias so that if a server is changed for any reason, all the calling apps can be directed to the new server by a single change. https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-2017

Is there a way to do this with the LSS?

thanks,

Hank

barrymavin
2018-05-12, 04:05
Lianja SQL Server and Lianja Cloud Server use TCPIP to connect to local and remote servers.

When a FQDN (Fully Qualified Domain Name) is specified as opposed to a numeric IP address standard DNS lookup is used.

You can setup DNS aliases to solve this problem.
https://support.dnsimple.com/articles/alias-record/

You could also target a load balancer Virtual IP which will handle HA and redundancy as well as the ability to hot swap servers.

This is the most common way to handle infrastructure changes.

Alternatively you can use a proxy Server.
https://en.m.wikipedia.org/wiki/Proxy_server

Or setup your own DNS server on a Linux VM
https://superuser.com/questions/1093419/alias-for-ips-in-the-home-lan-network

HankFay
2018-05-12, 06:58
Hi Barry,

I hadn't realized that a DNS alias could be used within the network. That's great, thanks.

Here's an MS reference on how to accomplish this for those interested: https://blogs.technet.microsoft.com/askpfeplat/2017/06/19/using-computer-name-aliases-in-place-of-dns-cname-records/

Understood about load balancing: that's for a future time, perhaps.

thanks,

Hank