AWS RDS incompatible-parameters solved

Recently, I rebooted one of my RDS (Mysql) instance, as it was hanging every now and then.

What should have been a breeze, became stormy. Instance rebooted, and picked wrong Parameter Group. The parameters, understandably, were not set with this instance in mind. The instance went in incompatible-parameters Status (i.e. DB Instance Status).

I figured the issue, and tried to change the right parameter group. BUT, because instance is in incompatible-parameters Status, the change will not be allowed. I tried looking with our friend Google on how to get my instance in Available status again, only to find that people already are in distress, from as long as 2010. There have been no plausible and easy solution to do this. Refer following

  • https://forums.aws.amazon.com/thread.jspa?threadID=237385
  • https://forums.aws.amazon.com/thread.jspa?messageID=587725
  • https://forums.aws.amazon.com/thread.jspa?threadID=55800 


BTW, I cannot change my Parameters Group values, as that Group is being used in a other RDS instance, and I need that. I just wanted a different Parameter Group.

Knowing that I am on my own, I did following, and was successful

  1. Instance Actions => Reboot 
  2. Instance comes in Available status (guess it remains there for a while, before going in incompatible-parameter Status)
  3. While it is in 2, Instance Actions => Modify 
  4. Change Parameter Group to the desired one (Pick Apply Immediately) 
  5. Parameter Group will show (pending-reboot)
  6. Instance Actions => Reboot 


Instance works again!! Best of luck

Comments

  1. I found this blog in search results while i am searching for aws jobs in hyderabad. Thank You admin sharing for this information. Which is useful for me.

    ReplyDelete
  2. brillant piece of information, I had come to know about your web-page from my friend hardkik, chennai,i have read atleast 9 posts of yours by now, and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a million once again, Regards

    best aws training in hyderabad

    ReplyDelete
  3. brillant piece of information, I had come to know about your web-page from my friend hardkik, chennai,i have read atleast 9 posts of yours by now, and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a million once again, Regards

    best aws training in hyderabad

    ReplyDelete

Post a Comment

Popular posts from this blog

504 Gateway Timeout on Amazon AWS ELB (Elastic Load Balancer)