Tipsandtricks - Revision history

Phenixops at 19:49, 16 April 2020

2020-04-16T19:49:29Z

← Older revision		Revision as of 19:49, 16 April 2020
Line 17:		Line 17:
	\|-		\|-
	! Actions		! Actions
			\|-
			\|Log the start of the incident and indicators
	\|-		\|-
	\|Check monitoring		\|Check monitoring

2020-04-16T19:48:07Z

← Older revision		Revision as of 19:48, 16 April 2020
Line 43:		Line 43:
	\|-		\|-
	\|Last resort '''''reboot''''' perhaps check most recent backup first		\|Last resort '''''reboot''''' perhaps check most recent backup first
			\|-
			\|Restore most recent backup, dump the database first
	\|-		\|-
	! Post actions		! Post actions

2020-04-16T19:45:37Z

← Older revision		Revision as of 19:45, 16 April 2020
Line 43:		Line 43:
	\|-		\|-
	\|Last resort '''''reboot''''' perhaps check most recent backup first		\|Last resort '''''reboot''''' perhaps check most recent backup first
			\|-
			! Post actions
			\|-
			\|Reactivate monitoring
			\|-
			\|Log actions and problem resolution
			\|-
			\|Keep an eye on monitoring and logfiles
			\|-
			\|Log rootcause, lessons learned and pending actions
	\|}		\|}

2020-04-16T19:41:18Z

← Older revision		Revision as of 19:41, 16 April 2020
Line 18:		Line 18:
	! Actions		! Actions
	\|-		\|-
	\|Check monitoring ~~and system~~ logging		\|Check monitoring
			\|-
			\|Check the logging '''''less /var/log/mysql.log'''''
	\|-		\|-
	\|Check mysqld service '''''service mysqld status'''''		\|Check mysqld service '''''service mysqld status'''''
Line 27:		Line 29:
	\|-		\|-
	\|Check the ports from remote using '''''nmap -Pn databasehost'''''		\|Check the ports from remote using '''''nmap -Pn databasehost'''''
	\|-
	~~\|Check the logging '''''less /var/log/mysql.log'''''~~
	\|-		\|-
	\|Try to login locally on the database server '''''mysql -u root -p'''''		\|Try to login locally on the database server '''''mysql -u root -p'''''

2020-04-16T19:39:34Z

← Older revision		Revision as of 19:39, 16 April 2020
Line 18:		Line 18:
	! Actions		! Actions
	\|-		\|-
			\|Check monitoring and system logging
	\|-		\|-
	\|Check mysqld service '''''service mysqld status'''''		\|Check mysqld service '''''service mysqld status'''''
Line 27:		Line 28:
	\|Check the ports from remote using '''''nmap -Pn databasehost'''''		\|Check the ports from remote using '''''nmap -Pn databasehost'''''
	\|-		\|-

	\|Check the logging '''''less /var/log/mysql.log'''''		\|Check the logging '''''less /var/log/mysql.log'''''
	\|-		\|-
Line 42:		Line 42:
	\|Check mysql service '''''service mysqld status'''''		\|Check mysql service '''''service mysqld status'''''
	\|-		\|-
			\|Last resort '''''reboot''''' perhaps check most recent backup first

	\|}		\|}

2020-04-16T19:35:03Z

← Older revision		Revision as of 19:35, 16 April 2020
Line 34:		Line 34:
	\|Try to login from the remote host '''''mysql -h databasehost -u dbusername -p'''''		\|Try to login from the remote host '''''mysql -h databasehost -u dbusername -p'''''
	\|-		\|-
	! Fixing (you might kill the webserver/~~application~~ first~~, perhaps pause the monitoring~~)		! Fixing (you might kill the webserver/monitoring first)
	\|-		\|-
	\|Restart mysql service '''''service mysqld restart'''''		\|Restart mysql service '''''service mysqld restart'''''

2020-04-16T19:34:37Z

← Older revision		Revision as of 19:34, 16 April 2020
Line 19:		Line 19:
	\|-		\|-
	\|-		\|-
	\| Check load on database server using '''''top'''''		\|Check mysqld service '''''service mysqld status'''''
			\|-
			\|Check load on database server using '''''top'''''
	\|-		\|-
	\|Check the ports using '''''nmap -Pn localhost'''''		\|Check the ports using '''''nmap -Pn localhost'''''
Line 25:		Line 27:
	\|Check the ports from remote using '''''nmap -Pn databasehost'''''		\|Check the ports from remote using '''''nmap -Pn databasehost'''''
	\|-		\|-
	\|Check ~~mysql service~~ '''''~~service mysqld status~~'''''
			\|Check the logging '''''less /var/log/mysql.log'''''
	\|-		\|-
	\|~~Check~~ the ~~logging~~ '''''~~less /var/log/~~mysql~~.log~~'''''		\|Try to login locally on the database server '''''mysql -u root -p'''''
	\|-		\|-
	\| Try to login ~~locally on~~ the ~~database server~~ '''''mysql -u ~~root~~ -p'''''		\|Try to login from the remote host '''''mysql -h databasehost -u dbusername -p'''''
	\|-		\|-
	! Fixing (you might kill ~~your~~ webserver/application first)		! Fixing (you might kill the webserver/application first, perhaps pause the monitoring)
	\|-		\|-
	\| Restart mysql service '''''service mysqld restart'''''		\|Restart mysql service '''''service mysqld restart'''''
	\|-		\|-
	\|Follow the logging '''''tail -f /var/log/mysql.log'''''		\|Follow the logging '''''tail -f /var/log/mysql.log'''''

2020-04-16T19:28:56Z

2020-04-16T19:27:08Z

← Older revision		Revision as of 19:27, 16 April 2020
Line 32:		Line 32:
	\|-		\|-
	\| Restart mysql service '''''service mysqld restart'''''		\| Restart mysql service '''''service mysqld restart'''''
			\|-
			\|Follow the logging '''''tail -f /var/log/mysql.log'''''
			\|-
			\|Check mysql service '''''service mysqld status'''''
			\|-

	\|}		\|}

2020-04-16T19:25:01Z

← Older revision		Revision as of 19:25, 16 April 2020
Line 13:		Line 13:
	\|-		\|-
	\| Check if mysqld is running and if the ports are available on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide some info to start troubleshooting from.		\| Check if mysqld is running and if the ports are available on the localhost and from the host you try to connect from. See if the service is running and if you can connect locally. This should usually provide some info to start troubleshooting from.
			\|-
			! Actions
	\|-		\|-
	\|-		\|-