Frequently asked questions about HFSQL Cluster
Available only with this kind of connection
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 24.
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".
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 24.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
|Question||What is HFSQL Cluster?|
|Answer||HFSQL Cluster is a system for managing relational databases intended to be deployed on a group of servers (a cluster) in order to guarantee a high availability. See Overview of HFSQL Cluster for more details.|
|Question||What is the link between HFSQL Cluster , HFSQL Client/Server, HFSQL Classic and HFSQL Mobile?|
|Answer||These terms are used to identify the different editions of the HFSQL database. All these editions share the same file format which makes evolutions and data transfers very easy. All the editions also share the same statements for accessing the data.|
- HFSQL Cluster: cluster edition intended for critical architecture requiring high accessibility.
- HFSQL Client/Server: Client/Server edition. The databases are made available to the client applications by a database server.
- HFSQL Classic: Local or Network edition. The databases are stored in simple files that can be used by a single application on a local computer or that can be shared on a network.
- HFSQL Mobile: edition intended for the mobile the devices (Windows CE, ...)
|Question||What is the license proposed for using HFSQL Cluster?|
|Answer||The HyperFileSQL Client/Server license also applies to HFSQL Cluster.|
|Question||Does HFSQL Cluster require a specific hardware configuration?|
|Answer||HFSQL Cluster does not require any special investment to be implemented. See Installing HFSQL Cluster for more details.|
|Question||Is HFSQL CLuster intended for a specific type of applications?|
|Answer||All types of applications can be addressed by HFSQL Cluster, especially in the fields that require high data availability and/or the fields that require load balancing (Web hosting, ...).|
|Question||Do I have to modify my existing HFSQL Client/Server code to use HFSQL Cluster?|
|Answer||No. The code is entirely compatible between the different editions of HFSQL. However, in its current version, HFSQL Cluster has a few limitations compared to HFSQL Client/Server (these limitations are listed below). It is very important to run the test of any application intended to be deployed on a cluster before it is implemented.|
|Question||How many physical server are required to create a minimum cluster configuration?|
|Answer||At least three physical servers are required to create a configuration of HFSQL cluster: two of them will be the nodes of the cluster, the third one will run the service of the Coordinator (ClusterManager service).|
|Question||What is the maximum number of nodes in a HFSQL cluster?|
|Answer||A cluster can manage up to 128 nodes.|
|Question||Can the physical servers of a cluster be located in several geographical locations?|
|Answer||Because of the throughput required to perform a synchronous replication of the databases, we highly recommend not to dissociate the nodes of a cluster geographically. However, a mechanism for asynchronous replication can be used between two clusters that are geographically distant.|
|Question||Can the client applications be in 32 bits and in 64 bits?|
|Answer||The client applications can operate in Windows in 32 bits or in 64 bits, in Linux (32 bits only), in MacOS X (32 bits only) and in Windows Mobile, regardless the version (32 bits or 64 bits) of the cluster.|
|Question||Can HFSQL Cluster be used from embedded operating systems?|
|Answer||Yes. The client applications can operate in Windows Mobile (Windows Mobile 5.0 and later).|
|Question||How is the status of a HFSQL Cluster monitored?|
|Answer||The status of the nodes of a HFSQL Cluster can be monitored via the Monitoring Robot.|
|Question||After changing the file structure in the analysis (adding, changing or deleting items), how to apply the changes to the files on the different cluster nodes?|
|Answer||Simply apply the structure modification (automatic data modification) to a cluster node.|
The HFSQL Cluster synchronization process transfers structure modifications to all the cluster nodes.
|Question||Does HFSQL Cluster have any limitations?|
|Answer||The current version of HFSQL Cluster has the following limitations compared to HFSQL Client/Server.|
These limitations will disappear in the forthcoming versions.
- The password-protected data files are not supported.
- No hot backup is available.
- No bounds of automatic identifier can be defined for the replication.
- A backup cannot be restored without stopping the cluster.
- The cluster is not synchronized if stored procedures or queries are found.
- The following functions are not allowed:
- HCopyFile (only the Client to Server syntax and the Server to Server syntax)
- HSetServer (the following options are not available: hLogLevel, hMaxLogSize, hActivityStatisticsPeriod, hMaxActivityStatisticsSize, hServerPort, hMode2GB and hDebuggingPort)
This page is also available for…
Click [Add] to post a comment