The Book of Atrus serves as a prequel to the events of the eponymous first game in the Myst series, and introduces both new characters and old characters seen in the games.
The Book of Ti'ana takes place earlier than The Book of Atrus.