Solved

Encrypt entire MySQL db in Mac OS X 10.6

Posted on 2010-11-30
5
696 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:MazarothIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 53

Expert Comment

by:strung
ID: 34243057
0
 

Author Comment

by:MazarothIT
ID: 34244183
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
 
LVL 53

Accepted Solution

by:
strung earned 500 total points
ID: 34244568
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
 
LVL 27

Expert Comment

by:Tolomir
ID: 34690251
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

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Understanding UserAgent String 2 65
Unwanted output from my query 5 49
database connection error mysql stops 7 78
DER-Encoded Cert for 2012 Server R2 6 19
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question