]> git.pld-linux.org Git - packages/percona-server.git/blame - percona-server.init
Up to 5.7.35-38.1; drop part of opt.patch - our rpmcflags etc seem to be used correctly
[packages/percona-server.git] / percona-server.init
CommitLineData
53a28f77 1#!/bin/sh
2#
7429b124 3# mysql A very fast and reliable SQL database engine
53a28f77 4#
7429b124 5# chkconfig: 2345 84 25
53a28f77 6#
350d9d8c 7# description: A very fast and reliable SQL database engine.
0b079830 8
53a28f77 9# Source function library
10. /etc/rc.d/init.d/functions
11
12# Get network config
13. /etc/sysconfig/network
14
aac2c31f 15# Get service config
26c94b7a
AM
16if [ -f /etc/sysconfig/percona-server ]; then
17 . /etc/sysconfig/percona-server
aac2c31f 18else
26c94b7a
AM
19 nls "Error: %s not found" /etc/sysconfig/percona-server
20 nls "%s can't be run." percona-server
350d9d8c
PG
21 exit 1
22fi
23
0146fae1 24if [ -n "$MYSQL_DB_CLUSTERS" ]; then
26c94b7a 25 nls "Warning: MYSQL_DB_CLUSTERS is set. It's obsolete. Use %s instead." /etc/percona-server/clusters.conf
aac2c31f
AM
26fi
27
26c94b7a
AM
28if [ -f /etc/percona-server/clusters.conf ]; then
29 MYSQL_DB_CLUSTERS=$(awk -F= '!/^#/ && /=/{print $2}' /etc/percona-server/clusters.conf)
c0beb2ff 30 if [ -z "$MYSQL_DB_CLUSTERS" ]; then
95b0575d
ER
31 nls "Warning: there are no configured clusters."
32 fi
0146fae1 33
95b0575d 34else
26c94b7a 35 nls "Warning: Missing clusters config file %s" /etc/percona-server/clusters.conf
c0beb2ff 36 if [ -z "$MYSQL_DB_CLUSTERS" ]; then
95b0575d 37 nls "Warning: there are no configured clusters."
65d14765
AM
38 nls "Using default cluster /var/lib/mysql (compatibility mode)"
39 MYSQL_DB_CLUSTERS=/var/lib/mysql
95b0575d 40 fi
aac2c31f
AM
41fi
42
95b0575d 43
ac28c610 44# Check that networking is up
8eb71226 45if is_yes "${NETWORKING}"; then
213fc2f2 46 if [ ! -f /var/lock/subsys/network -a "$1" != stop -a "$1" != status -a "$1" != init ]; then
26c94b7a 47 msg_network_down percona-server
8eb71226 48 exit 1
49 fi
50else
51 exit 0
e9ca44ab 52fi
53
bf9eb59e
ER
54sharedir=/usr/share/percona-server
55
aac2c31f
AM
56action="$1"
57
58# any db cluster as command line argument?
521444a9 59if [ $# -gt 1 ]; then
350d9d8c
PG
60 shift
61 # perform action for specified clusters only
30b2aa9a 62 for a in "$@"; do
26c94b7a 63 # try auto resolving from /etc/percona-server/clusters.conf
30b2aa9a 64 if [[ "$a" != /* ]]; then
26c94b7a 65 m=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $1}' /etc/percona-server/clusters.conf)
30b2aa9a
ER
66 if [ -z "$m" ]; then
67 echo >&2 "Cluster name '$a' did not match anything!"
68 exit 1
69 fi
70 if [ $(echo "$m" | wc -l) -gt 1 ]; then
71 echo >&2 "Cluster name '$a' ambiguous:" $m
72 exit 1
73 fi
26c94b7a 74 a=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $2}' /etc/percona-server/clusters.conf)
30b2aa9a
ER
75 fi
76 DB_CLUSTERS="$DB_CLUSTERS $a"
77 done
aac2c31f 78else
350d9d8c 79 DB_CLUSTERS="$MYSQL_DB_CLUSTERS"
53a28f77 80fi
81
7c1478d5 82# global error log, if mysqld.conf hasn't migrated to log-error style
0beb0def 83MYSQL_ERRLOG=/var/log/percona-server/mysqld.log
c85758f0 84MYSQL_STOP_WAIT_TIME=${MYSQL_STOP_WAIT_TIME:-900}
aac2c31f
AM
85
86#
87# Useful functions.
88#
89
90#
26c94b7a 91# check for percona-server status
aac2c31f
AM
92#
93# arguments:
94# $1 - db cluster
c85758f0 95# $2 - start|stop
aac2c31f
AM
96#
97# sets variables:
c85758f0 98# MYSQL_STATUS = starting | running | not running | died
26c94b7a 99# MYSQL_PID = pid of percona-server process
aac2c31f
AM
100#
101mysqlstatus() {
102 clusterdir="$1"
c85758f0
AM
103 mode="$2"
104
096a9b6f 105 mysqlgetconfig "$clusterdir" status
d405c4eb 106
350d9d8c
PG
107 MYSQL_STATUS="not running"
108 MYSQL_PID="unknown"
c85758f0
AM
109 MYSQL_PIDFILE_PID=""
110 MYSQL_GREP_PID=""
aac2c31f 111
c85758f0
AM
112 if [ -f "$MYSQL_PIDFILE" ]; then
113 MYSQL_PIDFILE_PID=$(cat "$MYSQL_PIDFILE")
114 fi
115
116 if [ -n "$MYSQL_PIDFILE_PID" ]; then
117 MYSQL_PID=$MYSQL_PIDFILE_PID
118 if [ ! -d "/proc/$MYSQL_PID" ]; then
119 MYSQL_STATUS="died"
120 return
376ffa12 121 elif (grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null); then
c85758f0
AM
122 MYSQL_STATUS="running"
123 return
124 fi
125 fi
6d3c5db5 126
c85758f0 127 if [ "$mode" = "start" ]; then
0beb0def 128 MYSQL_GREP_PID=$(grep -alE "^/usr/sbin/mysqld.*${MYSQL_PIDFILE}" /proc/[0-9]*/cmdline 2> /dev/null | awk -F "/" '{ print $3; exit; }')
c85758f0
AM
129 if [ -n "$MYSQL_GREP_PID" ]; then
130 MYSQL_PID=$MYSQL_GREP_PID
0ca65658 131 if grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null; then
c85758f0
AM
132 if [ -f "$MYSQL_PIDFILE" ]; then
133 MYSQL_PIDFILE_PID=$(cat "$MYSQL_PIDFILE")
134 fi
135 if [ -n "$MYSQL_PIDFILE_PID" ]; then
136 MYSQL_PID=$MYSQL_PIDFILE_PID
137 MYSQL_STATUS="running"
138 return
139 else
140 MYSQL_STATUS="starting"
141 return
142 fi
143 fi
144 fi
6d3c5db5 145 fi
c85758f0
AM
146
147 # else default, "not running"
aac2c31f
AM
148}
149
150# get mysql configuration in variables
5e3157a9 151# MYSQL_CONFIG MYSQL_CLUSTER_DIR
e6d4b62c 152# MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE MYSQL_SOCKET MYSQL_PORT MYSQL_BIND_ADDRESS MYSQL_SKIP_NETWORKING MYSQL_LOG_ERROR
aac2c31f
AM
153#
154# arguments
155# $1 - db cluster
096a9b6f 156# $2 - status | other
aac2c31f
AM
157
158mysqlgetconfig() {
5e3157a9 159 local clusterdir="$1" config_file
096a9b6f 160 local mode="$2"
aac2c31f
AM
161
162 # emulate old behaviour if only one cluster specified
65d14765 163 if [ "$clusterdir" = "$MYSQL_DB_CLUSTERS" -a "$clusterdir" = "/var/lib/mysql" -a -f /etc/mysqld.conf ]; then
0ca65658 164 MYSQL_RA_COMPAT=yes
0beb0def 165 config_file=/etc/mysqld.conf
521444a9 166 else
26c94b7a 167 local config=$(awk -F= -vclusterdir="$clusterdir" '!/^#/{ if (clusterdir == $2) print $1}' /etc/percona-server/clusters.conf)
0ca65658 168 if [[ $config = /* ]]; then
d54e166d 169 config_file="$config"
26c94b7a
AM
170 elif [ -f "/etc/percona-server/$config" ]; then
171 config_file="/etc/percona-server/$config"
d54e166d 172 else
0beb0def 173 config_file="$clusterdir/mysqld.conf"
d54e166d 174 fi
350d9d8c 175 fi
aac2c31f 176
0ca65658 177 MYSQL_CLUSTER_DIR="$clusterdir"
d405c4eb 178
521444a9 179 if [ -z "$config_file" ]; then
f9ad67df 180 nls "Error: Can't find config file for %s cluster" "$clusterdir"
096a9b6f
MM
181 if [ "$mode" = "status" ]; then
182 exit 3
183 else
184 exit 6
185 fi
f9ad67df 186 else
0ca65658 187 MYSQL_CONFIG="$config_file"
f9ad67df 188 fi
d405c4eb 189
aac2c31f
AM
190 if [ ! -f "$config_file" ]; then
191 nls "Error: config file %s not found" "$config_file"
26c94b7a 192 nls "percona-server can't be run. Did you initialize DB by doing \`$0 init'?"
096a9b6f
MM
193 if [ "$mode" = "status" ]; then
194 exit 3
195 else
196 exit 6
197 fi
aac2c31f
AM
198 fi
199
b3be1198 200 # reset to initial state
e6d4b62c 201 MYSQL_DATA_DIR= MYSQL_USER= MYSQL_PIDFILE= MYSQL_SOCKET= MYSQL_PORT= MYSQL_BIND_ADDRESS= MYSQL_SKIP_NETWORKING= MYSQL_LOG_ERROR=
b3be1198
ER
202
203 eval `awk -F= '
ca39347b
ER
204 {
205 # undos
206 gsub(/\r$/, "");
207
208 # trim spaces
3dc69a76
ER
209 gsub(/^[\t ]+|[\t ]+$/, "", $1);
210 gsub(/^[\t ]+|[\t ]+$/, "", $2);
ca39347b
ER
211 }
212
b3be1198
ER
213 # skip comments and empty lines
214 /^[;#]|^ *$/ { next }
215
216 /^[ \t]*\[.*\][ \t]*$/ {
217 match($0, /\[.*\]/);
218 section = substr($0, RSTART + 1, RSTART + RLENGTH - 3);
219 next;
823c13f7 220 }
e9ca44ab 221
b3be1198 222 section == "mysqld" {
3dc69a76 223 if ($1 == "datadir") {
b3be1198 224 printf("MYSQL_DATA_DIR=%s;", $2);
3dc69a76 225 } else if ($1 == "user") {
b3be1198 226 printf("MYSQL_USER=%s;", $2);
3dc69a76 227 } else if ($1 == "pid-file") {
b3be1198 228 printf("MYSQL_PIDFILE=%s;", $2);
3dc69a76 229 } else if ($1 == "socket") {
b3be1198 230 printf("MYSQL_SOCKET=%s;", $2);
3dc69a76 231 } else if ($1 == "port") {
b3be1198 232 printf("MYSQL_PORT=%s;", $2);
3dc69a76 233 } else if ($1 == "bind-address") {
b3be1198 234 printf("MYSQL_BIND_ADDRESS=%s;", $2);
3dc69a76 235 } else if ($1 == "skip-networking") {
9e39a858 236 printf("MYSQL_SKIP_NETWORKING=1;");
3dc69a76 237 } else if ($1 == "log-error") {
e6d4b62c 238 printf("MYSQL_LOG_ERROR=%s;", $2);
b3be1198
ER
239 }
240 }
241 ' $config_file`
e9ca44ab 242
e6d4b62c
ER
243 # error log not defined in config file. add one
244 if [ -z "$MYSQL_LOG_ERROR" ]; then
245 MYSQL_LOG_ERROR=$MYSQL_ERRLOG
246 else
247 # unset, so mysqld would use value from config itself
248 unset MYSQL_LOG_ERROR
249 fi
250
d54e166d 251 if is_yes "$MYSQL_RA_COMPAT"; then
350d9d8c 252 MYSQL_DATA_DIR_SUB=""
8ee1d59c 253 else
0beb0def 254 MYSQL_DATA_DIR_SUB="/mysqldb"
8ee1d59c 255 fi
d405c4eb 256
8ee1d59c 257 if [ -z "$MYSQL_DATA_DIR" -o "$MYSQL_DATA_DIR" != "${clusterdir}${MYSQL_DATA_DIR_SUB}/db" ]; then
350d9d8c 258 nls "Error: datadir specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/db"
26c94b7a 259 nls " percona-server can't be run."
350d9d8c 260 exit 6
8ee1d59c 261 fi
d405c4eb 262
0beb0def
AM
263 if [ -z "$MYSQL_PIDFILE" -o "$MYSQL_PIDFILE" != "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid" ]; then
264 nls "Error: pid-file specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid"
26c94b7a 265 nls " percona-server can't be run."
8ee1d59c
AM
266 exit 6
267 fi
e9ca44ab 268
e6d4b62c 269 if [ -z "$MYSQL_USER" ]; then
26c94b7a 270 echo "$(nls 'percona-server user not configured properly')"'!' >&2
350d9d8c
PG
271 nls "Edit %s and configure it." "$config_file" >&2
272 exit 6
860cd80c 273 fi
aac2c31f 274}
e9ca44ab 275
aac2c31f
AM
276# start mysql
277mysqlstart() {
5e3157a9 278 local clusterdir="$1"
aac2c31f 279 mysqlgetconfig "$clusterdir"
0beb0def 280 if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
26c94b7a 281 nls "percona-server cluster %s not initialized." "$clusterdir"
aac2c31f 282 nls "Try \`%s init %s' before start." "$0" "$clusterdir"
350d9d8c
PG
283 exit 6
284 fi
02e96f2e 285
26c94b7a 286 msg_starting "percona-server $clusterdir"; busy
aac2c31f 287 [ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
c85758f0 288 rm -f "$MYSQL_PIDFILE"
c4fbabf1 289
7c1478d5 290
c4fbabf1 291 TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} \
0beb0def 292 /usr/bin/setsid /usr/sbin/mysqld \
c4fbabf1
ER
293 --defaults-file=$MYSQL_CONFIG \
294 --datadir=$MYSQL_DATA_DIR \
7c1478d5 295 --pid-file=$MYSQL_PIDFILE \
e6d4b62c 296 ${MYSQL_LOG_ERROR:+--log-error="$MYSQL_LOG_ERROR"} \
7c1478d5 297 $MYSQL_OPTIONS &
c4fbabf1
ER
298 pid=$!
299
300 sleep 0.1
c85758f0
AM
301 mysqlstatus "$clusterdir" start
302 # it takes longer for mysqld to start and create pidfile if it has to recover innodb transactions
303 if [ "$MYSQL_STATUS" = "starting" ]; then
c4fbabf1 304 echo ""
26c94b7a 305 show "Waiting for percona-server to start"
c4fbabf1
ER
306 busy
307
308 # while the pid is running, mysql is starting up
309 # if the pidfile was created, it started up successfully
310 # if either case fails we break and report status
311 while true; do
312 [ -d /proc/$pid ] || break
c85758f0 313 [ -f "$MYSQL_PIDFILE" ] && break
c4fbabf1 314 sleep 0.2
c85758f0
AM
315 done
316 fi
317
318 mysqlstatus "$clusterdir" start
6d3c5db5 319 if [ "$MYSQL_STATUS" = "running" -a "$MYSQL_PID" != "unknown" ]; then
aac2c31f 320 ok
47fd5a6a 321 elif [ "$MYSQL_STATUS" = "died" ]; then
350d9d8c 322 RETVAL=1
47fd5a6a 323 died
aac2c31f
AM
324 else
325 RETVAL=1
326 fail
53a28f77 327 fi
aac2c31f
AM
328}
329
330# stop mysql
331mysqlstop() {
5e3157a9 332 local clusterdir="$1"
c85758f0 333 mysqlstatus "$clusterdir" stop
26c94b7a 334 msg_stopping "percona-server $clusterdir"
aac2c31f 335 busy
95b0575d 336
95b0575d 337 # try graceful shutdown -- send shutdown command
566e62bb 338 # requires mysql_sysadmin user proper privs
29826a6a 339 /usr/bin/mysqladmin --defaults-file=$MYSQL_CONFIG ${MYSQL_SOCKET:+--socket=$MYSQL_SOCKET} shutdown >/dev/null 2>&1
c85758f0 340 mysqlstatus "$clusterdir" stop
95b0575d 341
c85758f0
AM
342 if [ "$MYSQL_PID" != "unknown" ]; then
343 kill -TERM "$MYSQL_PID" 2> /dev/null
344 for nr in $(seq 1 $(($MYSQL_STOP_WAIT_TIME*10))); do
345 [ -d "/proc/$MYSQL_PID" ] || break
346 sleep 0.1
347 done
348 fi
349
350 mysqlstatus "$clusterdir" stop
47fd5a6a 351 if [ "$MYSQL_STATUS" = "died" ]; then
350d9d8c 352 died
c85758f0 353 elif [ "$MYSQL_STATUS" = "running" -o "$MYSQL_STATUS" = "starting" ]; then
aac2c31f 354 fail
b92e5cd1 355 else
aac2c31f 356 ok
b92e5cd1 357 fi
aac2c31f
AM
358}
359
70cdc654
ER
360# report slave status
361# uses MYSQL_SOCKET - path to mysql socket
362slave_status() {
29826a6a 363 if [ ! -x /usr/bin/mysql ]; then
13e5a8de
ER
364 echo >&2 "Slave status not available: 'mysql' program not installed."
365 return
366 fi
367
70cdc654 368 # see if slave status can be reported
ed3eec1b 369 local err=0 slave_status=$(mysql --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" -e 'show slave status\G')
70cdc654
ER
370 if [ -z "$slave_status" ]; then
371 # slave not setup
372 return
373 fi
374
288d6415 375 printf "Slave Status:\n"
70cdc654 376
7c5ef922 377 set -f
70cdc654
ER
378 eval $(echo "$slave_status" | awk -F': ' '/^ *[A-Za-z_]+:/{
379 k = tolower($1);
380 v = substr($0, length($1) + 3);
381 gsub(/\\/, "\\\\\\", v);
382 gsub(/"/, "\\\"", v);
383 gsub(/`/, "\\`", v);
384 gsub(/\$/, "\\$", v);
7c5ef922 385 gsub(/\$/, "\\$", v);
70cdc654
ER
386 printf("%s=\"%s\";\n", k, v);
387 }')
7c5ef922 388 set +f
70cdc654
ER
389
390 if [ "$slave_io_running" != "Yes" ]; then
391 printf "\tSlave IO not running\n"
392 err=1
393 fi
394 if [ "$slave_sql_running" != "Yes" ]; then
395 printf "\tSlave SQL not running\n"
396 err=1
397 fi
398
399 if [ "$err" = 1 -a "$last_errno" -gt 0 ]; then
7c5ef922 400 printf "\tERROR %s: %s\n" "$last_errno" "$last_error"
70cdc654
ER
401 fi
402
403 if [ "$master_log_file" != "$relay_master_log_file" ]; then
7c5ef922 404 printf "\tERROR logfile mismatch (%s)\n" "$relay_master_log_file"
70cdc654
ER
405 err=1
406 fi
407
408 if [ -z "$read_master_log_pos" -o -z "$exec_master_log_pos" ]; then
409 printf "\tERROR No info about master\n"
410 err=1
411 return
412 fi
413
414 diff=$(($read_master_log_pos - $exec_master_log_pos))
7c5ef922
ER
415 printf "\tread pos: %s (%s) (host: %s:%d)\n" "$read_master_log_pos" "$master_log_file" "$master_host" "$master_port"
416 printf "\texec pos: %s\n" "$exec_master_log_pos"
417 printf "\tdiff: %s\n" "$diff"
70cdc654
ER
418}
419
aac2c31f
AM
420#
421# check for running mysql instances; if any instance is running then
422# create subsys lock file
423#
424mysqlsubsys() {
350d9d8c
PG
425 # check for every defined db cluster in sysconfig file
426 for mysqldir in $DB_CLUSTERS; do
427 mysqlstatus "$mysqldir"
428 if [ "$MYSQL_STATUS" = "running" ]; then
26c94b7a 429 touch /var/lock/subsys/percona-server
350d9d8c
PG
430 return
431 fi
432 done
26c94b7a 433 rm -f /var/lock/subsys/percona-server
aac2c31f
AM
434}
435
436mysqlinit() {
5e3157a9 437 local clusterdir="$1"
8ee1d59c 438
0beb0def 439 if [ -f /etc/mysqld.conf ]; then
350d9d8c 440 nls "Running in \`no cluster compat' mode: can't initialize database."
0beb0def 441 nls "Move /etc/mysqld.conf away and rerun \`$0 init' (new config will be in $clusterdir)."
350d9d8c 442 exit 1
8ee1d59c
AM
443 fi
444
0beb0def 445 if [ -f "$clusterdir/mysqld.conf" ]; then
521444a9
AM
446 mysqlgetconfig "$clusterdir"
447 else
448 MYSQL_USER="mysql"
449 MYSQL_CLUSTER_DIR="$clusterdir"
0beb0def
AM
450 MYSQL_DATA_DIR="$clusterdir/mysqldb/db"
451 MYSQL_PIDFILE="$clusterdir/mysqldb/mysql.pid"
452 MYSQL_SOCKET="$clusterdir/mysqldb/mysql.sock"
fe98cc4a
ER
453
454 # this $MYSQL_CONFIG will be created later
0beb0def 455 MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf"
521444a9 456 fi
aac2c31f 457
258cacc2 458 show "Initializing percona-server cluster %s" "$clusterdir"; started
aac2c31f 459
573e1dcc 460 # Check if not exist init database
26c94b7a
AM
461 if [ -d "$MYSQL_DATA_DIR/percona-server" ]; then
462 nls "Seems that database is initialized now. Remove by hand %s" "$MYSQL_DATA_DIR/percona-server"
b92e5cd1 463 nls "before initializing database."
aac2c31f 464 nls "For now skipping cluster %s." "$clusterdir"
df1ac9e1 465 exit 6
e9ca44ab 466 fi
467
26c94b7a 468 show "Installing percona-server system tables for $MYSQL_DATA_DIR"
e9ca44ab 469 busy
d405c4eb
JB
470 TMP=/tmp TMPDIR=/tmp
471
c4fbabf1 472 mkdir -p "$MYSQL_DATA_DIR" > /dev/null 2>&1
f5d63301
AM
473 # Using mysql:mysql for MYSQL_CLUSTER_DIR is creating SECURITY hole, root:root is proper
474 chown root:root "$MYSQL_CLUSTER_DIR"
0beb0def
AM
475 chown mysql:mysql "$MYSQL_CLUSTER_DIR/mysqldb" "$MYSQL_DATA_DIR" > /dev/null 2>&1
476 chmod 751 "$MYSQL_CLUSTER_DIR" "$MYSQL_CLUSTER_DIR/mysqldb"
444f9f3c 477
0beb0def 478 if [ -f $sharedir/mysqld.conf -a ! -f "$MYSQL_CLUSTER_DIR/mysqld.conf" ]; then
c0beb2ff
ER
479 sed -e "
480 s#\(datadir.*\)=.*#\1= $MYSQL_DATA_DIR#g;
481 s#\(pid-file.*\)=.*#\1= $MYSQL_PIDFILE#g;
482 s#\(socket.*\)=.*#\1= $MYSQL_SOCKET#g;
483 s#@clusterdir@#$MYSQL_CLUSTER_DIR#g;
0beb0def
AM
484 " $sharedir/mysqld.conf > "$MYSQL_CLUSTER_DIR/mysqld.conf"
485 chown root:root "$MYSQL_CLUSTER_DIR/mysqld.conf"
486 chmod 640 "$MYSQL_CLUSTER_DIR/mysqld.conf"
444f9f3c 487 fi
cc4d3f78 488
b9c4f95d 489 ok=0
0beb0def
AM
490 /usr/sbin/mysqld \
491 --defaults-file=$MYSQL_CLUSTER_DIR/mysqld.conf \
29826a6a 492 --initialize-insecure \
0beb0def 493 --user=mysql \
5ab9fb7b
JR
494 --skip-grant-tables \
495 --datadir=$MYSQL_DATA_DIR \
496 --user=$MYSQL_USER \
497 --slave-load-tmpdir=$MYSQL_DATA_DIR \
498 --tmpdir=$MYSQL_DATA_DIR \
0beb0def
AM
499 --log-error=$MYSQL_ERRLOG && ok=1
500 [ -f $MYSQL_DATA_DIR/mysql/user.frm ] || ok=0
c4fbabf1 501
b9c4f95d 502 if [ "$ok" = 1 ]; then
5f961775
JR
503 ok
504 cat << END_OF_MSG
6a46c354 505
26c94b7a 506PLEASE REMEMBER TO SET A PASSWORD FOR THE percona-server USERS!
29826a6a 507This is done, after starting database, in the order shown below,
5f961775
JR
508with:
509
29826a6a
AM
510Add 'mysql_sysadmin' user (RELOAD and SHUTDOWN privileges):
511echo "CREATE USER 'mysql_sysadmin'@'localhost' IDENTIFIED BY 'SOME_RANDOM_PASSWORD'; FLUSH PRIVILEGES;" | mysql --ssl-mode=DISABLED -u root -S $MYSQL_SOCKET
512echo "GRANT RELOAD, SHUTDOWN ON *.* TO 'mysql_sysadmin'@'localhost'; FLUSH PRIVILEGES;" | mysql --ssl-mode=DISABLED -u root -S $MYSQL_SOCKET
6a46c354 513
29826a6a
AM
514Set password for root user (ALL privileges, DB admin):
515echo "ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword'; FLUSH PRIVILEGES;" | mysql --ssl-mode=DISABLED -u root -S $MYSQL_SOCKET
6a46c354 516
566e62bb 517NOTE: mysql_sysadmin password should be placed to $MYSQL_CONFIG in
6a46c354 518mysqladmin section. See the manual for more instructions.
566e62bb 519(This user is used at logs rotation and server shutdown)
e9ca44ab 520
5f961775 521END_OF_MSG
5f961775
JR
522 else
523 fail
524 cat << END_OF_MSG
4ff46415
AM
525ERROR:
526ERROR:
0beb0def 527ERROR: Initialization of server FAILED!
4ff46415
AM
528ERROR:
529ERROR:
e9ca44ab 530
26c94b7a 531Examine the logs in /var/log/percona-server for more information. You can
b9c4f95d 532also try to start the mysqld daemon with:
e9ca44ab 533
534/usr/sbin/mysqld --skip-grant &
535
dc7a177f 536You can use the command line tool mysql to connect to the mysql
e9ca44ab 537database and look at the grant tables:
538
29826a6a 539shell> mysql -u root mysql
e9ca44ab 540mysql> show tables
541
542Try 'mysqld --help' if you have problems with paths. Setting on
0beb0def 543logging in $MYSQL_DATA_DIR/mysqld.conf gives you a log in /var/log/percona-server/query.log that
26c94b7a
AM
544may be helpful. The latest information about percona-server is available on the
545web at https://www.percona.com/software/mysql-database/percona-server.
e9ca44ab 546
a3eb9e7b 547Please check PLD Linux ftp site for newer versions of this package.
e9ca44ab 548
26c94b7a 549Please consult the percona-server manual section: 'Problems running
e9ca44ab 550mysql_install_db', and the manual section that describes problems on
26c94b7a 551your OS. Another information source is the percona-server email archive.
e9ca44ab 552
553END_OF_MSG
5f961775 554 exit 1
aac2c31f 555 fi
80fc3cc1
ER
556
557 # if it's first server, register as default
0beb0def
AM
558 if [ ! -e /var/lib/mysql/mysql.sock ] || [ -L /var/lib/mysql/mysql.sock ] && [ -z "$(readlink /var/lib/mysql/mysql.sock)" ]; then
559 sock=${MYSQL_SOCKET#/var/lib/mysql/} # make it relative if possible
560 ln -s "$sock" /var/lib/mysql/mysql.sock
80fc3cc1 561 fi
722bcca2 562 # same for config, move to /etc
0beb0def
AM
563 if [ ! -e /etc/percona-server/mysqld.conf ]; then
564 mv "$MYSQL_CLUSTER_DIR/mysqld.conf" /etc/percona-server/mysqld.conf
722bcca2 565 fi
aac2c31f
AM
566}
567
568#
569# End of useful functions.
570#
571
323256af 572start() {
5e3157a9 573 local mysqldir
aac2c31f 574 for mysqldir in $DB_CLUSTERS; do
c85758f0 575 mysqlstatus "$mysqldir" start
aac2c31f 576 if [ "$MYSQL_STATUS" = "running" ]; then
26c94b7a 577 msg_already_running "percona-server $mysqldir"
aac2c31f
AM
578 else
579 mysqlstart "$mysqldir"
580 fi
581 done
582 mysqlsubsys
323256af
ER
583}
584
585stop() {
5e3157a9 586 local mysqldir
aac2c31f 587 for mysqldir in $DB_CLUSTERS; do
c85758f0 588 mysqlstatus "$mysqldir" stop
aac2c31f 589 if [ "$MYSQL_STATUS" = "not running" ]; then
26c94b7a 590 msg_not_running "percona-server $mysqldir"
aac2c31f
AM
591 else
592 mysqlstop "$mysqldir"
593 fi
594 done
595 mysqlsubsys
323256af
ER
596}
597
7429b124 598condrestart() {
26c94b7a
AM
599 if [ ! -f /var/lock/subsys/percona-server ]; then
600 msg_not_running "percona-server"
7429b124 601 RETVAL=$1
5e3157a9 602 return
7429b124 603 fi
5e3157a9
ER
604
605 stop
606 start
7429b124
JB
607}
608
0d6ce890 609status() {
8b768513 610 local mysqldir addr port socket pid pids running datadir
0e94191b 611 RETVAL=3
aac2c31f
AM
612 for mysqldir in $DB_CLUSTERS; do
613 mysqlstatus "$mysqldir"
2bac5c2d 614 if [ "$MYSQL_STATUS" = "running" ]; then
0e94191b 615 RETVAL=0
b3be1198
ER
616 addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
617 port=${MYSQL_PORT:-3306}
0beb0def 618 socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock}
b3be1198 619 pid=$MYSQL_PID
26c94b7a 620 nls "percona-server cluster %s, pid %s\n" "$mysqldir" "$pid"
9e39a858 621 [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port"
bb821a4c 622 nls "\tunix: %s\n" "$socket"
70cdc654
ER
623
624 MYSQL_SOCKET=$socket slave_status
625
b2bb6a82 626 pids="$pids/$MYSQL_PID/"
2bac5c2d
ER
627 progress "$MYSQL_STATUS"
628 else
26c94b7a 629 show "percona-server cluster %s" "$mysqldir"
2bac5c2d
ER
630 progress "$MYSQL_STATUS" "$CFAIL"
631 fi
632 echo
aac2c31f 633 done
b2bb6a82
ER
634
635 for pid in $(/sbin/pidof mysqld); do
636 if [[ $pids != */$pid/* ]]; then
637 running="$running $pid"
638 fi
639 done
b7d0a657 640
a5595931 641 if [ $# = 1 -a "$running" ]; then
26c94b7a 642 nls "Warning: percona-server Daemon processes not under clusters.conf control:"
b2bb6a82
ER
643 # see if we can display their status
644 for pid in $running; do
b7d0a657 645 datadir=$(cat /proc/$pid/cmdline | tr '\0' '\n' | fgrep -- --datadir=)
b2bb6a82 646 datadir=${datadir#--datadir=} # strip --datadir
0beb0def 647 mysqldir=${datadir%/mysqldb/db} # strip /mysqldb/db
b2bb6a82
ER
648 mysqlstatus "$mysqldir"
649 if [ "$MYSQL_STATUS" = "running" ]; then
b3be1198
ER
650 addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
651 port=${MYSQL_PORT:-3306}
0beb0def 652 socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock}
26c94b7a 653 nls "percona-server cluster %s, pid %s\n" "$mysqldir" "$pid"
9e39a858 654 [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port"
bb821a4c 655 nls "\tunix: %s\n" "$socket"
70cdc654
ER
656
657 MYSQL_SOCKET=$socket slave_status
658
b2bb6a82
ER
659 progress "$MYSQL_STATUS"
660 else
26c94b7a 661 show "percona-server cluster %s" "$mysqldir"
b2bb6a82
ER
662 progress "$MYSQL_STATUS" "$CFAIL"
663 fi
664 echo
665 done
666 fi
0d6ce890
ER
667}
668
669RETVAL=0
670case "$action" in
671 start)
672 start
673 ;;
674 stop)
675 stop
676 ;;
677 restart)
678 stop
679 start
680 ;;
681 try-restart)
682 condrestart 0
683 ;;
684 force-reload)
685 condrestart 7
686 ;;
687 init)
688 for mysqldir in $DB_CLUSTERS; do
689 mysqlinit "$mysqldir"
690 done
691 exit $?
692 ;;
693 flush-logs)
694 for mysqldir in $DB_CLUSTERS; do
c0beb2ff 695 mysqlgetconfig "$mysqldir"
0d6ce890
ER
696 # just if mysqld is really running
697 if /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" ping >/dev/null 2>&1; then
698 /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" flush-logs
699 fi
700 done
701 ;;
702 status)
703 status
aac2c31f 704 ;;
53a28f77 705 *)
33cdd78d 706 msg_usage "$0 {start|stop|restart|try-restart|force-reload|init|flush-logs|status}"
02e96f2e 707 exit 3
53a28f77 708esac
40c36bca 709
ee9b6a50 710exit $RETVAL
This page took 0.238798 seconds and 4 git commands to generate.