"volume": indicates the "binding" between the volume and the directory defined in the container. In the HFSQL server configuration, the database path will be seen as "var/lib/hfsql".

"publish": indicates the container access port (4923 in this example) and the redirection to the port inside the container (4900: HFSQL standard port).In this example, the server will be accessible on port 4923 of the docker server.

the name of the docker package and the HFSQL version (US230053b" in this example).

Notes (important)

When the container is created, if there are no databases, you can define environment variables, for example, via the syntax:

-e HFSQL_RANDOM_PASSWORD=yes

You can use one of the following three variables (or nothing for the default "admin" mode):

HFSQL_PASSWORD: Password of the initial account.

HFSQL_PASSWORD_FILE: Path of the file that contains the password of the initial account.

HFSQL_RANDOM_PASSWORD: The password for the initial account is generated randomlyIt is displayed on the standard output and can be found in the logs with the command

docker logs HFSQL_DOCKER

You can also use the following variable (optional): HFSQL_USER: Name of the account (admin by default.)

Reminder of basic Docker commands:

Stop a container:

"docker stop <ID>"

Restart a container:

"docker start <ID>"

Server to Server replication

"Server to Server" replication is not possible with the default HFSQL Docker image.To perform this type of replication, a derived image must be made adding the port used for replication.The new Docker image can be for example:

FROM windev/hfsql:25.0.062EXPOSE 4996

Example of bidirectional replication between two HFSQL docker containers

To set up bidirectional replication between two HFSQL Docker containers running on the same machine:

Create a Dockerfile with this content:

FROM windev/hfsql:FR250083EXPOSE 4996EXPOSE 4997

Create the Docker image with this command line (include the full stop):