![\"Screen](\"https:\/\/www.postinger.com\/wp-content\/uploads\/2016\/05\/Screen-Shot-2016-05-01-at-7.51.13-AM-1024x117.png\")
this is the error<\/p><\/div> Add a notification to execute a program, select the batch file you saved in the above referenced path. Postinger.com runs on a micro EC2 instance from amazon. Occasionally the database uses too much CPU, memory or iops and crashes. I’m sure I should be running on a instance with more resources. I’ve adjusted swap, memory usage and threads apache uses but still occasionally the database crashes. “Error establishing a database connection” I have […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[7],"tags":[11,12,22,36],"class_list":["post-807","post","type-post","status-publish","format-standard","hentry","category-tech","tag-aws","tag-ec2","tag-prtg","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/posts\/807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/comments?post=807"}],"version-history":[{"count":0,"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/posts\/807\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/media?parent=807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/categories?post=807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.postinger.com\/index.php\/wp-json\/wp\/v2\/tags?post=807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n“Error establishing a database connection”
\nI have a PRTG instance running at home monitoring my internal network. I know PRTG has the ability to check for a word from an external webpage. So here is the solution.
\nAdd an HTTP Advanced Web Sensor, checking for a word that will appear on your wordpress page(the word “WordPress” is a good choice for this)
\n![\"2016-05-01_1133\"](\"https:\/\/www.postinger.com\/wp-content\/uploads\/2016\/05\/2016-05-01_1133.png\")
\nInstall the puTTY msi<\/a> on your prtg server(or copy puTTY and plink.exe to it.
\nIn your Path to your PRTG install’s notification\\exe directory (E:\\PRTG Network Monitor\\Notifications\\EXE) Add a batch file with the following line:<\/p>\necho yes | plink -ssh ec2-user@domain\u00a0-i e:\\path\\to\\key.ppk sudo shutdown -r now\n#echo yes, answers the prompt to trust the signature, the key is generated via\u00a0PuTTYgen\n<\/a><\/pre>\n
\n![\"2016-05-01_1136\"](\"https:\/\/www.postinger.com\/wp-content\/uploads\/2016\/05\/2016-05-01_1136.png\")
\nAdd a state trigger referencing your notification and set the appropriate timing.
\n![\"2016-05-01_1139\"](\"https:\/\/www.postinger.com\/wp-content\/uploads\/2016\/05\/2016-05-01_1139.png\")
\nThat should do it. My batch file restarts the whole instance which for me is fine, but you may want to tweak the batch file only\u00a0to restart the database or whatever else you see fit.<\/p>\n","protected":false},"excerpt":{"rendered":"