20 Posts tagged with mysql
Maatkit: a toolkit of utilities and tools for MySQL
Maatkit makes MySQL easier and safer to manage. It provides simple, predictable ways to do things you cannot otherwise do.
Running MySQL on Amazon EC2 with Elastic Block Store
This tutorial describes one approach to using Amazon EC2's Elastic Block Store (EBS) as a persistent storage mechanism for a production MySQL database server, including snapshot backup and restore.
HSCALE - Horizontal Scaling for MySQL
Abstracts partitioning outside of the application layer into a MySQL Proxy module. Not production ready yet, but watch this space.
mylvmbackup
mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again
Turning MySQL data in latin1 to utf8
This looks like what I'll be doing this weekend. Happy happy joy joy
query-reviewer
An advanced mysql query analyzer for rails: runs 'EXPLAIN' before each of your select queries in development and summarizes query warnings.
Masochism
Connection proxy sends some queries (thoes in a transaction, update statements, and ActiveRecord::Base#reload) to a master database, and the rest to the slave database
ONLamp.com -- Advanced MySQL Replication Techniques
Great example of circular replication using MySQL 5.x. For the next upgrade.
Jake@Nitobi » Blog Archive » RobotReplay and Rails on Amazon EC2
"Don’t forget actually deploying changes to your app. Capistrano is great, awesome, wicked, but needing to rewrite your deploy.rb as you add and remove servers on EC2 is teh sux." I know, I'm working on it :).
A bunch of presentations on scaling websites: twitter, Flickr, Bloglines, Vox and more.
If you haven't seen any of these, take some time and take a look at them all. Great info about building scalable web services.
MySQL4Patches - google-mysql-tools - Google Code
These are patches for MySQL 4.0.26. They add many features that enhance the manageability and reliability of MySQL.
muckOS
muckOS (muck-oh-ess) is a collection of tools being built to take advantage of Amazon EC2, S3 and SQS. The goal is to create and manage elastic, self-healing clusters for applications.
acts_as_with_readonly
acts_as_with_readonly is a Rails plugin to support slave-DB for finders in AR models
table indexes in rails :: evan weaver
Don't forget about good database design when working in Rails - indexes are a must.
Hivelogic - The Narrative - Building Ruby, Rails, Mongrel, and MySQL on Mac OS X
Dan updates his wonderful OS X Rails stack install guide