이 Fork 에 대한 설명

• ⚠️ winebarrel/activerecord-mysql-reconnect 이 Archive 상태라서, 지원 타겟 범위를 줄여서 포크합니다.
• 지원타겟 : mysql8 , ActiveRecord ~> 6.1

빌드와 배포

인증

• GH_TOKEN 은 https://github.com/settings/tokens 에서 획득한다.

# bundle config https://rubygems.pkg.github.com/ffdd USERNAME:TOKEN
# VERSION 은 lib/activerecord/mysql/reconnect/version.rb 를 따른다.

echo ":github: Bearer ${GH_TOKEN}" >> ~/.gem/credentials
chmod 600 ~/.gem/credentials

실행

rake build 
gem push --key github --host https://rubygems.pkg.github.com/ffdd pkg/activerecord-mysql-reconnect-${VERSION}.gem

Usage

gem "activerecord-mysql-reconnect", source: "https://rubygems.pkg.github.com/ffdd"

activerecord-mysql-reconnect

Introduction

It is the library to reconnect automatically when ActiveRecord is disconnected from MySQL.

Installation

Add this line to your application's Gemfile:

gem 'activerecord-mysql-reconnect'

And then execute:

$ bundle

Or install it yourself as:

$ gem install activerecord-mysql-reconnect

Usage

require 'active_record'
require 'activerecord-mysql-reconnect'
require 'logger'

ActiveRecord::Base.establish_connection(
  adapter:  'mysql2',
  host:     '127.0.0.1',
  username: 'root',
  database: 'employees',
)

ActiveRecord::Base.logger = Logger.new($stdout)
ActiveRecord::Base.logger.formatter = proc {|_, _, _, message| "#{message}\n" }
ActiveRecord::Base.enable_retry = true
ActiveRecord::Base.execution_tries = 3

class Employee < ActiveRecord::Base; end

p Employee.count
system('sudo /etc/init.d/mysqld restart')
p Employee.count

shell> ruby test.rb
   (64.1ms)  SELECT COUNT(*) FROM `employees`
300024
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
   (0.4ms)  SELECT COUNT(*) FROM `employees`
Mysql2::Error: MySQL server has gone away: SELECT COUNT(*) FROM `employees`
MySQL server has gone away. Trying to reconnect in 0.5 seconds. (cause: Mysql2::Error: MySQL server has gone away: SELECT COUNT(*) FROM `employees` [ActiveRecord::StatementInvalid], connection: host=127.0.0.1;database=employees;username=root)
   (101.5ms)  SELECT COUNT(*) FROM `employees`
300024

without_retry

ActiveRecord::Base.without_retry do
  Employee.count
end

Add a retry error message

Activerecord::Mysql::Reconnect.handle_rw_error_messages.update(
  zapzapzap: 'ZapZapZap'
)
# or `Activerecord::Mysql::Reconnect.handle_r_error_messages...`

Use on rails

Gemfile

gem 'activerecord-mysql-reconnect'

environment file

MyApp::Application.configure do
  ...
  config.active_record.enable_retry = true
  #config.active_record.retry_databases = :employees
  # e.g. [:employees]
  #      ['employees', 'localhost:test', '192.168.1.1:users']
  #      ['192.168.%:emp\_all']
  #      ['emp%']
  # retry_databases -> nil: retry all databases (default)
  config.active_record.execution_tries = 10 # times
  # execution_tries -> 0: retry indefinitely
  config.active_record.execution_retry_wait = 1.5 # sec
  config.active_record.retry_mode = :rw # default: `:r`, valid values: `:r`, `:rw`, `:force`
  ...
ene

Retry mode

• :r Retry only SELECT / SHOW / SET
• :rw Retry in all SQL, but does not retry if Lost connection has happened in write SQL
• :force Retry in all SQL

Run tests

It requires the following:

• Docker
• Docker Compose

bundle install

bundle exec appraisal activerecord-6.1 rake
bundle exec appraisal activerecord-7.0 rake