Running queries report when RDS load is high

While working on RDS database, several times we observe that RDS slowdowns due to high CPU load which can cause due to lots of queries hitting to DB and run at the same time.  surely you can setup a monitoring system which can send you alerts related to CPU load. But manually checking the db, […]

View Post

ERROR 1095 (HY000): You are not owner of thread

I tried to kill query on AWS RDS today and I got an error saying “ERROR 1095 (HY000): You are not owner of thread” , even though I was using the admin account for RDS. As the error suggests, in order to kill it, you need to be the process owner. You can get the […]

View Post

Manage AWS resources using CloudFormation and Chef

Hi Folks, I’m writing this post to share – on how we used CloudFormation to manage AWS resources and exploited AWS CloudFormation application bootstrap helper scripts to register EC2 machines with Chef server for automation. AWS CloudFormation’s templates describe the AWS resources, and any associated dependencies or runtime parameters, required to run your application. To […]

View Post

Alerting for stale nodes on Chef with Nagios

With the new version of Chef we have more options and more features and an even better knife status command, which brings us to the discussion at hand which is how to alert for stale nodes on Chef using Nagios:- The knife status command is used to display a brief summary of nodes on a […]

View Post

Upgrading from Chef 10 to Chef 11

We shall be using the knife-essentials plugin to upgrade from Chef 10 to Chef 11. Prerequisites To upgrade, you need a live Chef 10 and Chef 11 server, and a knife workstation that can hit them both, loaded with the latest knife-essentials. 1. To install Chef 11, follow instructions here. Note: If we are going […]

View Post

Parse ohai output with jq

Ohai is a tool which is used  by chef-client to obtain information about  the node’s platform detail, networking usage, memory usage, processor usage , kernel data , host names, fully qualified domain names and other configuration. It also has command line tool which displays the data in Json. ohai  | head -4 { "languages": { […]

View Post

Subscribe to Our Newsletter

Join our community of DevOps enthusiast - Get free tips, advice, and insights from our industry leading team of AWS experts.