Current Version of SonarQube: 126.96.36.199468
Machine Details: AWS ec2. 2vCPU, 4 GB Ram.
I’ve been using this sonarqube for more than 2 years now and have a licence for 1M loc (Code base is hardly 175kloc). I had never updated to 7.x and above since it required Postgres or Oracle DB and I wanted it on mysql for some reason. Now, that my licence is about to get over and I read that, support for 6.x will be over soon. So, I need to upgrade to 7.9.2 LTS or 8.1. I prefer 8.1 since it supports Gitlab pipelines and merge request comments.
DB migration: How easy it is to migrate data from Mysql to Postgres?
Which DB is desired? Postgres or Oracle? and Why?
What is the DB requirement? (I’ve licence for 1M but code base is hardly 175kloc)
What is the right way of upgrading? (I’m sure upgrading from 6.7.2 to 8.1 will not work. I will have to upgrade several times.)
The link you’ve sent is the correct one to check the DB requirements, and you’ll see that we recommend Oracle, Postgres or MSSQL. There is no mention of MySQL, above 7.9 LTS + version of SQ.
Indeed, we deprecated MySQL Support in 7.8 and dropped it in 7.9, as mentioned here: End of Life of MySQL Support