|
|
|
|
|
|
|
|
|
|
- Overview
- Detailed characteristics of an HFSQL server
- "Dashboard" tab
- "Connections" tab
- "Databases" tab
- "Users" tab
- "Group" tab
- "Transactions" tab
- "Scheduled elements" tab
- "Backups" tab
- "Notifications" tab
- Ribbon options
Managing HFSQL servers
 Available only with this kind of connection
The HFSQL Control Center allows you to fully manage HFSQL servers. To display the characteristics of an HFSQL server: - Connect (if necessary) to an HFSQL server. For more details, see Managing HFSQL Client/Server databases.
- Double-click the name of HFSQL server in the tree structure.
- The right section of Control Center displays a tab with the server name. This tab includes:
- several tabs used to manage the characteristics of HFSQL server.
- a ribbon used to configure the HFSQL server.
Detailed characteristics of an HFSQL server "Dashboard" tab This tab displays the main characteristics of the server. Several actions can be performed on the server from the dashboard.
This tab displays the following characteristics in widget format: - Server name and status. The time, the amount of RAM and the system are also displayed.
- Server version, with update mode. To configure the server update, click the corresponding link. For more details, see Automatic server update.
- Current user. You have the ability to edit the profile of the current user.
- Uses and groups defined on the server. A click performed on the information displayed allows you to access the characteristics of the users or groups.
- Transactions: Displays current transactions.
- Configuration: Displays the main server configuration features: calculation of key statistics, activity statistics, index cache, log management, etc.. Click an option to open the corresponding settings window.
- Server activity: Displays current tasks. A click on the number of current tasks is used to get the task details.
- Scheduled tasks: Displays the different types of scheduled tasks existing on the server. A click performed on these tasks is used to see their configuration.
- Notifications: Displays notifications received. You have the ability to configure the recipients of notifications directly.
- Replication: Displays replications of defined server data. You can directly configure the server replication.
- Backup: Displays scheduled backups. You have the ability to configure the scheduled backups.
- Connections: Displays the number of connections. The link "More details" is used to display the "Connections" tab.
- Database volume: Displays a graph showing the volume of each database installed on the server.. The option "Display the list of databases" is used to display the "Databases" tab.
To configure the widgets displayed in the Dashboard: - Display the table context menu of the "Dashboard" tab (in a location containing no widget for example).
- Select "Modification mode".
- The dashboard appears in "modification" mode. You can:
- Hide some widgets.
- Display the hidden widgets.
- Resize the widgets with the mouse.
- To exit from the modification mode and to apply your changes, select "Modification mode " in the context menu.
"Connections" tab This tab lists the different users connected to the different databases found on the server.
The list of active connections contains the following information: - the database name,
- the username,
- the computer name,
- the name of the application that accesses the database, etc.
From this tab, you can:  New in version 2025Filter connections by machine, user, application or database. - Block connections: prohibit or authorize connections, via the "Block connections" option in the ribbon.
- Disconnect users.
New in version 2025Simply select the user(s) to be disconnected from the list of connections, then use the "Disconnect selected users" option in the ribbon. - Send a message to the users.
New in version 2025Simply select the recipient user(s) from the list of connections, then use the "Send a message to the selected users" option in the ribbon.
The option "Don't display the connections of HFSQL Control Center (stated on this computer)" is used to only display the connections of users via the applications. "Databases" tab This tab is used to list the different databases found on the server.
The following information is specified for each database: - The number of connections,
- the number of locks,
- the number of tables.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Databases" group, are used to: - access the selected database,
- display the details of the selected database or the details of all databases. One or more new tabs are opened, displaying the details of the database.
- delete the selected database from the server.
"Users" tab This tab is used to manage the users (creation, modification, deletion, search). When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Users" group, are used to: - create a new user,
- edit the characteristics of an existing user,
- delete a user.
When creating a user, the user can be a superuser: users designated as "superuser" are authorized to perform all actions on the server, databases and all files. "Group" tab This tab is used to manage the groups of users (creation, modification, deletion). When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Groups" group, are used to: - create a new group,
- edit the characteristics of an existing group,
- delete a group.
"Transactions" tab This tab is used to manage the current transactions or the interrupted transactions on the server. It is possible to: - See the current transactions,
- Releasing Transaction Records.
"Scheduled elements" tab This tab is used to create, modify and delete schedule operations on the server: When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Scheduled elements" group, are used to: - create a new scheduling,
- display the details of a scheduling,
- run a scheduling,
- delete a scheduling.
"Backups" tab This tab is used to: - view all backups (running or completed).
- restore server and/or database backups.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Backups" group, are used to: - create a new backup (hot or scheduled backup),
- restart a backup,
- restore a backup,
- delete a backup.
"Notifications" tab This tab lists the different server notifications: - Failed scheduled tasks,
- Failed backups,
- Replication server not accessible,
- etc.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Notifications" group, are used to: - Delete the selected notifications.
- Delete all the notifications from the server.
When the server characteristics are displayed, the ribbon shows several options: - general options.
- options specific to the different selected tabs.
The general options are as follows: - In the "SQL query" group:
- New query: This option opens a specific tab for creating a new query..
- Open a query: This option opens a specific tab corresponding to a previously performed query..
- In the "Server" group:
- Stop server: This option stops the server..
- Start server: This option starts the server (if it has been previously stopped)..
- In the "Databases" group:
- New database: This option allows you to create a new database on the server..
- Import an HFSQL Classic database: This option lets you import an HFSQL Classic database onto the server in Client/Server mode.. A wizard allows you to select the data files to import.
- Recover files from the server: This option allows you to copy files locally from the server.. A wizard allows you to select the different copy options as well as the copy directory.
- In the "Rights" group:
- Rights management: This option lets you manage server rights for the selected user or group.. You have the ability to store and restore a configuration of rights.
- In the "Parameters" group, the option "Server configuration" is used to configure the server. For more details, see HFSQL server configuration.
- In the "Logs and statistics" group:
- Display server logs: This option provides a summary view of database usage between two dates:
- most used queries, longest queries,
- most consuming applications
- statistics by application, process, etc.
This option is available only if the logs are enabled on the server. - Show server stats: This option is only available if activity statistics are enabled on the server.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|