PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Required configuration
To install a 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 setup pack is required to use HFSQL Cluster.
This pack is available at no extra cost for any person owning a commercial license in version 23.
To get this pack, send your request via a message to the Free Technical Support (select "?.. Request to the technical support" in the editor of WINDEV, WEBDEV or WINDEV Mobile). To get this pack, send your request via a message to the Free Technical Support from WINDEV, WEBDEV or WINDEV Mobile: on the "Home" pane, in the "Online help" group, expand "Help" and select "Request to the technical support".
Caution:
A specific setup pack 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 23.
Note: From version 19, HFSQL is the new name of HyperFileSQL.

Tips

To avoid differences in performances, 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: Windows 2000 or later (the 32-bit and 64-bit versions 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 2003 Server or 2008 Server (R1 or R2)
  • Processor: a multi-core processor is recommended
  • Memory: 4 GB
  • Disk: a RAID system
Notes:
  • 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 setup wizard of HFSQL Cluster.
  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 in programming for the maintenance operation of the cluster (adding nodes, stopping and restarting, ...)
    • The DNS name of the cluster: it is the name from which the cluster will be accessible on the network. See "Configuring the DNS for accessing the cluster" for more details.
  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 planes of the wizard to modify the configuration of the cluster.
  10. Click the "Next" button. A custom setup pack is automatically created. You can:
    • Continue the setup. The different computers included in the cluster must be accessible.
    • Use a setup package. This package must be run on each computer included in the cluster.
Note: 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.
Note: 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 the one given as server address in the Connection variable, or in HOpenConnection or HDescribeConnection. 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.
Notes:
  • 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 setup wizard of HFSQL Cluster.
  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 configuration of the cluster before applying the modifications.
  6. Click the "Next" button. A custom setup pack is automatically created. You can:
    • Continue the setup. The different computers included in the cluster must be accessible.
    • Use a setup 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 setup wizard of HFSQL Cluster.
  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.
Note: 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 required version
  • Version 15
This page is also available for…
Comments
Click [Add] to post a comment