Tuto WEBDEV 25

388 Part 11: Managing a HFSQL Client/Server database Overview Now that we know how to create and/or adapt a site so that it operates in HFSQL Client/Server mode, let’s see how to manage the associated database. Indeed, a Client/Server database requires: • a specific configuration of computers (setup of a HFSQL server, ...). • a management performed via the HFSQL Control Center. Configuring the computers To use a HFSQL Client/Server database, a HFSQL server must be installed on the server. Several HFSQL servers that use different ports can be installed on the same computer. For example, a test HFSQL server that includes a test database and a production HFSQL server that is using a different port can be installed on the same computer. However, for performance reasons, this configuration is not recommended. One or more databases can be installed on each server. The HFSQL Control Center The HFSQL Control Center is used to perform all management operations on the HFSQL Client/ Server servers and databases. We are going to present the most important features. First, we are going to start the HFSQL Control Center from the WEBDEV project. ▶ To start the HFSQL Control Center from WEBDEV and to access the data: 1.  In the WEBDEV menu, on the "Tools" pane, in the "Database" group, click "HFSQL". The HFSQL Control Center is displayed. 2.  The home window of HFSQL Control Center is displayed. The analysis of current project is automatically selected. 3. Validate the screen. The HFSQL Control Center is displayed. This start mode allows you to see the different data files linked to the analysis of the current project.