/etc/init.d/mysql is in percona-xtradb-cluster-server-5.6 5.6.21-25.8-0ubuntu3.
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 | #!/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
${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
soutput=$(mysql -u root -pabcd -e 'select 1;' 2>&1 | grep 'ERROR 2002')
[ "$soutput" ] && ping_alive=0
/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 with $soutput"
[ $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
"${PERCONA_PREFIX}"/bin/mysqld_safe > /dev/null 2>&1 &
safe_pid=$!
avoid_race_condition="by checking again"
for i in `seq 1 $startup_timeout`; do
test -s $pid_file && break
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
: # the server still runs
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
# Now start mysqlcheck or whatever the admin wants.
# only if the file /etc/mysql/DEBIAN-START is present.
if test -e /etc/mysql/DEBIAN-START;then
output=$(/etc/mysql/percona-xtradb-cluster/debian-start)
[ "$output" ] && log_action_msg "$output"
fi
else
log_startup_failure "Please take a look at the syslog."
log_end_msg 1
fi
fi
;;
'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.6/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')
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')
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
"${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
test -s $pid_file && break
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
: # the server still runs
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
# Now start mysqlcheck or whatever the admin wants.
# only if the file /etc/mysql/DEBIAN-START is present.
if test -e /etc/mysql/DEBIAN-START;then
output=$(/etc/mysql/debian-start)
[ "$output" ] && log_action_msg "$output"
fi
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
|