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 4.2, 5.x and 6.0, and has in some form or another been used in production on large Rails apps for several years.
$ gem install active_record_shards
and make sure to require 'active_record_shards' in some way.
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.
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
Create a table for the shared (not sharded) model
class CreateAccounts < ::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 < ::Migration shard :all def change create_table :projects do |t| t.references :account t.string :name end end end
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 < :: not_sharded has_many :projects end class Project < :: 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 ::.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:
::.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:
Show if a query went to primary or replica in the logs:
require 'active_record_shards/sql_comments' ActiveRecordShards::SqlComments.enable
Copyright (c) 2011 Zendesk. See LICENSE for details.
Mick Staugaard, Eric Chapweske