> I suspect they deal with this in the form of some sort of caching outside of MySQL, but I haven't read into it.

It is handled by TAO, https://engineering.fb.com/2013/06/25/core-data/tao-the-powe...