Emergency Data Recovery: Corrupt MySQL InnoDB → Zero-Loss Extraction in 48 h

Job Overview

Budget

$1,800.00

Level

Senior

Location

Mexico

Job Posted

26 Sep, 2025

Category

backup

Total Proposals

0

Job Description

 Midnight Crisis

Power spike → MySQL 8.0 InnoDB tablespace corrupted; mysqld refuses start; last backup 18 h old. CFO demands zero transaction loss before market opens.

48-Hour Rescue Plan

  • Remote triage (30 min) → copy corrupted ibd files to isolated EC2.
  • Undrop-for-InnoDB toolkit extracts records directly from tablespace.
  • Percona Toolkit pt-table-checksum validates extracted rows.
  • Parallel insert into new cluster → 18 h gap closed.
  • Forensic PDF: root cause, prevention checklist.

Deliverables

  • Recovered SQL dump + checksum CSV.
  • Forensic report (PDF) signed with GPG

Skills

  • Data recovery tools and technologies

Tags

Data recovery tools and technologies

Author Spotlight

Samuel Gonzalez

Samuel Gonzalez

Client

No description available.

Related Jobs

1 year ago Senior
$70.00 Hourly

We are hiring a Business Continuity Planner to develop a comprehensive strategy for maintaining operations during disrup...

Risk assessment and analysis
View More
1 year ago MidLevel
$65.00 Hourly

We are looking for a Backup Automation Specialist to automate and optimize our data backup processes. This role involves...

Backup automation for different backup types (e.g., file backup, database backup, application backup)
View More
1 year ago MidLevel
$60.00 Hourly

We are seeking a Data Recovery Expert to implement and manage data recovery solutions, ensuring data can be restored eff...

Data recovery tools and technologies
View More
1 year ago MidLevel
$60.00 Hourly

We are hiring a Backup Security Analyst to secure our backup systems, ensuring data integrity and protection against ran...

Backup data encryption
View More
Samuel Gonzalez

Samuel Gonzalez

Mexico


Member Since
Oct 26, 2024
Total Created Jobs
8