LAB CASE STUDY / DATABASE

Four engines.
Recovery checked.

Native backups and separate restores on MySQL, MariaDB, SQL Server and MongoDB, with content and object checks.

← All case studies
Lab demo · synthetic dataNODIVEXA local environment
4 enginesReal instances, synthetic data
67 checksPassed within recorded scope
New destinationsSources not overwritten

What we tested

Verify that native backups restore to new destinations, match the source contents and retain the behaviour of representative objects.

What we did

  1. Prepare separate engine instances and synthetic data; test connections and rejection of incorrect credentials.
  2. Create native backups and checksums, encrypt copies, then restore to new databases or collections.
  3. Compare content hashes and representative objects; check constraints, indexes and refusal of existing targets.

Test results

All 67 checks passed: MySQL 18, MariaDB 18, MongoDB 12 and SQL Server 19. Restored contents matched and sources remained unchanged. Object coverage varied by engine; SQL Server also checked COPY_ONLY, CHECKSUM and VERIFYONLY.

Demo limitations

Local tests on MySQL 8.4.13, MariaDB 11.4.12, MongoDB 8.0.34 and SQL Server 2022 CU21 Developer. Not proof for every version, workload, cluster, sharding or PITR. Developer licensing is for testing, not production.

LET’S BUILD SOMETHING RELIABLE

Your next step.
A conversation.

Tell us what you are running, what is getting in the way, and what you need next. Start directly on WhatsApp or Telegram.