#!/usr/bin/perl # make_multiple_custom_sandbox # The MySQL Sandbox # Copyright (C) 2006-2018 Giuseppe Maxia # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. use strict; use warnings; use English qw( -no_match_vars ); use Data::Dumper; use Getopt::Long qw(:config no_ignore_case ); use MySQL::Sandbox qw(get_ranges runs_as_root use_env sbinstr); use MySQL::Sandbox::Scripts; my $DEBUG = $MySQL::Sandbox::DEBUG; runs_as_root(); my %defaults = ( custom_base_port => $MySQL::Sandbox::default_base_port{custom}, group_directory => 'multi_cmsb', ); unless ( -d $ENV{'SANDBOX_HOME'} ) { mkdir $ENV{'SANDBOX_HOME'} or die "can't create $ENV{'SANDBOX_HOME'} ($CHILD_ERROR) \n"; } #my $install_dir; #$install_dir = $PROGRAM_NAME; #$install_dir =~ s{/\w+(\.pl)?$}{}; #eval "use lib q($install_dir)"; #eval "use MySandbox"; #eval "use MyScripts"; my $msb = MySQL::Sandbox->new(); $msb->parse_options (MySQL::Sandbox::Scripts::parse_options_many() ); GetOptions ( map { $msb->{parse_options}{$_}{parse}, \$msb->{options}{$_} } grep { $msb->{parse_options}{$_}{parse}} keys %{$msb->{parse_options}} ) or $msb->get_help(); $msb->get_help() if $msb->{options}{'help'}; unless ($msb->{options}{server_version}) { $msb->{options}{server_version} = join(':', @ARGV); @ARGV > 0 or $msb->get_help('server version required'); } if ($msb->{options}{node_options}) { $ENV{NODE_OPTIONS} = $msb->{options}{node_options}; } if ($msb->{options}{one_node_options}) { for my $node_opt (@{ $msb->{options}{one_node_options}} ) { if ($node_opt =~ /^(\d+):\s*(\S.+)/) { $ENV{"NODE${1}_OPTIONS"} = $2; } else { get_help("invalid format for --one_node_option ($node_opt)"); } } } my $replication_port = 0; my @base_version ; my @dashed_version ; my @versions= split /[,:;]/, $msb->{options}{server_version}; my $counter =0; for my $ver (@versions) { my $temp_path = $ver; $temp_path =~ s{.*/}{}; my $prefix =''; if ( $temp_path =~ /^(\D+)\d+/ ) { $prefix = $1; } if ( $temp_path =~ /(\d+)\.(\d+)\.(\d+)/ ) { $base_version[$counter] = "$1$2$3"; $dashed_version[$counter] = "${prefix}$1_$2_$3"; $base_version[$counter] =~ s/^0+//; $counter++; } else { $msb->get_help("No recognizable version pattern in $msb->{options}{server_version}\n"); } } my $group_directory ; if ( $msb->{options}{group_directory}) { $group_directory = "$msb->{options}{upper_directory}/$msb->{options}{group_directory}"; } else { $group_directory = "$msb->{options}{upper_directory}/" . make_group_dir( $defaults{group_directory}, \@dashed_version); } if ( -d $group_directory ) { system "$group_directory/clear_all"; } else { print "creating replication directory $group_directory\n" if $msb->{options}{verbose}; mkdir $group_directory or die "can't create $group_directory \n"; } for my $dir ( 1 .. @versions ) { if ( -d "$group_directory/node$dir" ) { system "rm -rf $group_directory/node$dir" and die "unable to clean $group_directory/node$dir\n"; } } my $custom_base_port = 0; if ( $msb->{options}{sandbox_base_port}) { $custom_base_port = $msb->{options}{sandbox_base_port}; } else { $custom_base_port = $defaults{custom_base_port}; } if ( $msb->{options}{check_base_port}) { $custom_base_port = get_ranges({ min_range => $custom_base_port, range_size => $#versions, max_range => 64000, search_path => $ENV{SANDBOX_HOME}, }, 1); } for my $ver_counter (0 .. $#versions) { if ( $msb->{options}{sandbox_base_port}) { $replication_port = $custom_base_port; } else { $replication_port = $custom_base_port + $base_version[$ver_counter]; } my $additional_node_options = $ENV{NODE_OPTIONS} || ''; $additional_node_options .= q{ }; my $node = $ver_counter + 1; my $node_port = $replication_port+ $node; print "installing node $node\n"; my $this_node_options = $ENV{"NODE${node}_OPTIONS"} || ''; my $install_node = ''; my $install_node_command = qq( make_sandbox $versions[$ver_counter] -- \\ --datadir_from=script \\ --upper_directory=$group_directory \\ --sandbox_directory=node$node \\ --no_confirm \\ --no_check_port \\ --prompt_prefix=node$node \\ --sandbox_port=$node_port \\ --history_dir=$group_directory \\ -c server-id=10$node \\ -c relay-log-index=mysql-relay \\ -c relay-log=mysql-relay \\ -c log-bin=mysql-bin $additional_node_options ); if ($msb->{options}{interactive} or ($additional_node_options =~ /\binteractive\b/)) { system($install_node_command); } else { $install_node = qx($install_node_command); } print $install_node if $msb->{options}{verbose}; if ($CHILD_ERROR) { print "error installing node $node\n"; print "$install_node\n($CHILD_ERROR $OS_ERROR)\n"; exit(1) } # sleep 1; } my $current_dir = $ENV{PWD}; chdir $group_directory; for my $cmd ( qw(start stop clear send_kill ) ) { my $cmd_fname = $cmd . '_all'; $msb->write_to($cmd_fname, '>', '#!/bin/sh'); $msb->write_to($cmd_fname, '>>', qq(echo '# executing "$cmd"' on $group_directory)); for my $node (1 .. @versions ) { $msb->write_to ($cmd_fname, '>>', qq(echo 'executing "$cmd" on node $node')); $msb->write_to ($cmd_fname, '>>', qq($group_directory/node$node/$cmd "\$@")); } chmod 0755, $cmd_fname; } $msb->write_to('restart_all', '>', '#!/bin/sh'); $msb->write_to('restart_all', '>>', qq($group_directory/stop_all)); $msb->write_to('restart_all', '>>', qq($group_directory/start_all "\$@")); chmod 0755, 'restart_all'; $msb->write_to('use_all', '>', '#!/bin/sh'); my $node_list = join(' ', (1 .. @versions ) ); $msb->write_to('use_all', '>>', 'if [ "$1" = "" ]'); $msb->write_to('use_all', '>>', 'then'); $msb->write_to('use_all', '>>', ' echo "syntax: $0 command"'); $msb->write_to('use_all', '>>', ' exit 1'); $msb->write_to('use_all', '>>', 'fi'); $msb->write_to('use_all', '>>', ''); $msb->write_to('use_all', '>>', 'for SNUM in ' . $node_list); $msb->write_to('use_all', '>>', 'do ' ); $msb->write_to('use_all', '>>', ' echo "# server: $SNUM " ' ); $msb->write_to('use_all', '>>', ' echo "$@" | ' . $group_directory . '/node$SNUM/use $MYCLIENT_OPTIONS '); $msb->write_to('use_all', '>>', 'done ' ); chmod 0755, 'use_all'; $msb->write_to('status_all', '>', '#!/bin/sh'); my $gdir = $group_directory; $gdir =~ s{.*/}{}; $msb->write_to('status_all', '>>', "echo CUSTOM $gdir" ); $msb->write_to('status_all', '>>', 'for SNUM in ' . $node_list); $msb->write_to('status_all', '>>', 'do ' ); $msb->write_to('status_all', '>>', $group_directory . '/node$SNUM/status'); $msb->write_to('status_all', '>>', 'done ' ); chmod 0755, 'status_all'; for my $node (1 .. @versions ) { $msb->write_to("n$node", '>', "#!/bin/sh"); $msb->write_to("n$node", '>', qq($group_directory/node$node/use "\$@")); chmod 0755, "n$node"; } my @nodes ; for my $N (1 .. $msb->{options}{how_many_nodes}) { push @nodes, "node$N"; } for my $json (qw(connection.json default_connection.json)) { my $json_text = MySQL::Sandbox::get_json_from_dirs(\@nodes, $json); $msb->write_to($json, '>', $json_text); } $msb->write_to('README', '>', MySQL::Sandbox::Scripts::get_readme_multiple()); $msb->write_to('README', '>', MySQL::Sandbox::Scripts::get_readme_common()); chdir $current_dir; print "group directory installed in ", use_env($group_directory),"\n"; sbinstr( "group_directory installed in <" . use_env($group_directory) . ">"); sub make_group_dir { my ($base_dir, $dashed) = @_; my @copy_dashed = @$dashed; my $suffix = ''; if (@copy_dashed > 3) { $suffix = join('-', map { s/(\d+_\d+).*/$1/; $_ } @copy_dashed ); } else { $suffix = join('-', @$dashed); } return $base_dir . '_' . $suffix; } __END__