-
What Grafana version and what operating system are you using? V6.6 on AWS EC2 Instance
-
What are you trying to achieve? upgrading just the database from
Upgrade Grafana-PRD Aurora from 5.7.mysql_aurora.2.11.2 to 8.0.34mysql_aurora.3.06.0 -
How are you trying to achieve it?
Blue/Green Deployment using AWS method -
What happened? want to try it tonight just wondering if 6.6 is compatible with MySQL 8
-
What did you expect to happen?
-
Can you copy/paste the configuration(s) that you are having problems with?
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
-
Did you follow any online instructions? If so, what is the URL?
Well, last night we performed the upgrade and it went flawlessly. So we just so happen to be on Grafana V6.6 and had our backend database on Aurora from 5.7.mysql_aurora.2.11.2. For background we are on AWS.
Since we used the default database parameter group for the 5.7 one thing that was required was to have replication turned on for Blue/Green deployment. You cannot modify default parameter db parameter groups as those are owned by AWS so we simply created a new one based off of 5.7 then turned on mixed mode replication.
We then had to edit the database and add our new database parameter group which now had our mixed mode replication on which is a requirement for Blue/Green deployment.
Next we also didn’t have any database or cluster parameter groups for version 8 so we created those.
After that we rebooted the database to pick up our new database parameter group. We were then able to go through the Blue/Green deployment process which is AWS preferred way of upgrading to a new database. That all worked well, meaning we then had our version 5 working with no interruptions except for the reboot, and our version 8 running in read only mode. then when everything was ready we executed the switchover as its called that took all of approximately 1 minute.
after that we went in and checked some of our most critical dashboards, they all looked good, we looked at the critical health of grafana through those dashboards and noticed new metrics coming in, probably from version 8,
as of this morning, we’ve had zero reports we have over 2,400+ dashboards out there in use, we’ll make the determination when we want to delete the old cluster which is the old 5.7 cluster which we’ve now moved off of.
So if anyone out there is using a very old 6.6 version of Grafana and a default 5.7 database parameter group with no mods in it. and want to go to version 8 of mySQL and use the default database parameter group no mods. Your mileage may vary, but they are pretty good you’ll have success.