Solved

Encrypt entire MySQL db in Mac OS X 10.6

Posted on 2010-11-30
5
675 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
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Explore the encryption capabilities built into Google Apps and how these features can help you meet privacy policy and regulatory compliance, but are not a full solution. Understand and compare the most popular email encryption services for Google A…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 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