[STABILITY] Migrate db log paths(waiting folder proposal)

[mamcx]

Description of Changes

Closes #581

Stores module logs in $STDB_PATH/database_instances

API and ABI breaking changes

If this is an API or ABI breaking change, please apply the corresponding GitHub label.

Expected complexity level and risk

1

Testing

Describe any testing you've done, and any testing you'd like your reviewers to do, so that you're confident that all the changes work as expected!

• [x] Manually inspect the logs created in the correct path.

[kim]

The full context got lost it seems: the distinction control_node / worker_node still exists in standalone.

We can either:

• store things in worker_node even if it does not make a lot of sense, or
• determine the instances root by a parametrized function relative to STDB_ROOT

I’m more in favor of the latter, so as to not have hardcoded stdb_path(“some/path”) all over the place.

[mamcx]

Ok, so I need to differentiate by edition?

[kim]

I would propose to simply retire the worker_node directory. We would then have:

STDB_PATH
| -- conf
| -- config.toml
| -- logs
| -- database_instances
|     `-- <address>
|           `-- <instance_id>
|                 | -- database
|                 | -- module_logs
|                 `-- scheduler 
`-- wasmtime_cache

Standalone can keep using control_node then.

[mamcx]

Closed, will be made by #1657