Home | Sign in | English UK
  • Questions/Answers
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
Frequently asked questions about HFSQL Cluster
HFSQL Client/ServerAvailable only with this kind of connection
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 25.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
QuestionWhat is HFSQL Cluster?
AnswerHFSQL 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.
QuestionWhat is the link between HFSQL Cluster , HFSQL Client/Server, HFSQL Classic and HFSQL Mobile?
AnswerThese 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, ...)
QuestionWhat is the license proposed for using HFSQL Cluster?
AnswerThe HyperFileSQL Client/Server license also applies to HFSQL Cluster.
QuestionDoes HFSQL Cluster require a specific hardware configuration?
AnswerHFSQL Cluster does not require any special investment to be implemented. See Installing HFSQL Cluster for more details.
QuestionIs HFSQL CLuster intended for a specific type of applications?
AnswerAll 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, ...).
QuestionDo I have to modify my existing HFSQL Client/Server code to use HFSQL Cluster?
AnswerNo. 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.
QuestionHow many physical server are required to create a minimum cluster configuration?
AnswerAt 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).
QuestionWhat is the maximum number of nodes in a HFSQL cluster?
AnswerA cluster can manage up to 128 nodes.
QuestionCan the physical servers of a cluster be located in several geographical locations?
AnswerBecause 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.
QuestionCan the client applications be in 32 bits and in 64 bits?
AnswerThe 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.
QuestionCan HFSQL Cluster be used from embedded operating systems?
AnswerYes. The client applications can operate in Windows Mobile (Windows Mobile 5.0 and later).
QuestionHow is HFSQL Cluster managed?
AnswerHFSQL Cluster is managed via the HFSQL Control Center. See Managing HFSQL Cluster for more details.
QuestionHow is the status of a HFSQL Cluster monitored?
AnswerThe status of the nodes of a HFSQL Cluster can be monitored via the Monitoring Robot.
QuestionAfter 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?
AnswerSimply apply the structure modification (automatic data modification) to a cluster node.
The HFSQL Cluster synchronization process transfers structure modifications to all the cluster nodes.
QuestionDoes HFSQL Cluster have any limitations?
AnswerThe current version of HFSQL Cluster has the following limitations compared to HFSQL Client/Server.
These limitations will disappear in the forthcoming versions.
  • 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:
    • HAddLink/HDeleteLink
    • HAddScheduledOptimization/HModifyScheduledOptimization/HDeleteScheduledOptimization
    • HAddScheduledBackup/HModifyScheduledBackup/HDeleteScheduledBackup/HExecuteScheduledBackup
    • HLoadParameter/HSaveParameter/HDeleteParameter
    • HCopyFile (only the Client to Server syntax and the Server to Server syntax)
    • HCreateServerTrigger/HDescribeServerTrigger/HActivateServerTrigger/HDeactivateServerTrigger/HDeleteServerTrigger
    • HExecuteProcedure
    • HSetServer (the following options are not available: hLogLevel, hMaxLogSize, hActivityStatisticsPeriod, hMaxActivityStatisticsSize, hServerPort, hMode2GB and hDebuggingPort)
    • HManageTask/HAddTask/HModifyTask/HDeleteTask
    • HNoDatabaseAccess/HEndNoDatabaseAccess
    • HNoModif/HEndNoModif
    • HLogRecreate
    • HLogRestore
    • HFree
    • HRefreshSet/HDeleteSet
    • HRefreshQuery/HDeleteQuery
    • HModifyProperty
    • HBackup/HDeleteBackup
    • HDeleteFile
    • HDeleteDirectory
    • HDeleteAll
Minimum version required
  • Version 15
This page is also available for…
Click [Add] to post a comment