There's a lot of open issues
A long-lived project that still receives updates
Easily run queries on shard and replica databases.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

>= 0
>= 5.10.0
>= 0
~> 12.0
~> 0.77.0

Runtime

>= 5.1, < 7.1
>= 5.1, < 7.1
 Project Readme

Build Status

ActiveRecord Shards

ActiveRecord Shards is an extension for ActiveRecord that provides support for sharded database and replicas. Basically it is just a nice way to switch between database connections. We've made the implementation very small, and have tried not to reinvent any wheels already present in ActiveRecord.

ActiveRecord Shards has been used and tested on Rails 5.x and 6.0, and has in some form or another been used in production on large Rails apps for several years.

Rails 6.1 introduced new connection handling and support for sharding. Apps are encouraged to migrate to the native sharding logic but ActiveRecord Shards supports Rails 6.1 when legacy_connection_handling is set to true. For more information see Rails 6.1 installation and Rails' multiple databases guide.

  • Installation
  • Configuration
  • Migrations
    • Example
      • Shared Model
      • Sharded Model
  • Usage
  • Debugging

Installation

$ gem install active_record_shards

and make sure to require 'active_record_shards' in some way.

Rails 6.1 & 7.0 installation

Rails 6.1 & 7.0 are only supported with legacy_connection_handling set to true.

Enable the legacy handling in your configuration files e.g. config/application.rb by setting:

config.active_record.legacy_connection_handling = true

or

ActiveRecord::Base.legacy_connection_handling = true

Configuration

Add the replica and shard configuration to config/database.yml:

production:
  adapter: mysql
  encoding: utf8
  database: my_app_main
  pool: 5
  host: db1
  username: root
  password:
  replica:
    host: db1_replica
  shards:
    1:
      host: db_shard1
      database: my_app_shard
      replica:
        host: db_shard1_replica
    2:
      host: db_shard2
      database: my_app_shard
      replica:
        host: db_shard2_replica

basically connections inherit configuration from the parent configuration file.

Migrations

ActiveRecord Shards also patches migrations to support running migrations on a shared (not sharded) or a sharded database. Each migration class has to specify a shard spec indicating where to run the migration.

Valid shard specs:

  • :none - Run this migration on the shared database, not any shards
  • :all - Run this migration on all of the shards, not the shared database

Example

Create a table for the shared (not sharded) model
class CreateAccounts < ActiveRecord::Migration
  shard :none

  def change
    create_table :accounts do |t|
      # This is NOT necessary for the gem to work, we just use it in the examples below demonstrating one way to switch shards
      t.integer :shard_id, null: false

      t.string :name
    end
  end
end
Create a table for the sharded model
class CreateProjects < ActiveRecord::Migration
  shard :all

  def change
    create_table :projects do |t|
      t.references :account
      t.string :name
    end
  end
end

Usage

Normally you have some models that live on a shared database, and you might need to query this data in order to know what shard to switch to. All the models that live on the shared database must be marked as not_sharded:

class Account < ActiveRecord::Base
  not_sharded

  has_many :projects
end

class Project < ActiveRecord::Base
  belongs_to :account
end

So in this setup the accounts live on the shared database, but the projects are sharded. If accounts have a shard_id column, you could lookup the account in a rack middleware and switch to the right shard:

class AccountMiddleware
  def initialize(app)
    @app = app
  end

  def call(env)
    account = lookup_account(env)

    if account
      ActiveRecord::Base.on_shard(account.shard_id) do
        @app.call(env)
      end
    else
      @app.call(env)
    end
  end

  def lookup_account(env)
    # ...
  end
end

You can switch to the replica databases at any point by wrapping your code in an on_replica block:

ActiveRecord::Base.on_replica do
  Account.find_by_big_expensive_query
end

This will perform the query on the replica, and mark the returned instances as read-only. There is also a shortcut for this:

Account.on_replica.find_by_big_expensive_query

If you do not want instances returned from replicas to be marked as read-only, this can be disabled globally:

ActiveRecordShards.disable_replica_readonly_records = true

Debugging

Show if a query went to primary or replica in the logs:

require 'active_record_shards/sql_comments'
ActiveRecordShards::SqlComments.enable

Copyright

Copyright (c) 2011 Zendesk. See LICENSE for details.

Authors

Mick Staugaard, Eric Chapweske