does anybody have experience with eventstore which is “huge”? I mean billion or even trillion of events.
What kind of storage is sufficient for this? sql/nosql?
What could be the mechanism for loading the aggregates from this storage? I was thinking about storing snapshot and then moving old events to some archive. But in this case I don’t know how to perform replays.
What about primary keys?
We are currently using postgre/oracle db and generating primary keys using UUID4. The PK with UUID4 can have performance issue while it’s stored as string (binary representation could help here but axon with jpa is not ready for this maybe jdbc could help here ). Are you using other type of primary/unique keys?