Nightly backup of all server databases
The game server databases (accounts, characters, world) are now backed up every night, from a consistent snapshot that does not block the game. Every copy is checked, an alert is sent on failure, and restoring has been tested: the reloaded data is identical to the server's.
- Build
- Build success · Target db-backup
- Content: the accounts database, the characters database (characters, items, mail, quests, achievements…), the world database, and the database's technical accounts. About 77 MB compressed, in 10 seconds.
- Retention: the last 14 nights, one backup per week over 8 weeks, one per month over a year.
- Checks: every archive is read back in full after writing. On failure, nothing is deleted and the administrator is alerted by e-mail.
- Restore test: accounts (23 tables) and characters (108 tables, 1.87 million rows) reloaded into empty databases and compared table by table with the server. They are identical, apart from position rounding (under 5 cm).
- Until now, only some accounts had their own backup. All characters now do, including the 62 Pantheon characters and the 2,500 autonomous players of the temporary server.