One HFSQL Server and Databases on different disks

Hi,
Is there a way in ONE HFSQL C/S Server to use different hard disks to store databases?
Or the only solution is to install many HFSQL servers? And then how is the perfomance of a single server affected?

Refards
Steven Sitas

Hi Steven,

Yes, you can configure the Server (via Server configuration -> General) to change the location of Directory of DB.

Regards

Vassilis Boutsikas

Hi Vassilis,

I wan't many DIFFERENT locations for the SAME HFSL Server - so I can support different databases on different hard disks ..

Regards
Steven Sitas

Hi Steven,

In this case, the only available option is to install multiple Servers.

Regards

Vassilis Boutsikas

Hi Vassilis,

I was afraid of that ...
It's been a while since we've talked - I hope you and your family are well.

Regards
Steven Sitas

Steven

As Vassilis points out, the Server Configuration\general dictates the directory of databases "%%EXE%%\BDD" but there is nothing stopping you from using filesystem tools to achieve the same goal.

For Windows/NTFS:

If your plan is to store the data on a local drive you could use junction points for the individual database directories under this parent.

You could create your hosted database "DB1" i.e "%%EXE%%\BDD\DB1" then:
1) Shutdown the HFCS Server
2) Copy the created database directory "DB1" to your desired location (D:\DB1)
3) Delete the original directory "%%EXE%%\BDD\DB1"
4) Open a command prompt in the database server directory "%%EXE%%\BDD" and create a junction point:
mklink /j BD1 D:\DB1
5) Start up the HFCS server and test.

The only compromise you're making is that the other temp files built by the HFCS during transactions & query execution will most probably still reside under "%%EXE%%\BDD" in the "_JNL" & "_TRS" etc

Regards

Eric W



Edited 1 time(s). Last edit at 04/25/2023 04:02PM by ewiegert.

Hi Eric,

thanks for the idea - but it looks a "little dangerous".
Even if it would work - remember some, of my databases are on C:\, others on D:\ etc - I am afraid that PCSoft may change something in the future and It stops working ...

I will try with 2 HFSQL servers (on different ports) on the same machine and if I have any performance issues, I will go for another server ...

Regards
Steven Sitas

Hi Steve

You need to install the HFSQL Cluster version to do that.
https://doc.windev.com/en-US/?1000019030&name=presentation_hfsql_cluster

Cheers

Peter Holemans

Hi Peter,

But wouldn't I need to install, first, 2 nodes of a simple HFSQL server, on the same machine - to use with a cluster - if I wanted to be able to access both c:\ and d:\ databases ?
Or am I missing something ?

Regards
Steven Sitas