Post reply

FCI + AG Alwayson 2014

  • October 14, 2016 at 2:07 pm

    #331355

    Hi Guys,

    I need some one to clarify please. It very urgent.

    We have Two stand alone SQL Server 2014 server (Production)

    Lets assume names like SERVER A , SERVER B.

    We want to have FCI + AG configured on it.

    I am thinking, we need to first create the Windows Failover Cluster and we get name (example: WindowsclusterSQL)

    Once, created , we need to Configure Quorum settings.

    Then, we can Go to SERVER A and go to AlwaysonHighAvailability and go through the wizard setup.

    Thanks

    NKaka

  • October 14, 2016 at 2:25 pm

    #1906700

    Hi Guys,

    The reason, why I am asking this question is , Especially FCI + AG (SQL SERVER 2014)

    The SQL server instances are already present in production systems.

    Can we still achieve FCI + AG on the current environment.

    Server A has also replication configured to MYSQL server.

    So, let me know if we have FCI + AG , can we still have the replication in Place ?

    Thanks

    Nkaka

  • October 17, 2016 at 4:09 am

    #1906819

    Will you only have two servers in total?

  • October 17, 2016 at 7:30 am

    #1906857

    You will need a minimum of 3 servers to achieve FCI+AG.

    Server A and B will be the FCI. Only 1 can be run AO Replica 1 (Primary AO)

    Server C AO replica 2 (Secondary AO)

    All will need to be in a Windows Cluster not to be confused with a FCI cluster.

    AO failover can only occur between A or B to C.

    AO failover cannot be done between A and B as this is the FCI.

  • October 17, 2016 at 11:49 am

    #1906956

    Hi, Thank you for responding.

    But, Lets say I want to have ONLY two Servers, Server A and Server B already existing.

    can I make them SQL clustered.

    I know for a new installation example: Server C and Server D , We can make them SQL server Clustered. Since, they are going to be part of new sql cluster installation setup.

    Can SQL cluster be configured on two standalone servers.(Example: between already existing Server A and Server B).

    I think only windows failover cluster can be configured and then we can have AG built on it.

    Is my understanding correct.

  • October 18, 2016 at 2:14 am

    #1907064

    nkaka009 (10/14/2016)

    Hi Guys,

    We want to have FCI + AG configured on it.

    You cannot have FCI + AG on two nodes. This is a three node minimum setup.

    The FCI will take up 2 nodes. Only one availability group can exist on the FCI.

  • October 18, 2016 at 2:27 am

    #1907066

    That's what I was getting at with my question. (Also, even if you could do it, I can't think why you would.)

  • October 18, 2016 at 12:46 pm

    #1907244

    Thank you providing details.

    It is helpful for me.

  • October 18, 2016 at 12:53 pm

    #1907246

    Replying to this Question:

    That's what I was getting at with my question. (Also, even if you could do it, I can't think why you would.)

    The reason we want to do it, We have replication setup on Server A , to MYSQL Server C.

    That's reason, in the even the Server A goes down, The distribution database will not move to another node if its just AG.

    So, I am looking for FCI + AG

    Let me know if this make sense.

    Thanks

    kaka

  • October 19, 2016 at 7:11 am

    #1907407

    Talib123 (10/17/2016)

    AO failover can only occur between A or B to C.

    also note that this failover cannot be automatic, it must be manual failover

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply