I already have Master Slave configuration on AWS RDS. We want to upgrade 5.5 to 5.6.23. ..What should be correct sequence to Upgrade ?

  1. Upgrade Master ( Using Modify Instance ) --> Upgrade Slave
  2. Upgrade Master ( Using Modify Instance ) --> Create a new Read Replica ?

Look for Amazon instructions. With RDS, the instructions are roughly:

  1. Upgrade the Slave first. Replication works when the Master is 'older'.
  2. Failover, but do not turn on the Slave.
  3. Upgrade the Slave (was Master)
  4. Turn on replication (START SLAVE)
  5. Wait for replication to catch up before using the Slave.
| improve this answer | |
  • At suitable points, turn on/off readonly. – Rick James Jun 30 '15 at 16:18

You can potentially face few issues like if you have scheduler events configured etc... I will recommend safest and easiest way is to upgrade master and recreate the slave.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.