Is it possible to store both event and Logs of a Gran

[iltom90]

Hi everyone,

I have a grain in Orleans 9.x and I’m trying to implement the following architecture:

1. The grain state should be stored in SQL Server using the built-in Orleans ADO.NET storage provider.
2. The log consistency should be handled by Kurrent, implemented as a custom log consistency provider.

I’m trying to understand whether this setup is supported in Orleans 9.x and, if so, how it should be correctly configured. Specifically:

• Is it possible to use SQL Server for grain state persistence while using a separate custom log consistency provider for log-based grains?
• What is the correct way to register a custom log consistency provider in the DI configuration?

Right now I have both AddAdoNetGrainStorageAsDefault and AddLogStorageBasedLogConsistencyProvider pointing to the same database. In this setup, only the logs are being saved. If I remove the AddLogStorageBasedLogConsistencyProvider configuration, then the grain state is saved correctly.

My goal is to persist the grain state in one database and the logs in another.

Many thanks,
Thomas

[m3nax]

Are you using the JournaledGrain, right?

I think you will need to create a single custom log storage provider that writes to both systems internally.
As far as I know, currently there is no native way to write the state of a single grain to two different storage providers simultaneously.