MySQL

Purge data from mysql innodb tables efficiently with low overhead and impact. Based on the Percona pt-archive utility.

A simple, fast Mysql library for Ruby, binding to libmysql

Ruby command line wrapper for MySQL.

An event-driven interface for MariaDB and MySQL servers.

When this gem is loaded and activated inside your rails app, your MySQL connection adapter for ActiveRecord will be monkey-patched. The patch simply tweaks it to store all boolean "true" values as negative one instead of positive one inside your TINYINT columns. It also patches it to recognize and interpret negative one as "true". Positive one will still be recognized as true as well. Used for special cases, such as developing rails apps that must, for example, work with existing databases that use such a convention. For a rails app version X.Y.Z, use army-negative version "~> X.Y.0". For example, a rails 3.0.x app should use "~> 3.0.0" and a 3.1.x app would use "~> 3.1.0", etc. The exception is that rails 2.3.x apps should just use "~> 2.0" since 2.3 is the earliest version of rails that's supported.

Add index hint to MySQL query in Arel.

Async MySQL client API for Ruby/EventMachine. prepor fork

MySQL constraints in migrations similiar to ActiveRecord validations

A simple backup script for Mysql and S3 with incremental backups.

mysql gem-based driver for RDBI

A simple, fast Mysql library for Ruby, binding to libmysql

Convert mysql data into json

A Web UI to manage databases. Support PostgreSQL, MySQL, SQLite, Oracle, MS-SQL, etc.

Under Darwin, spawns a temporary MySQL instance off a RAM disk. Useful to speed up large test suites, your machine usable while running them, and preserve your SSD's life!

ZFS admin scripts, such as automatic snapshots, mysql snapshotting, scrubbing, etc.

Ruby gem with Thor script to manage MySQL and PostgreSQL replication

A simple backup script for Mysql and S3 with incremental backups.

MySQL replication binlog parser using mysql-binlog-connector-java.

MySQL slow query log parser

generate validations from the schema - used in production with MySQL

mysql_warmer warms up a cold database by sniffing SQL queries from a hot machine and then repeating those queries on a cold machine

Connect to MYSQL more easily

Provides automatic deadlock retry and logging functionality for ActiveRecord and MySQL

ActiveRecord support for MySQL POINT fields.

A lightweight framework to provide managers for working with MySQL.

A basic library for automatic CRUD services using only Sinatra, MySQL and Memcache

The MySQL API module for Ruby, with Twitter fixes.

Make a mysql server into a slave of another, optionally copying data

A library to summarize MySQL slow_log records in Ruby.

This gem provides MySQL's LOAD DATA INFILE for Mysql2 and ActiveRecord

RSQL makes working with a MySQL command line more convenient throughthe use of recipes and embedding the common operation of using a SSHconnection to an intermediary host for access to the MySQL server.

The rails schema generator generates complete SQL schemas from a collection of rails migrations. It currently produces one schema file each for MySQL, PostgreSQL, and SQLite.

MySQL connector for Ruby

This is an ActiveRecord adapter for Ruby/MySQL. This is based on MySQL adapter

SmartSearch adds full-text search functions to ActiveRecord running with MySQL, including search for similiar words. Its fast, simple, and works with almost zero-config!

Build SQL statements using method calls instead of strings. This is not an ORM. It has only been used and tested with MySQL so far but the intention is to make it SQL agnostic.

(MySQL) Replication Aware Master/Slave Database Adapter for ActiveRecord

查找mysql数据库中重复和冗余索引

A gem to import CSV files' content into a PostgreSQL or MySQL database. It is respectively based on PostgreSQL COPY and MySQL LOAD DATA INFILE which are designed to be as fast as possible.

ar_mysql_flexmaster allows configuring N mysql servers in database.yml and auto-selects which is a master at runtime

Column based, timestamp replication of MySQL and Postgres databases.

MySQL Knife is a Ruby Gem and command line tools, written for UNIX-like operating systems. That allows many connections bookmark and tasks for MySQL Administration.

Easily setup postgres, mysql databases and the nginx (http://sysoev.ru/nginx/) and apache web servers in any combination and on any posix host (ubuntu for now) using capistrano. == FEATURES/PROBLEMS: * install nginx from source/binary * setup & configure nginx * add init script * tasks to start/stop nginx == SYNOPSIS:

A simple, fast Mysql and Drizzle library for Ruby, binding to libdrizzle. Still in early alpha

Connects to both master and slave and compares their status, allowing you to check whether the slave is running and whether slave is caught up to master

A simple, fast Mysql library for Ruby, binding to libmysql

This is the MySQL API module for Ruby. It provides the same functions for Ruby programs that the MySQL C API provides for C programs. Some small mods by http://github.com/lsegal/mysql-ruby for ruby 1.9.1 support for utf-8

It can create postgresql dump from mysql database or directly load data from mysql to postgresql (at about 100 000 records per minute). Translates most data types and indexes.

MySQL Binlog input plugin for Fluentd event collector.

Log MySQL queries with EXPLAIN that may be slow.