r38y

r38y = r&y = randy

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.

Comments

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.

Comments
If I’d asked people what they wanted, they would have said a faster horse. Henry Ford
Comments
Everything should be made as simple as possible — but no simpler! Albert Einstein
Comments
When once you have tasted flight, you will forever walk the earth with your eyes turned skyward, for there you have been and there you will always long to return. Leonardo da Vinci
Comments
Fork me on GitHub