MySQL Encryption - Third-party tools

------_=_NextPart_001_01CA24D4.DAF93085
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01CA24D4.DAF93085--

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.riebold@ucl.ac.uk

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: MySQL Encryption - Third-party tools

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:philip@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.riebold@ucl.ac.uk
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=daevid@daevid.com
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org