Encrypt entire MySQL db in Mac OS X 10.6

I need to provide an encrypted database for a client on a Mac OS X 10.6.5 Mac Pro. I don't believe there will be any PHP or web front end for this data. It will just be queried directly using MySQL queries.

What is the best solution for encrypting an entire database?
LVL 1
MazarothITAsked:
Who is Participating?
 
strungConnect With a Mentor Commented:
I don't know enough about MySql to answer the first question.

My guess with respect to the second is that any delay will be in the initial opening and closing of the sparsebundle.

The only other option I can think of is FileVault but that can be problematical:

http://en.wikipedia.org/wiki/FileVault

(file vault basically turns the whole Home folder into an encrypted sparsebundle)
0
 
MazarothITAuthor Commented:
Thats true. It would require the users to mount the sparsebundle image before performing MySQL queries. I think I could teach them how...

I have a couple of concerns with that method though.

1. Would there be a problem with dismounting the sparsebundle while the MySQL service is running?
2. How much will MySQL performance be affected by the database being in an encrypted sparsebundle?
0
 
TolomirAdministratorCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.