Sha256: 09c3b1be2ec0116cd1927292330bcbe1abdaa01cdbe6e2d39ea382458a47a1de

Contents?: true

Size: 736 Bytes

Versions: 11

Compression:

Stored size: 736 Bytes

Contents

class ProxySQLHelper
  class << self
    # Flips the destination hostgroup for /maintenance:lhm/ from 0 (i.e. writer) to 1 (i.e. reader)
    def with_lhm_hostgroup_flip
      conn = DATABASE.client.new(
        host: '127.0.0.1',
        username: "remote-admin",
        password: "password",
        port: "6032",
      )

      begin
        conn.query("UPDATE mysql_query_rules SET destination_hostgroup=1 WHERE match_pattern=\"maintenance:lhm\"")
        conn.query("LOAD MYSQL QUERY RULES TO RUNTIME;")
        yield
      ensure
        conn.query("UPDATE mysql_query_rules SET destination_hostgroup=0 WHERE match_pattern=\"maintenance:lhm\"")
        conn.query("LOAD MYSQL QUERY RULES TO RUNTIME;")
      end
    end
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version Path
lhm-shopify-4.5.0 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.4.2 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.4.1 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.4.0 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.3.0 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.2.3 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.2.2 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.2.1 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.2.0 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.1.1 spec/integration/sql_retry/proxysql_helper.rb
lhm-shopify-4.1.0 spec/integration/sql_retry/proxysql_helper.rb