MySQL Server 5.7 to 8.0 in AWS RDS
1. Login to AWS console in account
2. Go to RDS services.
3. Search for instance "usmysqlserver-prod" N. Virginia region and
select the instance.
4. Then go to "Maintenance & backups" tab and apply pending
maintenance if any.
5. Click on 'Actions' and then click 'Take snapshot.' Provide the snapshot name
and click "Take Snapshot."
6. Then, if the current parameter group is not the default, click on the
parameter group option from the left panel, search with the current DB cluster
parameter group name, go to actions, and click on compare.
7. If there is any change in default parameter values then create a new
parameter group with standards and edit the values of those parameters as same
as old parameters and their values.
8. Then, go to AWS console and open the mentioned RDS instance.
9. Click on "Modify" and change the "DB engine version"
from "5.7. mysql_aurora.2.11.2" to "Aurora MySQL 3.05.2
(Compatible with MySQL 8.0.32)" and attach newly created parameter group.
10. Click on "Continue" and then "Apply immediately"
11. Then click on "Modify DB Instance"
12. Update the inventory.
Tvenkat
I have 16+ years of experience in IT and 11+ years of experience in training. I am currently working in Bangalore and occasionally in Hyderabad as well. I have worked in various domains including Telecom, Healthcare, Pharma, Insurance, Retail, and Storage. Currently, I am working as a Cloud Principal Consultant in an MNC Product based company.
