Murloc Cult

Back to the log

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.
Nightly backup of all server databases — Murloc Cult