Octopus Replication Tracking

This Gem is extension of ar-octopus to help to find replication file and position number for each shard.

• Currently only working for mysql2 adapter
• DB user requires to have access show master status; and show slave status;
• This statement provides status information about the binary log files of the master or slave. It requires either the SUPER or REPLICATION CLIENT privilege.

Add this line to Gemfile:

gem 'ar-octopus-replication-tracking'

Setup shards.yml and ready to use.

octopus:
  environments:
    - development
  development:
    earth:
      captain_america:
        adapter: mysql2
        database: captain_america_db
      hulk:
        adapter: mysql2
        database: hulk_db
      ironman:
        adapter: mysql2
        database: ironman_db
    galaxy:
      i_am_groot:
        adapter: mysql2
        database: i_am_grout_db

Replication status from captain_america shard

> Octopus.replication_position(:captain_america)
=> {:file_name=>"mysql-bin.000001", :position=>36668586}

Replication status from ironman shard

Octopus.replication_position(:ironman)
=> {:file_name=>"mysql-bin.000001", :position=>36668583}

Replication status from slave group

Octopus.replication_position(slave_group: :galaxy)
=> {:file_name=>"mysql-bin.000001", :position=>36668586}