DivHunter does Linux (poorly): CentOS 7 cluster

Discussion in 'Other Operating Systems' started by DivHunter, Aug 1, 2018.

  1. DivHunter

    DivHunter Member

    Joined:
    May 31, 2005
    Messages:
    3,007
    Location:
    Melbourne
    My interest in MSSQL 2017 on Linux has brought me to attempting a HA cluster to test out.

    I successfully created a CentOS 7 based SQL 2017 VM joined to a domain with AD auth etc - yay

    I then created three VMs with CentOS 7 not on the domain. Installed SQL 2017 with Dev, Dev and Express editions on MSSQL-N1, MSSQL-N2 and MSSQL-W. I have created working HA group(s) with a witness.

    I am now trying to create the cluster so that synchronous groups can fail over.

    The problem is I can auth all the nodes but when I try and create the cluster:

    Error: MSSQL-N1: unable to authenticate to node
    Error: MSSQL-N2: unable to authenticate to node
    Error: MSSQL-W: unable to authenticate to node

    I have cleared out the pcsd files and logs, there is no corosync conf file and restarted the service and tried again. I have changed the hacluster user password on all systems to be sure it is correct but it auths so that should be fine.

    If I curl -k https://mssql-w:2224/remote/node_available I get "notauthorized":"true" despite the pcs auth command suggesting it is authed.

    What am I doing wrong? It seems like it should be fairly straight forward.
     
  2. GumbyNoTalent

    GumbyNoTalent Member

    Joined:
    Jan 8, 2003
    Messages:
    5,674
    Location:
    Briz Vegas
    Few questions related to MSSQL as I have NFI on MSSQL Clusters over the past 5 years.

    1. Dev and Express versions allow clustering?
    2. MSSQL clustering is a thing for their Linux version?
    3. What hypervisor on what platform?

    EDIT - before we start on resolving communication issues if they exist.
     
  3. OP
    OP
    DivHunter

    DivHunter Member

    Joined:
    May 31, 2005
    Messages:
    3,007
    Location:
    Melbourne
    Dev is basically a never ending trial with all the features, Express can only be witness / config

    Yes - https://docs.microsoft.com/en-us/sq...ilability-group-overview?view=sql-server-2017

    Server 2016 Hyper-V

    Clustering on Windows for SQL is completely different as SQL is far more aware of the state of the systems. On Linux it seems like it just assumes it's all being taken care of. As far as SQL is concerned the cluster is operating already which confused me on initial install as everyone had the SQL installs being the first thing and that seemed backwards to me.
     
  4. GumbyNoTalent

    GumbyNoTalent Member

    Joined:
    Jan 8, 2003
    Messages:
    5,674
    Location:
    Briz Vegas
    So your current issue is?
     
  5. OP
    OP
    DivHunter

    DivHunter Member

    Joined:
    May 31, 2005
    Messages:
    3,007
    Location:
    Melbourne
    Unable to actually create the linux cluster to do cluster things. pcs cluster setup fails.

    In a Linux environment SQL cannot fail over anything itself it requires the external system cluster do the cluster smarts otherwise it's glorified log shipping.
     
  6. OP
    OP
    DivHunter

    DivHunter Member

    Joined:
    May 31, 2005
    Messages:
    3,007
    Location:
    Melbourne
  7. GumbyNoTalent

    GumbyNoTalent Member

    Joined:
    Jan 8, 2003
    Messages:
    5,674
    Location:
    Briz Vegas
  8. OP
    OP
    DivHunter

    DivHunter Member

    Joined:
    May 31, 2005
    Messages:
    3,007
    Location:
    Melbourne
  9. Wako

    Wako Member

    Joined:
    Jun 4, 2006
    Messages:
    488
    what do klist/kinit say?
     

Share This Page