• several computers corresponding to the nodes of the cluster.
• a computer used to host the coordinator (this computer can be one of the cluster nodes).
• a DNS server. Indeed, the access to the cluster is done by sharing the name of a virtual machine associated with the IP addresses of the different nodes.

Tips

• Operating system: all server versions of Windows supported by Microsoft. 32 and 64-bit editions are supported.
• Memory: 512 MB
• Disk: 20 MB for the cluster elements + size of the databases
• Network: 100 Mbps between the nodes. The IP addresses of the nodes must be fixed.

• Operating system: Windows Server in a version currently supported by the editor.
  It is recommended to use:
  • the most recent version to incorporate the latest security protocols,
  • a version that is not at the end of its lifecycle (https://docs.microsoft.com/en-us/lifecycle/faq/general-lifecycle).
• Processor: a multi-core processor is recommended
• Memory: 4 GB
• Disk: a RAID system

• The computer that hosts the coordination service of the cluster requires a less powerful configuration. Typically, the coordinator can be located:
  • on one of the nodes,
  • on the same server as the DNS of the local network,
  • on another computer.
• The port 4997 used by the cluster coordinator must be opened in the Windows firewall.
• The ports used by the nodes and the port 4998 must be opened in the Windows firewall on each server.

1. Start the HFSQL Cluster setup wizard.
2. Accept the terms of the license agreement to continue the setup.
3. Select "Create a new cluster".
4. A short text summarizes the principle of a cluster and the steps for its implementation. Go to the next plane.
5. You can choose to convert an existing HFSQL server into first node of the new cluster or to install a blank cluster. When converting an existing server, specify the name of the server (and the listening port of HFSQL).
6. Enter the setup parameters of the coordinator. These parameters are:
   • The name of the computer on which the service of the coordinator must be installed.
   • The password for managing the cluster. This password will be used in the HFSQL Control Center or through programming for cluster maintenance operations (add nodes, stop and restart, etc.)
   • The DNS name of the cluster: it is the name from which the cluster will be accessible on the network. For more details, see "Configuring the DNS for the access to the cluster".
7. Describe the composition of the cluster. You can add the different nodes of the cluster.
   If you have chosen to convert an existing HFSQL server, this one will be automatically proposed.
   Reminder: A cluster must include at least three computers. In order for the coordinator to be installed on the same computer as a node, the cluster must include at least three nodes. If the cluster contains two nodes only, the coordinator must necessarily be found on a third computer.
8. Enter the port number that will be used for the HFSQL connections. This port number will be shared by all the cluster nodes. Therefore, it must be available on each computer that hosts a cluster node. Go to the next plane.
9. The summary of the selected configuration is displayed. You can go back to the previous steps of the wizard to modify the cluster configuration.
10. Click "Next". A custom installation package is automatically created. You can:
    • Continue setup. The different computers included in the cluster must be accessible.
    • Use an installation package. This package must be run on each computer included in the cluster.

• Record of (A) type if the nodes are in IPv4 and record of (AAAA) type if they are in IPv6.
• The IP address of the record is the one of the node.
• The name of the record is the DNS name of the cluster. This name can be chosen freely. It must not correspond to the name of a real computer.

Configuring the DNS from the HFSQL Control Center

1. Start the HFSQL Control Center.
2. Connect to the cluster by specifying the address of the coordinator.
3. If the DNS name of the cluster was not configured yet, a row is displayed in the "Potential problems" table.
4. Click the icon for problem resolution (at the end of the row).
5. Specify the DNS server to configure, the domain name to use (in most cases, the domain name of the local computer) as well as the authentication parameters if they are required for the connection to the DNS server.
6. Validate the window.
7. In the dialog box, enter the DNS name that will be used by the client computers to connect to the cluster.
8. Validate the dialog box.

• Both 32-bit and 64-bit HFSQL servers can be used as nodes of the same cluster.
• All the servers of a cluster must use the same listening port. This port must be chosen during the setup.

Installing a new HFSQL server on the local computer as cluster node

1. Start the HFSQL Cluster setup wizard.
2. Choose "Add a node to an existing cluster".
3. Enter the parameters for accessing the coordinator: computer name and management password.
4. Modify the composition of the cluster. Several nodes can be added in a single operation.
5. A summary allows you to check the cluster configuration before applying the modifications.
6. Click "Next". A custom installation package is automatically created. You can:
   • Continue setup. The different computers included in the cluster must be accessible.
   • Use an installation package. This package must be run on each computer included in the cluster.

Uninstalling a node or a cluster

1. On the computer of the coordinator, start the HFSQL Cluster setup wizard.
2. Select "Uninstall a cluster or nodes".
3. Specify the password of the coordinator.
4. Check the elements that must be uninstalled.
5. Validate. The uninstall operation is performed.