it sometimes can be just an architectural issue...
You can use the critical query against the RW instance, the first point.
The other point is that most of the time, specially concerning to web where the amount of concurrent access may be critical, the data doesn't need to be time-critical.
With the advent of reactive in apps and web things became overcomplex.
Yes, strong consistency will always be an issue. And mitigation should start in the architecture. More often than not, the problem arise from architectural overcomplication. Each case is a case.
You can use the critical query against the RW instance, the first point.
The other point is that most of the time, specially concerning to web where the amount of concurrent access may be critical, the data doesn't need to be time-critical.
With the advent of reactive in apps and web things became overcomplex.
Yes, strong consistency will always be an issue. And mitigation should start in the architecture. More often than not, the problem arise from architectural overcomplication. Each case is a case.