Class: MysqlIsolatedServer

Inherits:
Object
  • Object
show all
Includes:
DBConnection, Socket::Constants
Defined in:
lib/mysql_isolated_server.rb,
lib/mysql_isolated_server/version.rb,
lib/mysql_isolated_server/jdbc_connection.rb,
lib/mysql_isolated_server/mysql2_connection.rb

Defined Under Namespace

Modules: DBConnection Classes: WrappedJDBCConnection

Constant Summary collapse

MYSQL_BASE_DIR = 
"/usr"
VERSION = 
"0.4.0"

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Methods included from DBConnection

#connection

Constructor Details

#initialize(options = {}) ⇒ MysqlIsolatedServer

Returns a new instance of MysqlIsolatedServer.



16
17
18
19
20
21
22
23
24
25
26
27
 
# File 'lib/mysql_isolated_server.rb', line 16

def initialize(options = {})
  @base = options[:base] || Dir.mktmpdir("mysql_isolated", "/tmp")
  @mysql_data_dir="#{@base}/mysqld"
  @mysql_socket="#{@mysql_data_dir}/mysqld.sock"
  @params = options[:params]
  @load_data_path = options[:data_path]
  @port = options[:port]
  @allow_output = options[:allow_output]
  @log_bin = options[:log_bin] || "--log-bin"
  @parent_pid = options[:pid]
  @server_id = rand(2**31)
end

Instance Attribute Details

#base ⇒ Object (readonly)

Returns the value of attribute base.



12
13
14
 
# File 'lib/mysql_isolated_server.rb', line 12

def base
  @base
end

#params ⇒ Object

Returns the value of attribute params.



13
14
15
 
# File 'lib/mysql_isolated_server.rb', line 13

def params
  @params
end

#pid ⇒ Object (readonly)

Returns the value of attribute pid.



12
13
14
 
# File 'lib/mysql_isolated_server.rb', line 12

def pid
  @pid
end

#port ⇒ Object (readonly)

Returns the value of attribute port.



12
13
14
 
# File 'lib/mysql_isolated_server.rb', line 12

def port
  @port
end

Class Method Details

.thread_boot(*params) ⇒ Object 



29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
 
# File 'lib/mysql_isolated_server.rb', line 29

def self.thread_boot(*params)
  bin = [File.dirname(__FILE__) + "/../bin/boot_isolated_server"]
  mysql_dir, mysql_port = nil, nil
  restore_env = {}

  if `which ruby` =~ (/rvm/)
    bin = ["rvm", "1.8.7", "do", "ruby"] + bin
  end

  params = ["--pid", $$.to_s] + params

  Thread.abort_on_exception = true
  Thread.new do
    ENV.keys.grep(/GEM|BUNDLE|RUBYOPT/).each do |k|
      restore_env[k] = ENV.delete(k)
    end
    pipe = IO.popen(bin + params, "r") do |pipe|
      mysql_dir = pipe.readline.split(' ').last
      mysql_port = pipe.readline.split(' ').last.to_i
      sleep
    end
  end

  while mysql_port.nil?
    sleep 1
  end
  new(:port => mysql_port, :base => mysql_dir)
end

Instance Method Details

#boot! ⇒ Object 



106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
 
# File 'lib/mysql_isolated_server.rb', line 106

def boot!
  @port ||= grab_free_port
  system("rm -Rf #{@mysql_data_dir}")
  system("mkdir #{@mysql_data_dir}")
  if @load_data_path
    system("cp -a #{@load_data_path}/* #{@mysql_data_dir}")
    system("rm -f #{@mysql_data_dir}/relay-log.info")
  else
    mysql_install_db = locate_executable("mysql_install_db")

    idb_path = File.dirname(mysql_install_db)
    system("(cd #{idb_path}/..; mysql_install_db --datadir=#{@mysql_data_dir} --user=`whoami`) >/dev/null 2>&1")
    system("cp #{File.expand_path(File.dirname(__FILE__))}/tables/user.* #{@mysql_data_dir}/mysql")
  end

  if !@log_bin
    @log_bin = "--log-bin"
  else
    if @log_bin[0] != '/'
      binlog_dir = "#{@mysql_data_dir}/#{@log_bin}"
    else
      binlog_dir = @log_bin
    end

    system("mkdir -p #{binlog_dir}")
    @log_bin = "--log-bin=#{binlog_dir}"
  end

  up!

  tzinfo_to_sql = locate_executable("mysql_tzinfo_to_sql5", "mysql_tzinfo_to_sql")
  raise "could not find mysql_tzinfo_to_sql" unless tzinfo_to_sql
  system("#{tzinfo_to_sql} /usr/share/zoneinfo 2>/dev/null| mysql -h127.0.0.1 --database=mysql --port=#{@port} -u root mysql ")

  begin
    connection.query("SET GLOBAL time_zone='UTC'")
  rescue Mysql2::Error
    connection.query("SET GLOBAL time_zone='UTC'")
  end

  connection.query("SET GLOBAL server_id=#{@server_id}")
