i am working on a data collection system for an epidemiological study.
the study holds among other things sensitive personal information. the
personal info is stored in ONE table (i am using innodb_file_per_table)
which we encrypt and wipe after the server is shutdown.
the question is, where else could this data sit on disk? since i am new
to MySQL, i am trying to get clear on the log files, what they contain,
which ones hold data. i gather if we want to be able to perform
rollbacks, we would need to keep the log files around, and since they
store SQL transactions, we would have to encrypt (and wipe) them as
well after the data collection session is over and server is shut down.
right now i see ib_logfile{0,1}files and an ibdata1 file in addition to
our *.frm and *.ibd tables. need we encrypt the *.frm files as well?
which of the ibXXX files need we encrypt? are there any other MySQL
files ANYWHERE that i should be aware of? Does MySQL ever write anything
to the Windows temp directories? (Windows only app)
yes, i am aware of MySQL encryption on a per field basis. we were asked
to encrypt the whole table.
many thanks
les schaffer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
