How do I upgrade major version of my Lightsail database (5.7.38 - 8.0.xx)?

Question

How do I upgrade major version of my Lightsail database (MySQL 5.7.38 -> 8.0.xx)?

I thought I could take a snapshot and restore it to a new instance, though an in-place upgrade would be preferable.
But it seems that I can not do either of those things.
Please advise me how to do this. Thanks

Juztinius · Answer

Thanks for your answer. We are running Ubuntu 20.04 LTS
 But the MySQL Database is a lightsail database , ie it is not installed on the Ubuntu server. 
Those instructions are telling me how to upgrade a locally installed MySQL server aren' t they?

Riku_Kobayashi · Answer

What OS does Lightsail use?  
The procedure differs on Ubuntu and CentOS.  
Check the operating system with the following command.  
```
sudo cat /etc/os-release
```

Once the OS is confirmed, please prepare for the upgrade.  
Also, be sure to create a snapshot of Lightsail before performing this procedure.  
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html

If your OS is CentOS or similar, please follow the document below.  
https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html

If your OS is Ubuntu or other operating system, follow the documentation below.  
https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#repo-qg-apt-upgrading

How do I upgrade major version of my Lightsail database (5.7.38 -> 8.0.xx)?

Relevant content