This file is indexed.

/etc/init.d/mysql is in percona-xtradb-cluster-server-5.7 5.7.20-29.24-0ubuntu2.

This file is owned by root:root, with mode 0o755.

The actual contents of the file can be viewed below.

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 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
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
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
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
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
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
#!/bin/bash
#
### BEGIN INIT INFO
# Provides:          mysql
# Required-Start:    $remote_fs $syslog
# Required-Stop:     $remote_fs $syslog
# Should-Start:      $network $named $time
# Should-Stop:       $network $named $time
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Start and stop the mysql (Percona XtraDB Cluster) daemon
# Description:       Controls the main MySQL (Percona XtraDB Cluster) daemon "mysqld"
#                    and its wrapper script "mysqld_safe".
### END INIT INFO
#
set -e
set -u

# source the defauts file /etc/default/mysql if it exists for any environment variables.
# set -a is done so that  'FOO=BAR' just be used than 'export FOO=BAR' in the /etc/default/mysql.
# However, export FOO=BAR in that file also should work.
set -a
[ -r /etc/default/mysql ] && . /etc/default/mysql
set +a


${DEBIAN_SCRIPT_DEBUG:+ set -v -x}
PERCONA_PREFIX=/usr
startup_timeout=900
stop_timeout=300
startup_sleep=1

test -x "${PERCONA_PREFIX}"/sbin/mysqld || exit 0

. /lib/lsb/init-functions

SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
CONF=/etc/mysql/my.cnf

# priority can be overriden and "-s" adds output to stderr
ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql -i"

# Safeguard (relative paths, core dumps..)
cd /
umask 077

# mysqladmin likes to read /root/.my.cnf. This is usually not what I want
# as many admins e.g. only store a password without a username there and
# so break my scripts.
export HOME=/etc/mysql/

## Fetch a particular option from mysql's invocation.
#
# Usage: void mysqld_get_param option
mysqld_get_param() {
	"${PERCONA_PREFIX}"/sbin/mysqld --print-defaults \
                | tr " " "\n" | awk -F= '{if ($1 ~ /_/) { gsub(/_/,"-",$1); print $1"="$2 } else { print $0 }}' \
		| grep -- "--$1=" \
		| tail -n 1 \
		| cut -d= -f2
}

## Do some sanity checks before even trying to start mysqld.
sanity_checks() {
  # check for config file
  # DISABLED: We do not install my.cnf
  #if [ ! -r /etc/mysql/my.cnf ]; then
  #  log_warning_msg "$0: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz"
  #  echo                "WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz" | $ERR_LOGGER
  #fi

  # check for diskspace shortage
  datadir=`mysqld_get_param datadir`
  if LC_ALL=C BLOCKSIZE= df --portability $datadir/. | tail -n 1 | awk '{ exit ($4>4096) }'; then
    log_failure_msg "$0: ERROR: The partition with $datadir is too full!"
    echo                "ERROR: The partition with $datadir is too full!" | $ERR_LOGGER
    exit 1
  fi

  if test -e $sst_progress_file;then 
	log_daemon_msg "Stale sst_in_progress file in datadir" "mysqld"
  fi
}

# Get the pid file
mysql_data_dir=$(mysqld_get_param datadir)
[ ! $mysql_data_dir ] && mysql_data_dir="/var/lib/percona-xtradb-cluster"

pid_file=$(mysqld_get_param pid-file)

if test -z "$pid_file"
then
    pid_file="$mysql_data_dir/$(hostname).pid"
