Django has a powerful ORM, but like any ORM it suffers when querying data that has complex relationships. Django supports foreign keys and many to many relationships out of the box with ease. Sometimes a report or data feed has … Continue reading
With MySQL you can opt to connect to the database using an encrypted connection. This option is important to consider on AWS if you are using RDS for your MySQL database. The network between your EC2 server and the RDS server … Continue reading
Ubuntu has built in home folder encryption similar to OSX. I always turn on this feature on both OSs and have never experienced any perceptible performance hit. This guide shows one approach to migrating the MySQL data directory into the … Continue reading
MySQL offers native support for connecting via SSL. By default this is available in AWS RDS MySQL instances. Using this connection method effectively encrypts all data going back and forth between the client and the server. This prevents eavesdropping (aka … Continue reading
Ran a very specific benchmark of MySQL – the native SSL connection performance penalty on AWS RDS. When establishing a MySQL connection there is a way to tell the server to use SSL to encrypt the communication between the client … Continue reading
MySQL benchmark of AWS RDS vs EC2 with complete results and instructions on how to recreate on your own for under $0.25. Update 9/15/2013 – Added bar charts to compliment tables. I found a couple blog posts with benchmark data … Continue reading
