Re: MySQL Encryption - Third-party tools

2009-08-25 Thread philip
On Mon, 24 Aug 2009, Mike Scully wrote:

 Hello, all.
 =20
 Can any of you share with me the names of any third-party tools or
 appliances that you are using to encrypt your MySQL databases?  I am
 doing a search and would like to narrow down the initial search list.
 Thanks!
 =20
 Mike

I use ccrypt from http://ccrypt.sourceforge.net to encrypt databases
before storing them on removable media for offsite storage. 

Platform is a Sun Ultra 45 running Solaris 10 and the command looks 
something like,

mysqldump db_name | bzip2 | ccrypt -e -k keyfile | ...

(Note the bzip2 in the pipeline. This reduces the size of the files by a 
factor of between 5-8.)

It's certainly more than fast enough for my needs. I suspect most of the
time is taken up by mysqldmp and writing the ouput to the external media. 

--
TTFN

   Philip Riebold, p.rieb...@ucl.ac.uk

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: MySQL Encryption - Third-party tools

2009-08-25 Thread Daevid Vincent
You might consider a full disk/volume/partition encryption maybe?

http://truecrypt.com/

I use this for my private files and it's awesome. Cross platform and can do
virtual partitions on an actual physical drive. 

 -Original Message-
 From: philip [mailto:phi...@livenet.ac.uk] 
 Sent: Tuesday, August 25, 2009 2:08 AM
 To: Mike Scully
 Cc: mysql@lists.mysql.com
 Subject: Re: MySQL Encryption - Third-party tools
 
 On Mon, 24 Aug 2009, Mike Scully wrote:
 
  Hello, all.
  =20
  Can any of you share with me the names of any third-party tools or
  appliances that you are using to encrypt your MySQL databases?  I am
  doing a search and would like to narrow down the initial 
 search list.
  Thanks!
  =20
  Mike
 
 I use ccrypt from http://ccrypt.sourceforge.net to encrypt databases
 before storing them on removable media for offsite storage. 
 
 Platform is a Sun Ultra 45 running Solaris 10 and the command looks 
 something like,
 
   mysqldump db_name | bzip2 | ccrypt -e -k keyfile | ...
 
 (Note the bzip2 in the pipeline. This reduces the size of the 
 files by a 
 factor of between 5-8.)
 
 It's certainly more than fast enough for my needs. I suspect 
 most of the
 time is taken up by mysqldmp and writing the ouput to the 
 external media. 
 
 --
 TTFN
 
Philip Riebold, p.rieb...@ucl.ac.uk
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=dae...@daevid.com
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



MySQL Encryption - Third-party tools

2009-08-24 Thread Mike Scully
Hello, all.
 
Can any of you share with me the names of any third-party tools or
appliances that you are using to encrypt your MySQL databases?  I am
doing a search and would like to narrow down the initial search list.
Thanks!
 
Mike