not really offline but someone who works in industry here once detailed out that each scanner has it's own copy of a SQLite database that is being updated as fast as possible based on inserts of other scanners since any downtime is a big deal at these venues

i.e., theoretically duplicate tickets would be identified but not instantly but still pretty quickly