VMware Cloud Community
ZeMiracle
Enthusiast
Enthusiast

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

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                                                                                              |

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

0 Kudos
0 Replies