Hello everyone, because we have so much data that would need to be pushed to the Storage-Redis, we opted to switch it out for a direct database connection as outlined here: https://documentation.spryker.com/docs/howto-replace-key-value-storage-with-database Now we've got the problem that we need a reliable way to set this up with docker/sdk. Is there any way to pass new environment variables to the Yves container without manually patching the generator scripts? Thanks in advance.

how much data do u have?

Enough that Redis is not a viable solution any longer. We are talking milions of products.

Ok. we have 26GB of data in redis and it works well.. We have ca. 3Mio Product Abstract, 3Mio Product Concrete, 5Mio Product Images, 3Mio Price, 3Mio Product Sales Unit, 3Mio Product Quantity, a lot of Mio Product Stocks + Availability, 1000 Categories (only 1 Tree) etc etc etc.. etc...... and without Redis the System will be very slow...

We are simply at a point where Redis cannibalizes all our cluster resources for itself due to data duplication. 30GB would not be enough and we are growing.

ok, of course i don't know your data size and other aspects... I think that request to redis are faster than request to zed and forward to db Imagine u have Yves Server/Instance that for every glossary or storage request have to call the zed (because only zed can communicate with db) and then zed server/Instance have to make another request (in best case) to another server where db is running... i think that the result can be that the system is a little bit slower (maybe)... Other side u save up a lot of rmq messages, php process for syncing etc.. and your data are sure synced always...

The way the tutorial sets it up, the Storage driver is exchanged, so no Zed calls are made. The Yves frontend connects directly to the database. I agree that constant REST requests would be an overwhelming overhead.

yes i see... i did not know that

StorageDatabase

have a self connectionProvider to communicate via client layer with db...

that's really all besides my original question unfortunately 😉 if we only did SQL queries through Zed, we wouldn't have the issue mentioned in the post as that of course already gets the credentials passed in via environment by docker/sdk.

I think u have include the database env located here

docker/generator/src/templates/env/database

(i.e. for zed here ->

docker/generator/src/templates/env/application/zed.env.twig:25

) in

docker/generator/src/templates/env/application/yves.env.twig

too... and then in

docker/generator/src/templates/application/yves.yml.twig

u have to extends the

depends_on

with database too..

Locally it can just use the same database credentials from primary database. You can still separate dev and cloud config on PHP side to take different environment variables.

thanks