Class: Specinfra::Command::Linux::Base::Mysql

Inherits:
Base
  • Object
show all
Defined in:
lib/extension/specinfra/command/linux/base/mysql.rb

Class Method Summary collapse

Class Method Details

.check_is_replicated(master = nil, user = nil, password = nil, port = nil) ⇒ Object 



3
4
5
6
7
8
9
10
11
12
13
 
# File 'lib/extension/specinfra/command/linux/base/mysql.rb', line 3

def check_is_replicated(master=nil, user=nil, password=nil, port=nil)
  opt_user     = "--user=#{user} " || ''
  opt_password = "--password=#{password} " || ''
  opt_port     = "--port=#{port} " || ''

  cmd = ''
  cmd += "echo 'show slave status \\G;' | mysql #{opt_user} #{opt_password} #{opt_port} | "
  cmd += "grep -e 'Slave_IO_Running: Yes' -e 'Slave_SQL_Running: Yes' -e 'Master_Host: #{master}' | "
  cmd += "wc -l | grep -w 3"
  cmd
end