I think your posts and comments are stored on your own instance - lemmy.world for example - and then that instance uses the ActivityPub protocol to tell the community you interacted with that you did it.

From there I’m not sure exactly. I think the primary source of truth for your activity is still your home server, but the server hosting the community still at least caches the data as well, meaning a popular community might still overload it.