Home / server / Questions / 862500
Accepted
matpol
Asked: 2017-07-17 23:42:52 +0800 CST

AWS RDS mysql upgrade 5.5 to 5.6

  • 772

What is the best/easiest way to upgrade and RDS instance running mysql 5.5 to 5.6. I have seen two potential methods:

  1. modifying the instance - this seems the easiest method - have people done it - did it work - what problems were there
  2. creating a read replica and then promoting this to the master - this seems the most robust way to do it but if people have experience of doing the option 1 it would be interesting to know.
amazon-web-services

1 Answers

  1. Best Answer

    I recommend modifying the instance (Option 1) and let it upgrade during your maintenance period. We did this before without issues.

    I prefer not to go with Option 2 if you are running a heavily transactional database because you will need to wait for the slave to catch up with the master before being able to promote it to ensure no data loss (on the new master).

    • 0