ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL Cluster
  • Required configuration
  • Tips
  • Creating a cluster
  • Configuring the DNS for accessing the cluster
  • Configuring the DNS from the HFSQL Control Center
  • Installing a new node
  • Installing a new HFSQL server on the local computer as cluster node
  • Uninstall operation
  • Uninstalling a node or a cluster
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Installing and configuring HFSQL Cluster
HFSQL Client/ServerAvailable only with this kind of connection
Required configuration
To install an HFSQL Cluster, you must have:
  • 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.
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.
Caution: All the servers and computers must be running Windows. The clusters are not available in Linux.
Caution:
A specific installation package is required to use HFSQL Cluster.
This pack can be downloaded at no extra cost on PC SOFT site, in the download section of modules common to version 2024.

Tips

To avoid differences in performance, the configuration of each one of the cluster nodes must have the same order of power (processor and memory).
The minimum configuration required to install HFSQL Cluster is as follows (for each node):
  • 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.
The recommended configuration for installing HFSQL Cluster depends on the size of the databases, their complexity and the number of clients. The following configuration will be robust in most cases (for each node):
  • Operating system: Windows Server in a version currently supported by the editor.
    It is recommended to use:
  • Processor: a multi-core processor is recommended
  • Memory: 4 GB
  • Disk: a RAID system
Remarks:
  • 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.
Creating a cluster
To create a cluster:
  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.
Remark: A single coordinator can be installed on a given computer. If two clusters are installed on the same network, their respective coordinators must be found on two different computers.
Configuring the DNS for accessing the cluster
To give access to the cluster, a record must be added into your DNS server for each node. This operation is automatically performed when installing the cluster and the nodes. When the automatic modification of DNS is not possible (DNS server not supported, rights problem, etc.), the record must be added manually.
Remark: To guarantee a proper operating mode of the DNS system, it is imperative that the IP addresses of the nodes do not change. If the servers get their IP addresses via a DHCP, it must be configured so that a fixed address is reserved for each one of the cluster nodes.
Characteristics of the DNS records to create:
  • 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.
When a client application wants to connect to the cluster, it retrieves the DNS records corresponding to the name chosen for the cluster: this name is specified as server address in the Connection variable, or in the HOpenConnection or HDescribeConnection functions. The client computer will select the node used for connection among the different IP addresses.
The DNS record can be created once the cluster is installed, by using the HFSQL Control Center.

Configuring the DNS from the HFSQL Control Center

To configure 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.
Installing a new node
All the nodes, except for the first one, must necessarily be new HFSQL servers.
You also have the ability to install a new server as first node of the cluster. In this case, the cluster will contain no initial database.
Remarks:
  • 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

To install 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.
Uninstall operation

Uninstalling a node or a cluster

To uninstall a cluster node or the entire 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.
Remark: This uninstall operation can also be performed from the HFSQL Control Center. In this case, you have the ability to temporarily exclude a node from the cluster without having to uninstall it.
Minimum version required
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/31/2024

Send a report | Local help