end

#cleanup! ⇒ Object 



217
218
219
 
# File 'lib/mysql_isolated_server.rb', line 217

def cleanup!
  system("rm -Rf #{base}")
end

#down! ⇒ Object 



98
99
100
101
102
103
104
 
# File 'lib/mysql_isolated_server.rb', line 98

def down!
  Process.kill("TERM", @pid)
  while (Process.kill 0, @pid rescue false)
    sleep 1
  end
  @cx = nil
end

#exec_server(cmd) ⇒ Object 



165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
 
# File 'lib/mysql_isolated_server.rb', line 165

def exec_server(cmd)
  cmd.strip!
  cmd.gsub!(/\\\n/, ' ')
  devnull = File.open("/dev/null", "w")
  system("mkdir -p #{base}/tmp")
  system("chmod 0777 #{base}/tmp")

  parent_pid = @parent_pid || $$
  mysql_pid = nil

  middle_pid = fork do
    mysql_pid = fork do
      ENV["TMPDIR"] = "#{base}/tmp"
      if !@allow_output
        STDOUT.reopen(devnull)
        STDERR.reopen(devnull)
      end

      exec(cmd)
    end

    # begin waiting for the parent (or mysql) to die; at_exit is hard to control when interacting with test/unit
    # we can also be killed by our parent with down! and up!
    #
    ["TERM", "INT"].each do |sig|
      trap(sig) do
        Process.kill("KILL", mysql_pid) rescue nil
        cleanup!
        exit!
      end
    end

    while true
      begin
        Process.kill(0, parent_pid)
        Process.kill(0, mysql_pid)
      rescue Exception => e
        Process.kill("KILL", mysql_pid)
        cleanup!
        exit!
      end

      sleep 1
    end
  end

  @pid = middle_pid
end

#grab_free_port ⇒ Object 



150
151
152
153
154
155
156
157
158
159
160
161
162
 
# File 'lib/mysql_isolated_server.rb', line 150

def grab_free_port
  while true
    candidate=9000 + rand(50_000)

    begin
      socket = Socket.new(AF_INET, SOCK_STREAM, 0)
      socket.bind(Socket.pack_sockaddr_in(candidate, '127.0.0.1'))
      socket.close
      return candidate
    rescue Exception => e
    end
  end
end

#kill! ⇒ Object 



221
222
223
224
 
# File 'lib/mysql_isolated_server.rb', line 221

def kill!
  return unless @pid
  system("kill -TERM #{@pid}")
end

#locate_executable(*candidates) ⇒ Object 



78
79
80
81
82
 
# File 'lib/mysql_isolated_server.rb', line 78

def locate_executable(*candidates)
  output = `which #{candidates.join(' ')}`
  raise "I couldn't find any of these: #{candidates.join(',')} in $PATH" if output.chomp.empty?
  output.split("\n").first
end

#make_slave_of(master) ⇒ Object 



58
59
60
61
62
63
64
65
66
67
68
69
70
 
# File 'lib/mysql_isolated_server.rb', line 58

def make_slave_of(master)
  master_binlog_info = master.connection.query("show master status").first
  connection.query(<<-EOL
    change master to master_host='127.0.0.1',
                     master_port=#{master.port},
                     master_user='root', master_password='',
                     master_log_file='#{master_binlog_info['File']}',
                     master_log_pos=#{master_binlog_info['Position']}
    EOL
  )
  connection.query("SLAVE START")
  connection.query("SET GLOBAL READ_ONLY=1")
end

#mysql_shell ⇒ Object 



214
215
216
 
# File 'lib/mysql_isolated_server.rb', line 214

def mysql_shell
  system("mysql -uroot --port #{@port} mysql --host 127.0.0.1")
end

#set_rw(rw) ⇒ Object 



72
73
74
75
 
# File 'lib/mysql_isolated_server.rb', line 72

def set_rw(rw)
  ro = rw ? 0 : 1
  connection.query("SET GLOBAL READ_ONLY=#{ro}")
end

#up! ⇒ Object 



84
85
86
87
88
89
90
91
92
93
94
95
96
 
# File 'lib/mysql_isolated_server.rb', line 84

def up!
  mysqld = locate_executable("mysqld")

  exec_server <<-EOL
      #{mysqld} --no-defaults --default-storage-engine=innodb \
              --datadir=#{@mysql_data_dir} --pid-file=#{@base}/mysqld.pid --port=#{@port} \
              #{@params} --socket=#{@mysql_data_dir}/mysql.sock #{@log_bin} --log-slave-updates
  EOL

  while !system("mysql -h127.0.0.1 --port=#{@port} --database=mysql -u root -e 'select 1' >/dev/null 2>&1")
    sleep(0.1)
  end
end