0 Replies Latest reply on Nov 29, 2017 2:25 AM by ZeMiracle

    Ho to deploy Windows Cluster instances (MSCS) SQL Allways On

    ZeMiracle Novice

      Hello,

       

      We need to build a Microsoft Failover Cluster (SQL Allways On).

      For this purpose, we need to assign several IP address on one port. Does it's a supported scenario with VIO 3.0 ?

       

      We follow this procedure that explain exactly what we try to do.

      OpenStack your Windows Cluster with Neutron Allowed Address Pairs – VMTrooper Blog!

       

      We get the Mac address of the clusters nodes instances and we use the following command to assign the ip to the port.

       

      **neutron port-update [PortID] --allowed-address-pairs type=dict list=true mac_address=[InstanceMacAddress] ,ip_address=[IP Assigned]**

       

      After this command, we are able to ping the IP address, but it doesnt work when the ip is "failover" on the other node.

      Does there is a need for additionnal step ?

      The tow node ports are member of a Security group that open everything.

       

      Here the configuration of the port.

      Thanks for help.

       

      Cluster Node 1

      +-----------------------+------------------------------------------------------------------------------------------------------------------+

      | Field                 | Value                                                                                                            |

      +-----------------------+------------------------------------------------------------------------------------------------------------------+

      | admin_state_up        | UP                                                                                                               |

      | allowed_address_pairs | ip_address='10.236.107.60', mac_address='fa:16:3e:5b:0f:69'                                                      |

      |                       | ip_address='10.236.107.61', mac_address='fa:16:3e:5b:0f:69'                                                      |

      | binding_host_id       | compute01                                                                                                        |

      | binding_profile       | None                                                                                                             |

      | binding_vif_details   | port_filter='True'                                                                                               |

      | binding_vif_type      | dvs                                                                                                              |

      | binding_vnic_type     | normal                                                                                                           |

      | created_at            | 2017-11-03T00:15:13                                                                                              |

      | data_plane_status     | None                                                                                                             |

      | description           |                                                                                                                  |

      | device_id             | 0d70d945-fadc-4f6c-91b2-f57b905d4c72                                                                             |

      | device_owner          | compute:xxxxx                                                                                                   |

      | dns_assignment        | None                                                                                                             |

      | dns_name              | None                                                                                                             |

      | extra_dhcp_opts       | None                                                                                                             |

      | fixed_ips             | ip_address='10.236.107.45', subnet_id='dbfb9357-b6fe-4bbb-984f-c40b48cfedd6'                                     |

      | id                    | 3eec998e-6c67-4982-a54c-8a31940e5bb6                                                                             |

      | ip_address            | None                                                                                                             |

      | mac_address           | fa:16:3e:5b:0f:69                                                                                                |

      | name                  |                                                                                                                  |

      | network_id            | e15aec11-9f2d-4db4-bf35-c8d7a37499d7                                                                             |

      | option_name           | None                                                                                                             |

      | option_value          | None                                                                                                             |

      | port_security_enabled | True                                                                                                             |

      | project_id            | 13a058fdf1af4a8fafdfd11b0fe948a8                                                                                 |

      | qos_policy_id         | None                                                                                                             |

      | revision_number       | None                                                                                                             |

      | security_group_ids    | 4b544075-41c8-4497-885c-da3e0cbd18b8, bf982517-9b63-4dd9-be39-a4c22b82dfc3, d9ce759e-da03-4a28-814e-cd20ea876e82 |

      | status                | ACTIVE                                                                                                           |

      | subnet_id             | None                                                                                                             |

      | tags                  | None                                                                                                             |

      | trunk_details         | None                                                                                                             |

      | updated_at            | 2017-11-03T00:15:13                                                                                              |

      +-----------------------+------------------------------------------------------------------------------------------------------------------+

      Cluster Node 2

      +-----------------------+------------------------------------------------------------------------------------------------------------------+

      | Field                 | Value                                                                                                            |

      +-----------------------+------------------------------------------------------------------------------------------------------------------+

      | admin_state_up        | UP                                                                                                               |

      | allowed_address_pairs | ip_address='10.236.107.60', mac_address='fa:16:3e:41:2a:05'                                                      |

      |                       | ip_address='10.236.107.61', mac_address='fa:16:3e:41:2a:05'                                                      |

      | binding_host_id       | compute01                                                                                                        |

      | binding_profile       | None                                                                                                             |

      | binding_vif_details   | port_filter='True'                                                                                               |

      | binding_vif_type      | dvs                                                                                                              |

      | binding_vnic_type     | normal                                                                                                           |

      | created_at            | 2017-11-28T12:56:52                                                                                              |

      | data_plane_status     | None                                                                                                             |

      | description           |                                                                                                                  |

      | device_id             | 41f71a95-caa6-4a2b-982d-c7e64c1a30fb                                                                             |

      | device_owner          | compute:xxxxx|

      | dns_assignment        | None                                                                                                             |

      | dns_name              | None                                                                                                             |

      | extra_dhcp_opts       | None                                                                                                             |

      | fixed_ips             | ip_address='10.236.107.46', subnet_id='dbfb9357-b6fe-4bbb-984f-c40b48cfedd6'                                     |

      | id                    | 70d3adbb-d095-49f4-8791-56225f466658                                                                             |

      | ip_address            | None                                                                                                             |

      | mac_address           | fa:16:3e:41:2a:05                                                                                                |

      | name                  |                                                                                                                  |

      | network_id            | e15aec11-9f2d-4db4-bf35-c8d7a37499d7                                                                             |

      | option_name           | None                                                                                                             |

      | option_value          | None                                                                                                             |

      | port_security_enabled | True                                                                                                             |

      | project_id            | 13a058fdf1af4a8fafdfd11b0fe948a8                                                                                 |

      | qos_policy_id         | None                                                                                                             |

      | revision_number       | None                                                                                                             |

      | security_group_ids    | 4b544075-41c8-4497-885c-da3e0cbd18b8, bf982517-9b63-4dd9-be39-a4c22b82dfc3, d9ce759e-da03-4a28-814e-cd20ea876e82 |

      | status                | ACTIVE                                                                                                           |

      | subnet_id             | None                                                                                                             |

      | tags                  | None                                                                                                             |

      | trunk_details         | None                                                                                                             |

      | updated_at            | 2017-11-28T13:11:33                                                                                              |

      +-----------------------+------------------------------------------------------------------------------------------------------------------+