Overview
Learner Service provides APIs related to resources such as Organisations, Users (i.e. learner), Course Batches, Locations, Badges, Pages etc.
...
| Approach | Pros | Cons |
|---|
| Cassandra Trigger | - Immediately triggered
- Maintains order (not tested in multi-node scenario)
| - Deprecated (refer Datastax documentation)
- Semi-private and subject to change
- Performance overhead
|
| Use audit logging of Apache Cassandra 4.0 | - Out of the box product feature which is expected to meet performance and reliability design goals
| |
| Change Data Capture | - No performance overhead during write
| - Data not immediately available (requires memtables flush or commit log limit)
- Every node has a separate commit log (binary format)
- Consumer needs to handle duplicate events in a multi-node setup
|
| ecAudit (Ericsson Cassandra Audit) | - Immediately logged (on the node where the query is executed)
- Read is straightforward as log is in text format
| - Correlation required in case of FAILED events
- Every node has a separate audit log
- Performance overhead
|
...
3) Performance comparison of Cassandra Triggers and ecAudit (in progress)
Please refer Performance Comparison of Cassandra Audit Log Options.
4) Drop data in user_education, user_job_profile and address tables based on discussion with Rahul and Rayulu
...