else
  case "$pid_file" in
    /* ) ;;
    * )  pid_file="$mysql_data_dir/$pid_file" ;;
  esac
fi

sst_progress_file=$mysql_data_dir/sst_in_progress
## Checks if there is a server running and if so if it is accessible.
#
# check_alive insists on a pingable server
# check_dead also fails if there is a lost mysqld in the process list
#
# Usage: boolean mysqld_status [check_alive|check_dead] [warn|nowarn]
mysqld_status () {
    mysqld_pid=$(cat $pid_file 2>/dev/null)

    if [ ! $mysqld_pid ];then 
        echo "MySQL PID not found, pid_file detected/guessed: $pid_file" | $ERR_LOGGER
        if [ "$1" = "check_dead" ]; then
            return 0
        fi
        return 1
    fi

    ping_alive=1
    ps_alive=0
    
    if ! mysqladmin ping &>/dev/null;then
        ping_alive=0
    fi
    
    /bin/kill -0 $mysqld_pid &>/dev/null && ps_alive=1
    
    if [ "$1" = "check_alive"  -a  $ping_alive = 1 ] ||
       [ "$1" = "check_dead"   -a  $ping_alive = 0  -a  $ps_alive = 0 ]; then
	return 0 # EXIT_SUCCESS
    else
  	if [ "$2" = "warn" ]; then
  	    warn_msg=
	    [ $ping_alive = 0 ] && warn_msg+="mysql ping failed"
  	    [ $ps_alive = 0 ] && \
  	        warn_msg+=" and/or mysqld with pid $mysqld_pid is not alive"
  	    echo -e "$warn_msg" | $ERR_LOGGER -p daemon.debug
	fi
  	return 1 # EXIT_FAILURE
    fi
}

log_startup_failure() {
    local msg="$@"
    if test -e $sst_progress_file;then 
        msg+=" However, State transfer is still in progress. Please check if mysqld is running."
    fi
    log_failure_msg "$msg"
}
#
# main()
#

case "${1:-''}" in
  'start')
	sanity_checks;
	# Start daemon
	log_daemon_msg "Starting MySQL (Percona XtraDB Cluster) database server" "mysqld"
	if mysqld_status check_alive nowarn; then
	   log_progress_msg "already running"
	   log_end_msg 0
	else
           if [[ -r $pid_file ]]; then
               log_warning_msg "Stale PID file found: $pid_file with $(cat $pid_file)"
           fi
           extra_args="${2:-}"
           if [[ -z "$extra_args" ]]; then
               "${PERCONA_PREFIX}"/bin/mysqld_safe > /dev/null 2>&1 &
           else
               "${PERCONA_PREFIX}"/bin/mysqld_safe $extra_args > /dev/null 2>&1 &
           fi
           safe_pid=$!
           avoid_race_condition="by checking again"

	    for i in `seq 1 $startup_timeout`; do

                if test -e $sst_progress_file && [ $startup_sleep -ne 10 ];then
                    log_daemon_msg "State transfer in progress, setting sleep higher" "mysqld"
                    startup_sleep=10
                fi
                # if server isn't running, then pid-file will never be updated
                if test -n "$safe_pid"; then
                    if kill -0 "$safe_pid" 2>/dev/null; then
                        set +e 
                        test -s $pid_file && kill -0 $(cat $pid_file) 2>/dev/null && break
                        set -e
                    else
                        # The server may have exited between the last pid-file check and now.  
                        if test -n "$avoid_race_condition"; then
                            avoid_race_condition=""
                            continue  # Check again.
                        fi

                        log_failure_msg "The server quit without updating PID file ($pid_file)."
                        log_end_msg 1
                        exit 1  # not waiting any more.
                    fi
                fi
                sleep $startup_sleep
		log_progress_msg "."
	    done
	    sleep 1
	    if mysqld_status check_alive warn; then
                log_end_msg 0
            else
                log_startup_failure "Please take a look at the syslog."
                log_end_msg 1
	    fi
	fi
	;;

  'stop'|'bootstrap-stop')
	# * As a passwordless mysqladmin (e.g. via ~/.my.cnf) must be possible
	# at least for cron, we can rely on it here, too. (although we have 
	# to specify it explicit as e.g. sudo environments points to the normal
	# users home and not /root)
	log_daemon_msg "Stopping MySQL (Percona XtraDB Cluster)" "mysqld"
	if ! mysqld_status check_dead nowarn; then
	  set +e
	  shutdown_out=`kill $mysqld_pid 2>&1`; r=$?
	  set -e
	  if [ "$r" -ne 0 ]; then
	    log_end_msg 1
	    log_daemon_msg "MySQLd already dead" "mysqld"
	  else
            server_down=
	    for i in `seq 1 $stop_timeout`; do
              sleep 1
              if mysqld_status check_dead nowarn; then server_down=1; break; fi
            done
            #Better to not kill in cases of large buffer pools
            #if test -z "$server_down"; then 
                #kill -9 $mysqld_pid 
            #fi
	  fi
        fi

        if ! mysqld_status check_dead warn; then
	  log_end_msg 1
	  log_failure_msg "Please stop MySQL (Percona XtraDB Cluster) manually and \
	      read /usr/share/doc/percona-xtradb-cluster-server-5.7/README.Debian.gz!"
	  exit -1
	else
	  log_end_msg 0
        fi
	;;

  'restart')
	set +e; $SELF stop; set -e
	$SELF start 
	;;

  'restart-bootstrap')
	set +e; $SELF stop; set -e
	$SELF bootstrap-pxc 
	;;

  'reload'|'force-reload'|'reload-bootstrap')
  	log_daemon_msg "Reloading MySQL (Percona XtraDB Cluster)" "mysqld"
        mysqld_pid=$(cat $pid_file 2>/dev/null)

        if [ ! $mysqld_pid ];then 
            log_failure_msg "MySQL PID not found, pid_file detected/guessed: $pid_file"
            log_end_msg 1
            exit 4
        fi

  	if kill -HUP $mysqld_pid 2>/dev/null;then 
  	    log_daemon_msg "Percona XtraDB Cluster reload complete" "mysqld"
	log_end_msg 0
  	else
            log_failure_msg "Percona XtraDB Cluster with PID $mysqld_pid \
                            is not running or unknown error"
            log_end_msg 1
        fi
	;;

  'status'|'status-bootstrap')
	if mysqld_status check_alive nowarn; then
	  log_action_msg "Percona XtraDB Cluster up and running"
	else
	  log_action_msg "MySQL (Percona XtraDB Cluster) is stopped. Check log"
	  exit 3
	fi
  	;;
  'bootstrap-pxc')
        startup_sleep=10
	sanity_checks;
	# Start daemon
	log_daemon_msg "Bootstrapping Percona XtraDB Cluster database server" "mysqld"
	if mysqld_status check_alive nowarn; then
	   log_progress_msg "already running"
	   log_end_msg 0
	else
	    if [[ -r $pid_file ]];then 
                log_warning_msg "Stale PID file found: $pid_file with $(cat $pid_file)"
            fi
             "${PERCONA_PREFIX}"/bin/mysqld_safe --wsrep-new-cluster > /dev/null 2>&1 &
  	    safe_pid=$!
            avoid_race_condition="by checking again"

	    for i in `seq 1 $startup_timeout`; do

                if test -e $sst_progress_file && [ $startup_sleep -ne 10 ];then
                    log_daemon_msg "State transfer in progress, setting sleep higher" "mysqld"
                    startup_sleep=10
                fi
                # if server isn't running, then pid-file will never be updated
                if test -n "$safe_pid"; then
                    if kill -0 "$safe_pid" 2>/dev/null; then
                        set +e
                        test -s $pid_file && kill -0 $(cat $pid_file) 2>/dev/null && break
                        set -e
                    else
                        # The server may have exited between the last pid-file check and now.  
                        if test -n "$avoid_race_condition"; then
                            avoid_race_condition=""
                            continue  # Check again.
                        fi

                        log_failure_msg "The server quit without updating PID file ($pid_file)."
                        log_end_msg 1
                        exit 1  # not waiting any more.
                    fi
                fi
                sleep $startup_sleep
		log_progress_msg "."
	    done
	    sleep 1
            if mysqld_status check_alive warn; then
                log_end_msg 0
            else
                log_startup_failure "Please take a look at the syslog."
                log_end_msg 1
            fi
	fi
	;;
  *)
	echo "Usage: $SELF start|stop|restart|restart-bootstrap|reload|force-reload|status|bootstrap-pxc"
	exit 1
	;;
esac