example maintenance on a mariadb host
ActivePublic
Actions

Authored by jcrespo on Aug 30 2018, 7:59 AM.

Tags

None

Referenced Files

	F27277341: example maintenance on a mariadb host
	Nov 22 2018, 9:56 AM

	F26209269: example maintenance on a mariadb host
	Sep 26 2018, 8:05 AM

	F25521578: example maintenance on a mariadb host
	Aug 30 2018, 7:59 AM

Subscribers

None

	for socket in /run/mysqld/*; do mysql --skip-ssl --socket=$socket -e "STOP SLAVE"; done

	systemctl stop mariadb 'mariadb@*'

	pgrep mysqld

	apt update && apt -y full-upgrade

	run-puppet-agent; disable-puppet reboot && umount /srv && shutdown -r now

	skip-slave-start #\|\| systemctl set-environment MYSQLD_OPTS="--skip-slave-start"
	enable-puppet reboot && run-puppet-agent

	systemctl start mariadb
	or
	systemctl start mariadb@s1
	systemctl start mariadb@s2
	systemctl start mariadb@s3
	systemctl start mariadb@s4
	...

	for socket in /run/mysqld/*; do mysql_upgrade --skip-ssl --socket=$socket; done
	for socket in /run/mysqld/*; do mysql --skip-ssl --socket=$socket -e "START SLAVE"; done

example maintenance on a mariadb hostActivePublicActions