-
-
Notifications
You must be signed in to change notification settings - Fork 159
/
mariadb_upgrade101.inc
676 lines (566 loc) · 20.9 KB
/
mariadb_upgrade101.inc
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
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
backupmsg101() {
echo ""
cat <<EOF
-------------------------------------------------------------------------------
This script's MariaDB 10.1.x upgrade process is still in beta testing stages.
So please test on a test server and not a live production server. But if you use
on live server or if MySQL databases already exist, please back them up before
running this upgrade script via mysqldump - instructions at:
http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html.
###################################################################
### IMPORTANT MYSQLDUMP BACKUP BEFORE UPGRADE ###
### OR RISK DATA LOSS DUE TO MARIADB 10.1 Changes ###
###################################################################
For each DATABASENAME backup via mysqldump i.e.
mysqldump --opt --routines DATABASENAME > /path/to/DATABASENAME_backup.sql
EOF
sleep 5
echo "------------------------------------------------------------------------"
echo ""
read -ep "Have you backed up your databases ? [y/n] " askbackup
if [[ "$askbackup" == [nN] ]]; then
echo ""
cecho "Aborting MariaDB 10.1.x upgrade..." $boldyellow
exit
fi
echo ""
echo "MariaDB 10.1.x https://mariadb.com/kb/en/mariadb/what-is-mariadb-101/"
echo
echo "!! Note !!"
echo "upgrade process can take more >5 minutes.. you may want to shutdown"
echo "nginx server to not show mysql errors to visitors on your site or"
echo "put site(s) into maintenance mode before proceeding with mysql upgrade"
sleep 15
echo
read -ep "Do you want to continue with upgrade to MariaDB 10.1.x ? [y/n] " contbackup
if [[ "$contbackup" == [nN] ]]; then
echo ""
cecho "Aborting MariaDB 10.1.x upgrade..." $boldyellow
exit
fi
# if you set /etc/centminmod/custom_config.inc file to
# MARIADB_UPDATEMAINTENANCE=y
# then whenever you run mariadb upgrade, you put all sites
# on server into 503 maintenance mode first and once
# updated, disable 503 maintenance mod after
if [[ "$MARIADB_UPDATEMAINTENANCE" = [yY] ]]; then
if [ -f /usr/bin/sitestatus ]; then
/usr/bin/sitestatus off
fi
fi
echo
echo "checking mysql root password works in /root/.my.cnf"
sleep 5
echo "mysqladmin ver"
mysqladmin ver
CHECK_MYSQLPASS=$?
if [[ "$CHECK_MYSQLPASS" != '0' ]]; then
echo
echo "mysql root user password in /root/.my.cnf is not correct"
if [ ! -f /root/.my.cnf ]; then
echo "or"
echo "/root/.my.cnf file doesn't exist"
fi
cecho "Aborting MariaDB 10.1.x upgrade..." $boldyellow
exit
fi
if [ -f "$(which figlet)" ]; then
figlet -ckf standard "Preparing Shutdown For Upgrade"
fi
# full purge and change buffer merge before shutting down to ensure data files are in sync
# prior to upgrade
echo
mysql -e "set global innodb_fast_shutdown=0;"
echo "continuing upgrade in ~300 seconds..."
echo "..."
sleep 20
echo "..... continue in 300s"
sleep 20
echo "....... continue in 280s"
sleep 20
echo "......... continue in 260s"
sleep 20
echo "........... continue in 240s"
sleep 20
echo "............. continue in 220s"
sleep 20
echo "............... continue in 200s"
sleep 20
echo "................. continue in 180s"
sleep 20
echo ".................. continue in 160s"
sleep 20
echo ".................... continue in 140s"
sleep 20
echo "...................... continue in 120s"
sleep 20
echo "........................ continue in 80s"
sleep 20
echo ".......................... continue in 60s"
sleep 20
echo "............................ continue in 40s"
sleep 20
echo ".............................. continue in 20s"
sleep 20
}
mysqlinitfix() {
if [[ -z "$(grep 'user_beancounters' /etc/init.d/mysql)" ]]; then
sed -i 's/#!\/bin\/sh/#!\/bin\/sh\nif [ -f \/proc\/user_beancounters ]; then\nulimit -s 512\nfi\n/g' /etc/init.d/mysql
fi
}
mariadb101uninstall() {
OLDMARIADBVERS=`rpm -qa | grep MariaDB`
echo "#####################################################"
# List current existing MariaDB versions for RPMs
echo "Current MariaDB versions installed:"
for mrpm in $OLDMARIADBVERS
do
echo $mrpm
done
echo "#####################################################"
echo "Proceeding to remove existing MariaDB versions:"
echo "please wait while processing...."
OLDMARIADBSHARED=`rpm -qa | grep MariaDB | awk '/MariaDB-shared/'`
OLDMARIADBCLIENT=`rpm -qa | grep MariaDB | awk '/MariaDB-client/'`
OLDMARIADBDEVEL=`rpm -qa | grep MariaDB | awk '/MariaDB-devel/'`
OLDMARIADBSERVER=`rpm -qa | grep MariaDB | awk '/MariaDB-server/'`
OLDMARIADBTEST=`rpm -qa | grep MariaDB | awk '/MariaDB-test/'`
OLDMARIADBCOMMON=`rpm -qa | grep MariaDB | awk '/MariaDB-common/'`
OLDMARIADBCOMPAT=`rpm -qa | grep MariaDB | awk '/MariaDB-compat/'`
yum -q -y remove perl-DBD-MySQL
echo "rpm -e $OLDMARIADBTEST"
echo "rpm -e $OLDMARIADBSERVER"
echo "rpm -e $OLDMARIADBCLIENT"
echo "rpm -e $OLDMARIADBDEVEL"
echo "rpm -e --nodeps $OLDMARIADBSHARED"
echo "rpm -e --nodeps $OLDMARIADBCOMPAT"
echo "rpm -e --nodeps $OLDMARIADBCOMMON"
rpm -e $OLDMARIADBTEST
rpm -e $OLDMARIADBSERVER
rpm -e $OLDMARIADBCLIENT
rpm -e $OLDMARIADBDEVEL
rpm -e --nodeps $OLDMARIADBSHARED
rpm -e --nodeps $OLDMARIADBCOMPAT
rpm -e --nodeps $OLDMARIADBCOMMON
yum clean all
if [ -z "$OLDMARIADBVERS" ]; then
echo "MariaDB old versions successfully removed..."
fi
echo "#####################################################"
}
mariadb101install() {
if [ -f "$(which figlet)" ]; then
figlet -ckf standard "MariaDB 10.1.x Repo Setup"
fi
echo "*************************************************"
cecho "MariaDB 10.1.x Repo setup..." $boldgreen
echo "*************************************************"
echo ""
yum clean all
CENTOSVER=`cat /etc/redhat-release | awk '{ print $3 }'`
if [ "$CENTOSVER" == 'release' ]; then
CENTOSVER=$(awk '{ print $4 }' /etc/redhat-release | cut -d . -f1,2)
if [[ "$(cat /etc/redhat-release | awk '{ print $4 }' | cut -d . -f1)" = '7' ]]; then
CENTOS_SEVEN='7'
fi
fi
if [ "$CENTOSVER" == 'Enterprise' ]; then
CENTOSVER=`cat /etc/redhat-release | awk '{ print $7 }'`
fi
MARIADB55ARCH=`uname -m`
echo "rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB"
rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
###############################################################################
if [[ "$CENTOS_SEVEN" = '7' ]]; then
if [ "$(uname -m)" == 'aarch64' ]; then
if [[ "$MDB_COUNTRY" = 'CN' ]]; then
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
[mariadb]
name = MariaDB
baseurl = https://mirrors.tuna.tsinghua.edu.cn/mariadb/yum/10.1/centos7-aarch64
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
else
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-aarch64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
fi
fi
if [ "$(uname -m)" == 'x86_64' ]; then
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
else
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
fi # centos 7 uname -m
fi
###############################################################################
if [[ "$CENTOS_SIX" = '6' ]]; then
if [ "$MARIADB55ARCH" == 'x86_64' ]; then
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
# rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
# /etc/yum.repos.d/mariadb.repo
# yum install MariaDB-server MariaDB-client
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
else
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
# rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
# /etc/yum.repos.d/mariadb.repo
# yum install MariaDB-server MariaDB-client
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos6-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF
fi # arch check
fi # centos6 check
if [[ "$CENTOSVER" > 5 && "$CENTOSVER" < 6 ]]; then
if [ "$MARIADB55ARCH" == 'x86_64' ]; then
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
# rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
# /etc/yum.repos.d/mariadb.repo
# yum install MariaDB-server MariaDB-client
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos5-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
priority=8
EOF
else
cat > "/etc/yum.repos.d/mariadb.repo" <<EOF
# rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
# /etc/yum.repos.d/mariadb.repo
# yum install MariaDB-server MariaDB-client
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos5-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
priority=8
EOF
fi # arch check
fi # centos5 check
}
mariadbtentotenoneupgrade() {
#check if MariaDB 10.1 RPM already installed
if [ -z "$OLDMARIADBVERS" ]; then
MYSQLDATADIR=$(mysqladmin var | grep 'datadir' | awk '{ print $4}')
backupmsg101
#mariadb101uninstall
# shutdown existing mysql server
echo
echo "shut down existing MariaDB server for upgrade.."
mysql -e "set global innodb_buffer_pool_dump_at_shutdown=0;"
sleep 10
service mysqld stop
echo
# move aside existing ib_logfile* files
cd $MYSQLDATADIR
ls -lah $MYSQLDATADIR
rm -rf ib_logfile0.gz ib_logfile1.gz
mv ib_logfile0 ib_logfile0.bak
mv ib_logfile1 ib_logfile1.bak
echo
OLDMARIADBSERVER=`rpm -qa | grep MariaDB | awk '/MariaDB-server/'`
rpm -e $OLDMARIADBSERVER
mariadb101install
if [[ "1$CENTALTREPO_DISABLE" = [nN] ]]; then
DISABLECENTALTREPO=" --disablerepo=CentALT"
else
DISABLECENTALTREPO=""
fi # CENTALTREPO_DISABLE
if [[ "$CENTALTREPO_DISABLE" = [nN] ]]; then
# make sure MariaDB 5.5 is updated from only one repo
echo ""
if [[ -z "$(grep 'exclude=mariadb' /etc/yum.repos.d/centalt.repo)" ]]; then
echo "exclude=mariadb*" >> /etc/yum.repos.d/centalt.repo
fi
fi # CENTALTREPO_DISABLE
# exclude MariaDB Galera Server
if [[ -z "$(grep 'exclude=MariaDB-Galera-server' /etc/yum.repos.d/mariadb.repo)" ]]; then
echo "exclude=MariaDB-Galera-server" >> /etc/yum.repos.d/mariadb.repo
fi
if [ -f /etc/my.cnf ]; then
cp /etc/my.cnf /etc/my.cnf-original_before_mariadb101upgrade
fi
# fix for mariadb 10.1.16 introduced ProtecHome=true setting
# https://jira.mariadb.org/browse/MDEV-10399
if [[ "$CENTOS_SEVEN" = '7' ]]; then
echo
echo "Update MariaDB 10 setting for ProtectHome=false"
echo
if [ ! -d /etc/systemd/system/mariadb.service.d/ ]; then
mkdir -p /etc/systemd/system/mariadb.service.d/
fi
cat > "/etc/systemd/system/mariadb.service.d/protecthome.conf" <<TDF
[Service]
ProtectSystem=false
ProtectHome=false
TDF
cat > "/etc/systemd/system/mariadb.service.d/openfileslimit.conf" <<TDG
[Service]
LimitNOFILE=524288
TDG
systemctl daemon-reload
fi
echo ""
echo "*************************************************"
cecho "MariaDB 10.1.x check available packages" $boldgreen
cecho "yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities" $boldgreen
echo "*************************************************"
echo ""
time yum -q list MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
if [ -f "$(which figlet)" ]; then
figlet -ckf standard "MariaDB 10.1.x Install"
fi
echo ""
echo "*************************************************"
cecho "MariaDB 10.1.x YUM install..." $boldgreen
cecho "yum -q -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities" $boldgreen
echo "*************************************************"
echo ""
time yum -y install MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared --disablerepo=epel --disableplugin=priorities
\cp -af /etc/my.cnf /etc/my.cnf-newold-mariadb10-1
echo ""
echo "*************************************************"
cecho "* Adjust old MariaDB 10.x /etc/my.cnf " $boldyellow
cecho " for MariaDB 10.1.x my.cnf compatibility " $boldyellow
echo "*************************************************"
# unalias cp
if [ -f /etc/my.cnf.rpmorig ]; then
\cp -f /etc/my.cnf.rpmsave /etc/my.cnf
fi
if [ -f "$(which figlet)" ]; then
figlet -ckf standard "MariaDB 10.1.x /etc/my.cnf Adjustments"
fi
cat >>/etc/my.cnf<<FFF
[mariadb-10.1]
innodb_file_format = Barracuda
innodb_default_row_format = dynamic
innodb_file_per_table = 1
## wsrep specific
# wsrep_on=OFF
# wsrep_provider
# wsrep_cluster_address
# binlog_format=ROW
# default_storage_engine=InnoDB
# innodb_autoinc_lock_mode=2
# innodb_doublewrite=1
# query_cache_size=0
# 2 variables needed to switch from XtraDB to InnoDB plugins
#plugin-load=ha_innodb
#ignore_builtin_innodb
## MariaDB 10 only save and restore buffer pool pages
## warm up InnoDB buffer pool on server restarts
innodb_buffer_pool_dump_at_shutdown=1
innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_populate=0
## Disabled settings
performance_schema=OFF
innodb_stats_on_metadata=OFF
innodb_sort_buffer_size=2M
innodb_online_alter_log_max_size=128M
query_cache_strip_comments=0
log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
# Defragmenting unused space on InnoDB tablespace
innodb_defragment=1
innodb_defragment_n_pages=7
innodb_defragment_stats_accuracy=0
innodb_defragment_fill_factor_n_recs=20
innodb_defragment_fill_factor=0.9
innodb_defragment_frequency=40
FFF
# sed -i 's/skip-pbxt/#skip-pbxt/g' /etc/my.cnf
# sed -i 's/innodb_use_purge_thread = 4/innodb_purge_threads=1/g' /etc/my.cnf
# sed -i 's/innodb_extra_rsegments/#innodb_extra_rsegments/g' /etc/my.cnf
# sed -i 's/innodb_adaptive_checkpoint/innodb_adaptive_flushing_method/g' /etc/my.cnf
# sed -i 's/innodb_additional_mem_pool_size/#innodb_additional_mem_pool_size/g' /etc/my.cnf
# sed -i 's/skip-innodb/innodb=ON/g' /etc/my.cnf
sed -i 's|ignore-db-dir|ignore_db_dirs|g' /etc/my.cnf
sed -i 's|^innodb_thread_concurrency|#innodb_thread_concurrency|g' /etc/my.cnf
sed -i 's|^skip-federated|#skip-federated|g' /etc/my.cnf
sed -i 's|^skip-pbxt|#skip-pbxt|g' /etc/my.cnf
sed -i 's|^skip-pbxt_statistics|#skip-pbxt_statistics|g' /etc/my.cnf
sed -i 's|^skip-archive|#skip-archive|g' /etc/my.cnf
sed -i 's|^innodb_buffer_pool_dump_at_shutdown|#innodb_buffer_pool_dump_at_shutdown|g' /etc/my.cnf
sed -i 's|^innodb_buffer_pool_load_at_startup|#innodb_buffer_pool_load_at_startup|g' /etc/my.cnf
echo ""
cmservice mysql start
sleep 15
cmservice mysql restart
if [[ "$(echo $?)" != '0' ]]; then
echo
echo "## !! mysql failed to start properly !! ##"
echo "journalctl -xn"
journalctl -xn
echo
echo "tail -50 /var/log/mysqld.log"
tail -50 /var/log/mysqld.log
echo
echo "possible errors / warnings"
tail -50 /var/log/mysqld.log | egrep -v 'Dumping|dump' | egrep --color '\[ERROR\]|\[Warning\]'
echo
echo "possible unknown or incompatible /etc/my.cnf set options below"
echo "maybe need to comment out or remove these in /etc/my.cnf"
UNKNOWNOPT=$(tail -50 /var/log/mysqld.log | egrep -v 'Dumping|dump' | egrep --color '\[ERROR\]|\[Warning\]' | grep 'unknown option' | awk '{print $8}' | uniq | sed -e "s|'--||g" -e "s|'||g")
for u in $UNKNOWNOPT; do
echo "$u"
done
echo
echo "attempting auto commenting out of invalid options"
\cp -af /etc/my.cnf /etc/my.cnf-b4autocommenting
for u in $UNKNOWNOPT; do
echo "auto comment out $u in /etc/my.cnf"
sed -i "s|^${u}|#${u}|g" /etc/my.cnf
done
cmservice mysql restart
fi
echo
ls -lAhrt /var/lib/mysql/
sleep 3
if [ ! -f /root/.my.cnf ]; then
echo ""
echo "------------------------------------------------"
echo "Updating MySQL database tables"
echo "------------------------------------------------"
read -p "Do you have a MySQL root password set ? [y/n]: " mysqlrootset
echo ""
else
mysqlrootset=n
fi
if [[ "$mysqlrootset" == [yY] ]]; then
echo "Enter MySQL root password when prompted"
echo "or hit enter to continue"
echo "mysql_upgrade -u root -p --verbose"
mysql_upgrade -u root -p --verbose
echo "------------------------------------------------"
echo "Installing MariaDB 10 plugins"
echo "------------------------------------------------"
echo "mysql -u root -p -e \"INSTALL SONAME 'metadata_lock_info';\""
mysql -u root -p -e "INSTALL SONAME 'metadata_lock_info';"
echo "mysql -u root -p -e \"INSTALL SONAME 'query_cache_info';\""
mysql -u root -p -e "INSTALL SONAME 'query_cache_info';"
echo "mysql -u root -p -e \"INSTALL SONAME 'query_response_time';\""
mysql -u root -p -e "INSTALL SONAME 'query_response_time';"
# echo "------------------------------------------------"
# echo "Installing MariaDB 10 XtraDB Engine plugin"
# echo "------------------------------------------------"
# echo "mysql -u root -p -e \"INSTALL SONAME 'ha_xtradb';\""
# mysql -u root -p -e "INSTALL SONAME 'ha_xtradb';"
echo "mysql -u root -p -e \"SELECT * FROM mysql.plugin;\""
mysql -u root -p -e "SELECT * FROM mysql.plugin;"
echo "mysql -u root -p -e \"SHOW PLUGINS;\""
mysql -u root -p -e "SHOW PLUGINS;"
echo "mysql -u root -p -e \"SHOW ENGINES;\""
mysql -u root -p -e "SHOW ENGINES;"
# echo "Enter MySQL root password when prompted"
# echo "or hit enter to continue"
# echo "mysql_upgrade -u root -p --force"
# mysql_upgrade -u root -p --force
# sed -i 's/innodb=ON/innodb=OFF/g' /etc/my.cnf
else
echo "mysql_upgrade --verbose"
mysql_upgrade --verbose
echo "------------------------------------------------"
echo "Installing MariaDB 10 plugins"
echo "------------------------------------------------"
echo "mysql -e \"INSTALL SONAME 'metadata_lock_info';\""
mysql -e "INSTALL SONAME 'metadata_lock_info';"
echo "mysql -e \"INSTALL SONAME 'query_cache_info';\""
mysql -e "INSTALL SONAME 'query_cache_info';"
echo "mysql -e \"INSTALL SONAME 'query_response_time';\""
mysql -e "INSTALL SONAME 'query_response_time';"
# echo "------------------------------------------------"
# echo "Installing MariaDB 10 XtraDB Engine plugin"
# echo "------------------------------------------------"
# echo "mysql -e \"INSTALL SONAME 'ha_xtradb';\""
# mysql -e "INSTALL SONAME 'ha_xtradb';"
echo "mysql -t -e \"SELECT * FROM mysql.plugin;\""
mysql -t -e "SELECT * FROM mysql.plugin;"
echo "mysql -t -e \"SHOW PLUGINS;\""
mysql -t -e "SHOW PLUGINS;"
echo "mysql -t -e \"SHOW ENGINES;\""
mysql -t -e "SHOW ENGINES;"
# echo "mysql_upgrade --force"
# mysql_upgrade --force
# sed -i 's/innodb=ON/innodb=OFF/g' /etc/my.cnf
fi
# echo "------------------------------------------------"
# echo "Enabling MariaDB 10 XtraDB Engine plugin"
# echo "------------------------------------------------"
# sed -i 's/#plugin-load=ha_xtradb/plugin-load=ha_xtradb/g' /etc/my.cnf
# sed -i 's/#ignore_builtin_innodb/ignore_builtin_innodb/g' /etc/my.cnf
# sed -i 's/innodb_purge_threads=1/#innodb_purge_threads=1/g' /etc/my.cnf
# sed -i 's/innodb_doublewrite = 1/#innodb_doublewrite = 1/g' /etc/my.cnf
# sed -i 's/innodb_doublewrite=1/#innodb_doublewrite=1/g' /etc/my.cnf
# mariadb 10.1 systemd changes https://community.centminmod.com/posts/22696/
if [[ "$CENTOS_SEVEN" = '7' ]] ; then
if [ -f /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf ]; then
rm -rf /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
cat > "/etc/systemd/system/mariadb.service.d/mdb101.conf" <<EFF
[Service]
OOMScoreAdjust=-600
LimitNOFILE=524288
LimitNPROC=16384
Nice=-5
EFF
systemctl daemon-reload
fi
fi
cmservice mysql restart
if [[ "$CENTOS_SEVEN" = '7' ]] ; then
cmchkconfig mariadb on
else
cmchkconfig mysql on
fi
sed -i 's|^#innodb_buffer_pool_dump_at_shutdown|innodb_buffer_pool_dump_at_shutdown|g' /etc/my.cnf
sed -i 's|^#innodb_buffer_pool_load_at_startup|innodb_buffer_pool_load_at_startup|g' /etc/my.cnf
echo ""
# yum -q -y install perl-DBD-MySQL
echo ""
mysqladmin ver
echo
# if you set /etc/centminmod/custom_config.inc file to
# MARIADB_UPDATEMAINTENANCE=y
# then whenever you run mariadb upgrade, you put all sites
# on server into 503 maintenance mode first and once
# updated, disable 503 maintenance mod after
if [[ "$MARIADB_UPDATEMAINTENANCE" = [yY] ]]; then
if [ -f /usr/bin/sitestatus ]; then
/usr/bin/sitestatus on
fi
fi
echo "------------------------------------------------"
echo "MariaDB 10.1.x Upgrade completed"
echo "------------------------------------------------"
if [ -f "$(which figlet)" ]; then
figlet -ckf standard "MariaDB 10.1.x Upgraded"
fi
fi
}