Create decoy tables

From DISI
Revision as of 18:11, 21 March 2011 by Frodo (talk | contribs)
Jump to navigation Jump to search

Create Decoy Tables

  • 1: On zincdb4, in a screen session, run ~root/generate_decoyprot.sh (takes many hours)
  • 2: Shutdown zincdb4 mysqld
  • 3: Copy /var/lib/mysql/zinc8/decoyprot.* to zincdb2, zincdb3 somewhere
  • 4: Turn zincdb4 back on (This part may be possible without mysqld shutdown/startup, I'm just doing it for saftey)

On each zincdb2, 3:

  • 1: Shutdown mysqld
  • 2: move the decoyprot.* files copied above into /var/lib/mysql/zinc8/
  • 3: Start mysqld


March 20, 2010 version from Pascal (unformatted)

Procedure is as follows:

Run the decoyprot generation script zincdb4:/root/scripts/generate_decoyprot.sh (wait many hours) Shutdown mysql on zincdb4 copy /var/lib/mysql/zinc8/decoyprot.* to zincdb2, zincdb3, to a temporary location. Copy takes 3-5minutes currently Restart mysql on zincdb4

On zincdb2, 3: Stop mysqld Move the decoyprot.* copies into /var/lib/mysql/zinc8/ (May take a few minutes even though its a move) Make sure the copied decoyprot.* files are owned by mysql:mysql Start mysqld

Validate that the tables work:

select count(*) from zinc8.decoyprot; select * from zinc8.decoyprot limit 10;