[Maria-discuss] intentionally corrupting tables
Hi all I am looking for a way to intentionally corrupt a table in a "natural" way. Of course I can open a file with Vim and change random characters, but I would probably obtain a kind of corruption that never occurs in the real world. The purpose is testing recovery procedures. Thanks Federico
Am 02.02.2016 um 15:12 schrieb Federico Razzoli:
I am looking for a way to intentionally corrupt a table in a "natural" way. Of course I can open a file with Vim and change random characters, but I would probably obtain a kind of corruption that never occurs in the real world. The purpose is testing recovery procedures
* virtual machine * snaphot * make a lot of writes and changes * trigger crash of the machine with 2 commands echo 1 > /proc/sys/kernel/sysrq echo c > /proc/sysrq-trigger
Hi, If you don't mind corrupting more than just the database (such as open memory mapped files) then you can also try this in your VM: sudo dd if=/dev/zero of=/dev/mem :D On Tue, Feb 2, 2016 at 9:46 AM, Reindl Harald <h.reindl@thelounge.net> wrote:
Am 02.02.2016 um 15:12 schrieb Federico Razzoli:
I am looking for a way to intentionally corrupt a table in a "natural" way. Of course I can open a file with Vim and change random characters, but I would probably obtain a kind of corruption that never occurs in the real world. The purpose is testing recovery procedures
* virtual machine * snaphot * make a lot of writes and changes * trigger crash of the machine with 2 commands
echo 1 > /proc/sys/kernel/sysrq echo c > /proc/sysrq-trigger
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (3)
-
Federico Razzoli -
Justin Swanhart -
Reindl Harald