image

In December 2020, IBM Research and Fujifilm presented a prototype of the LTO cartridge for 580 terabytes ... A small cassette with a magnetic tape holds information like several dozen ordinary HDDs or 120,000 DVDs.

Magnetic tapes appeared almost a century ago, and computer files have been recorded on them since 1952. Our mothers in Soviet research institutes also changed mainframe coils. And in 2021, tapes remain the cheapest drive, with storage costs about 6 times lower than HDDs. Since film has practically disappeared from the consumer market, many people don't even know how rapidly this technology is developing.
Killer 8 april 2021, 11:54

The study of data recovery method from accidentally deleted database of MySQL.

Testing environment

Here are CentOS 5.6 x86_64 and mysql 5.0.77
There was created testing database with a couple of tables as MyISAM and InnoDB, as well as a couple of stored procedures to test their recovery:


DROP DATABASE prod;
CREATE DATABASE prod;
USE prod;
CREATE TABLE table1 (
id INTEGER,
v VARCHAR (50)
PRIMARY KEY (id)
) ENGINE = MyISAM;
Tags: backups, Mysql
Killer 7 october 2011, 16:43