Search results

  1. I

    Solved: How to use mssql with DRBD and pacemaker

    I have pieced together what I did best I can remember based on the resources I used. Note that this cluster is not safe for production because it can split brain very easily. My next step will be to use the second NIC card to jumper between the servers and use that for the cluster, as that would...
  2. I

    Solved: How to use mssql with DRBD and pacemaker

    I got it working!!!! I had to go back and install mssql_ha on the second node because I forgot that, and did the secret file on it too and failover was working but giving the above error and going slow, so I added an order constraint that the drbd filesystem had to be running before mssql could...
  3. I

    Solved: How to use mssql with DRBD and pacemaker

    So because it was buried in the part baout setting up NFS which I was not doing because I am using DRBD, I missed an important step about adding the username and password into the /var/opt/mssql/secrets/passwd file. I am not sure which user it wants me to put in their but I assumed the hacluster...
  4. I

    Solved: How to use mssql with DRBD and pacemaker

    hmmm, it works fine if I manually log in as that user. I am basically trying to follow these instructions: Configure Red Hat Enterprise Linux shared disk cluster for SQL Server at http://box.commie.cn/files/linux.pdf The only difference is I am using DRBD instead of NFS file sharing. I had...
  5. I

    Solved: How to use mssql with DRBD and pacemaker

    so I found the issue by running crm_mon: * mssqlha_start_0 on sql1 'invalid parameter' (2): call=20, status=complete, exitreason=' 2020/01/30 12:07:39 Could not read credentials file: could not read first line to extract username', last-rc-change='Thu Jan 30 12:07:38 2020', queued=0ms...
  6. I

    Solved: How to use mssql with DRBD and pacemaker

    I tried changing the order of the collocation constraints and it does the same thing. I even tried adding an order constraint so that theoretically the FS should boot up before MSSQL but it doesn't help. Interestingly if I remove those two colocation restraints for mssql all the other resources...
  7. I

    Solved: How to use mssql with DRBD and pacemaker

    so I can't get mssql to go, here is what I have: andrew@sql1:~$ sudo pcs constraint list Location Constraints: Ordering Constraints: promote drbd_res-master then start fs_res (kind:Mandatory) Colocation Constraints: fs_res with drbd_res-master (score:INFINITY) (rsc-role:Master)...
  8. I

    Solved: How to use mssql with DRBD and pacemaker

    ah, apparently by manually updating the "epoch" value in the config file to be higher
  9. I

    Solved: How to use mssql with DRBD and pacemaker

    So update I am all over the damn place trying to put bits and pieces of different instructions together from different sources. It turns out there are instructions for this, using pcs, but of course all my work up until that point had been using crm. It turns out pcs will just wipe out...
  10. I

    Solved: How to use mssql with DRBD and pacemaker

    Hi, I am fairly new to databases. We use software that uses mssql which typically runs on Windows machines, but we have a client that has only Linux servers. On two test servers I have successfully installed mysql, setup drdb, and setup pacemaker to switch which server has access to the drdb. I...
Top