Results 1 to 3 of 3

Thread: Way to create the equivalent of a "SQL ALIAS" for Lianja SQL connections

  1. #1
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,942

    Way to create the equivalent of a "SQL ALIAS" for Lianja SQL connections

    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...ql-server-2017

    Is there a way to do this with the LSS?

    thanks,

    Hank

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    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/1093...me-lan-network
    Last edited by barrymavin; 2018-05-12 at 03:32.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,942
    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/...cname-records/

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

    thanks,

    Hank

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us