�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fbuild%2F'>build</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fbuild%2Fscripts%2F'>scripts</a>/</p><hr><h3>✏️ Editing: wsrep_sst_mysqldump</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>#!/usr/bin/env bash

set -ue

# Copyright (C) 2009-2015 Codership Oy
# Copyright (C) 2017-2024 MariaDB
#
# 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; see the file COPYING. If not, write to the
# Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston
# MA  02110-1335  USA.

# This is a reference script for mariadb-dump-based state snapshot tansfer.

. $(dirname &quot;$0&quot;)/wsrep_sst_common

CLIENT_DIR=&quot;$SCRIPTS_DIR/../client&quot;

if [ -x &quot;$CLIENT_DIR/mariadb&quot; ]; then
    MYSQL_CLIENT=&quot;$CLIENT_DIR/mariadb&quot;
else
    MYSQL_CLIENT=$(commandex &#039;mariadb&#039;)
fi

if [ -x &quot;$CLIENT_DIR/mariadb-dump&quot; ]; then
    MYSQLDUMP=&quot;$CLIENT_DIR/mariadb-dump&quot;
else
    MYSQLDUMP=$(commandex &#039;mariadb-dump&#039;)
fi

wait_previous_sst

EINVAL=22

if test -z &quot;$WSREP_SST_OPT_HOST&quot;;  then wsrep_log_error &quot;HOST cannot be nil&quot;;  exit $EINVAL; fi
if test -z &quot;$WSREP_SST_OPT_PORT&quot;;  then wsrep_log_error &quot;PORT cannot be nil&quot;;  exit $EINVAL; fi
if test -z &quot;$WSREP_SST_OPT_LPORT&quot;; then wsrep_log_error &quot;LPORT cannot be nil&quot;; exit $EINVAL; fi
if test -z &quot;$WSREP_SST_OPT_SOCKET&quot;;then wsrep_log_error &quot;SOCKET cannot be nil&quot;;exit $EINVAL; fi
if test -z &quot;$WSREP_SST_OPT_GTID&quot;;  then wsrep_log_error &quot;GTID cannot be nil&quot;;  exit $EINVAL; fi

if is_local_ip &quot;$WSREP_SST_OPT_HOST_UNESCAPED&quot; &amp;&amp; \
   [ &quot;$WSREP_SST_OPT_PORT&quot; = &quot;$WSREP_SST_OPT_LPORT&quot; ]
then
    wsrep_log_error \
        &quot;destination address &#039;$WSREP_SST_OPT_HOST:$WSREP_SST_OPT_PORT&#039;&quot; \
        &quot;matches source address.&quot;
    exit $EINVAL
fi

# Check client version
if ! $MYSQL_CLIENT --version | grep -q -E &#039;(Distrib 10\.[1-9])|( from 1[1-9]\.)&#039;; then
    $MYSQL_CLIENT --version &gt;&amp;2
    wsrep_log_error &quot;this operation requires MySQL client version 10.1 or newer&quot;
    exit $EINVAL
fi

AUTH=&quot;&quot;
if [ -n &quot;$WSREP_SST_OPT_USER&quot; ]; then
    AUTH=&quot;-u$WSREP_SST_OPT_USER&quot;
fi

# Both donor and joiner must have the same wsrep_sst_auth
# configuration and different (and thus automatically generated)
# authentication credentials can&#039;t be used for this type of SST.
# In this case the SST will fail if joiner does not provide
# correct authentication.
REMOTE_AUTH=&quot;$AUTH&quot;
if [ -n &quot;$WSREP_SST_OPT_REMOTE_USER&quot; ]; then
   REMOTE_AUTH=&quot;-u$WSREP_SST_OPT_REMOTE_USER&quot;
   [ -z &quot;$AUTH&quot; ] &amp;&amp; AUTH=&quot;$REMOTE_AUTH&quot;
fi

# Refs https://github.com/codership/mysql-wsrep/issues/141
# Passing password in MYSQL_PWD environment variable is considered
# &quot;extremely insecure&quot; by MySQL Guidelines for Password Security
# (https://dev.mysql.com/doc/refman/5.6/en/password-security-user.html)
# that is even less secure than passing it on a command line! It is doubtful:
# the whole command line is easily observable by any unprivileged user via ps,
# whereas (at least on Linux) unprivileged user can&#039;t see process environment
# that he does not own. So while it may be not secure in the NSA sense of the
# word, it is arguably more secure than passing password on the command line.
if [ -n &quot;$WSREP_SST_OPT_REMOTE_PSWD&quot; ]; then
    export MYSQL_PWD=&quot;$WSREP_SST_OPT_REMOTE_PSWD&quot;
elif [ -n &quot;$WSREP_SST_OPT_REMOTE_USER&quot; ]; then
    # Empty password, used for testing, debugging etc.
    unset MYSQL_PWD
elif [ -n &quot;$WSREP_SST_OPT_PSWD&quot; ]; then
    export MYSQL_PWD=&quot;$WSREP_SST_OPT_PSWD&quot;
elif [ -n &quot;$WSREP_SST_OPT_USER&quot; ]; then
    # Empty password, used for testing, debugging etc.
    unset MYSQL_PWD
fi

STOP_WSREP=&#039;SET wsrep_on=OFF;&#039;

# mysqldump cannot restore CSV tables, fix this issue
CSV_TABLES_FIX=&quot;
set sql_mode=&#039;&#039;;

USE mysql;

SET @cond = (SELECT (SUPPORT = &#039;YES&#039; or SUPPORT = &#039;DEFAULT&#039;) FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE = &#039;csv&#039;);

SET @stmt = IF (@cond = &#039;1&#039;, &#039;CREATE TABLE IF NOT EXISTS general_log ( event_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), user_host mediumtext NOT NULL, thread_id bigint(21) unsigned NOT NULL, server_id int(10) unsigned NOT NULL, command_type varchar(64) NOT NULL, argument mediumtext NOT NULL) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT=\&quot;General log\&quot;&#039;, &#039;SET @dummy = 0&#039;);

PREPARE stmt FROM @stmt;
EXECUTE stmt;
DROP PREPARE stmt;

SET @stmt = IF (@cond = &#039;1&#039;, &#039;CREATE TABLE IF NOT EXISTS slow_log ( start_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), user_host mediumtext NOT NULL, query_time time(6) NOT NULL, lock_time time(6) NOT NULL, rows_sent bigint(20) UNSIGNED NOT NULL, rows_examined bigint(20) UNSIGNED NOT NULL, db varchar(512) NOT NULL, last_insert_id int(11) NOT NULL, insert_id int(11) NOT NULL, server_id int(10) unsigned NOT NULL, sql_text mediumtext NOT NULL, thread_id bigint(21) unsigned NOT NULL) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT=\&quot;Slow log\&quot;&#039;, &#039;SET @dummy = 0&#039;);

PREPARE stmt FROM @stmt;
EXECUTE stmt;
DROP PREPARE stmt;&quot;

STATE=&quot;$WSREP_SST_OPT_GTID $WSREP_SST_OPT_GTID_DOMAIN_ID&quot;
SET_START_POSITION=&quot;SET GLOBAL wsrep_start_position=&#039;$WSREP_SST_OPT_GTID&#039;;&quot;

SET_WSREP_GTID_DOMAIN_ID=&quot;&quot;
if [ -n &quot;$WSREP_SST_OPT_GTID_DOMAIN_ID&quot; ]; then
    SET_WSREP_GTID_DOMAIN_ID=&quot;
    SET @val = (SELECT GLOBAL_VALUE FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES WHERE VARIABLE_NAME = &#039;WSREP_GTID_STRICT_MODE&#039; AND GLOBAL_VALUE &gt; 0);
    SET @stmt = IF (@val IS NOT NULL, &#039;SET GLOBAL WSREP_GTID_DOMAIN_ID=$WSREP_SST_OPT_GTID_DOMAIN_ID&#039;, &#039;SET @dummy = 0&#039;);
    PREPARE stmt FROM @stmt;
    EXECUTE stmt;
    DROP PREPARE stmt;&quot;
fi

MYSQL=&quot;$MYSQL_CLIENT$WSREP_SST_OPT_CONF_UNQUOTED &quot;\
&quot;$REMOTE_AUTH -h$WSREP_SST_OPT_HOST_UNESCAPED &quot;\
&quot;-P$WSREP_SST_OPT_PORT --disable-reconnect --connect_timeout=10&quot;

# Check if binary logging is enabled on the joiner node.
# Note: SELECT cannot be used at this point.
LOG_BIN=$(echo &quot;set statement wsrep_sync_wait=0 for SHOW VARIABLES LIKE &#039;log_bin&#039;&quot; | $MYSQL | \
tail -1 | awk -F &#039; &#039; &#039;{ print $2 }&#039;)

# Check the joiner node&#039;s server version.
SERVER_VERSION=$(echo &quot;set statement wsrep_sync_wait=0 for SHOW VARIABLES LIKE &#039;version&#039;&quot; | $MYSQL | \
tail -1 | awk -F &#039; &#039; &#039;{ print $2 }&#039;)

# Retrieve the donor&#039;s @@global.gtid_binlog_state.
GTID_BINLOG_STATE=$(echo &quot;SHOW GLOBAL VARIABLES LIKE &#039;gtid_binlog_state&#039;&quot; | $MYSQL | \
tail -1 | awk -F &#039; &#039; &#039;{ print $2 }&#039;)

RESET_MASTER=&quot;&quot;
SET_GTID_BINLOG_STATE=&quot;&quot;
SQL_LOG_BIN_OFF=&quot;&quot;

# Safety check
if [ ${SERVER_VERSION%%.*} -gt 5 ]; then
    # If binary logging is enabled on the joiner node, we need to copy donor&#039;s
    # gtid_binlog_state to joiner. In order to do that, a RESET MASTER must be
    # executed to erase binary logs (if any). Binary logging should also be
    # turned off for the session so that gtid state does not get altered while
    # the dump gets replayed on joiner.
    if [ &quot;$LOG_BIN&quot; = &#039;ON&#039; ]; then
        RESET_MASTER=&quot;SET GLOBAL wsrep_on=OFF; RESET MASTER; SET GLOBAL wsrep_on=ON;&quot;
        SET_GTID_BINLOG_STATE=&quot;SET GLOBAL wsrep_on=OFF; SET @@global.gtid_binlog_state=&#039;$GTID_BINLOG_STATE&#039;; SET GLOBAL wsrep_on=ON;&quot;
        SQL_LOG_BIN_OFF=&quot;SET @@session.sql_log_bin=OFF;&quot;
    fi
fi

# NOTE: we don&#039;t use --routines here because we&#039;re dumping mysql.proc table
MYSQLDUMP=&quot;$MYSQLDUMP$WSREP_SST_OPT_CONF_UNQUOTED $AUTH -S$WSREP_SST_OPT_SOCKET \
--add-drop-database --add-drop-table --skip-add-locks --create-options \
--disable-keys --extended-insert --skip-lock-tables --quick --set-charset \
--skip-comments --flush-privileges --all-databases --events&quot;

if [ $WSREP_SST_OPT_BYPASS -eq 0 ]
then
    # need to disable logging when loading the dump
    # reason is that dump contains ALTER TABLE for log tables, and
    # this causes an error if logging is enabled
    GENERAL_LOG_OPT=$($MYSQL --skip-column-names -e &quot;$STOP_WSREP SELECT @@GENERAL_LOG&quot;)
    SLOW_LOG_OPT=$($MYSQL --skip-column-names -e &quot;$STOP_WSREP SELECT @@LOG_SLOW_QUERY&quot;)

    LOG_OFF=&quot;SET GLOBAL GENERAL_LOG=OFF; SET GLOBAL LOG_SLOW_QUERY=OFF;&quot;

    # commands to restore log settings
    RESTORE_GENERAL_LOG=&quot;SET GLOBAL GENERAL_LOG=$GENERAL_LOG_OPT;&quot;
    RESTORE_SLOW_QUERY_LOG=&quot;SET GLOBAL LOG_SLOW_QUERY=$SLOW_LOG_OPT;&quot;

    (echo &quot;$STOP_WSREP&quot; &amp;&amp; echo &quot;$LOG_OFF&quot; &amp;&amp; echo &quot;$RESET_MASTER&quot; &amp;&amp; \
     echo &quot;$SET_GTID_BINLOG_STATE&quot; &amp;&amp; echo &quot;$SQL_LOG_BIN_OFF&quot; &amp;&amp; \
     echo &quot;$STOP_WSREP&quot; &amp;&amp; $MYSQLDUMP &amp;&amp; echo &quot;$CSV_TABLES_FIX&quot; &amp;&amp; \
     echo &quot;$RESTORE_GENERAL_LOG&quot; &amp;&amp; echo &quot;$RESTORE_SLOW_QUERY_LOG&quot; &amp;&amp; \
     echo &quot;$SET_START_POSITION&quot; &amp;&amp; echo &quot;$SET_WSREP_GTID_DOMAIN_ID&quot; \
     || echo &quot;SST failed to complete;&quot;) | $MYSQL || exit $?
else
    wsrep_log_info &quot;Bypassing state dump.&quot;
    echo &quot;$SET_START_POSITION&quot; | $MYSQL || exit $?
fi

echo &quot;done $STATE&quot;

wsrep_log_info &quot;$WSREP_METHOD $WSREP_TRANSFER_TYPE completed on $WSREP_SST_OPT_ROLE&quot;
exit 0
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fbuild%2Fscripts'>🔙 Back</a></p>