Difference in minor versions test and production database

[Bart Stavenuiter]

Hi,

We've got two databases in Google Cloud SQL. One for production and one for testing purposes.

However the versions differer between the two.

Test-database-version: 5.7.25

Production-database-version: 5.7.14

We are using this Aggregate (GROUP BY) Function added in 5.7.22 

https://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html#function_json-arrayagg

Is there a way to tell Google Cloud Sql to upgrade the database to the latest or maybe minimal version? 

I read the upgrade policy, but it seems to say that these minor updates are automatically and you cannot specify when these update should occur.

thanks in advance!

Met vriendelijke groet / With kind regards,​ Bart Stavenuiter Team Lead Development SOCIAL BLUE Nieuwe Steen 27 ​1625 HV  Hoorn ​The Netherlands  T:  +31 (0)229 283 000 E:  b.stav...@socialblue.com We're an official Facebook Marketing Partner Kvk: 59384360

[Elliott (Google Cloud Platform Support)]

Hello Bart,

It seems unusual that your Cloud SQL instances are not at the same version because Cloud SQL is a managed product. Updating is one of the benefits. It seems that your instances should be at the same level. In this case, I would ask you to submit a bug to have this investigated. You may open a Google Issue Tracker here.

[Bart Stavenuiter]

Hi Elliot,

thanks for you response.

I've created an issue with about the same information in this ticket.

https://issuetracker.google.com/issues/157681342

On Thursday, 28 May 2020 21:04:36 UTC+2, Elliott (Google Cloud Platform Support) wrote:

Hello Bart,

It seems unusual that your Cloud SQL instances are not at the same version because Cloud SQL is a managed product. Updating is one of the benefits. It seems that your instances should be at the same level. In this case, I would ask you to submit a bug to have this investigated. You may open a Google Issue Tracker here.