r38y

S3 Awesomeness

We recently needed an easy way to do a few tasks with some files in Amazon’s S3. We couldn’t find anything that fit our needs out of the box so we created a thin wrapper for s3sync called S3 Awesomeness. 

You simply configure your production, staging, and archive buckets as well as the credentials in a yaml config file and use the available rake tasks to sync from production to staging or archive production in a separate S3 bucket. Use rake -T to see what rake tasks are available. For example, we use the following command to sync the production bucket to the staging bucket:

rake sync_from_production_to_staging

Which syncs the files locally to cache then back up to the production bucket.

You can find it at GitHub. There isn’t a license yet… I’ll get to it.

utf8 + MySQL

If you are having problems with utf8 characters in MySQL, add this to your my.conf:

[mysqld]
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci

Note that init_connect won’t run when the user has super privileges, so make sure you use a user without them:

REVOKE SUPER ON *.* from 'user';

if the user already has SUPER privileges.