search

jmac11 / googlecloudsql

Automatically exported from code.google.com/p/googlecloudsql
0 stars 0 forks source link

Cloud SQL should enable sql_mode and innodb_strict_mode by default #93

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi Speckle-Eng,

I am from acqops-dba team. We are currently evaluating Cloud SQL and prepare 
for future Acquired Products on-boarding or migration from GOLO to Cloud need.

I created an testing Cloud SQL instance and seeing sql_mode and 
innodb_strict_mode are not enabled by default. 

I don't see it is one of the option in the new flags during the DB instance is 
created.

I also tried even root user can't change that for a running instance.
(i understand root doesn't have super)

With our experience dealing with some acquired legacy MySQL databases, it is 
very hard to fix the data, test out application and enable them on the later 
stage to make sure data integrity on the databases which we need to manage...

we recommend Cloud SQL should enable sql_mode and innodb_strict_mode by default.

Just wondering if this is already in the road map, when that could be available 
if it is.

Thanks!
Jinping

Original issue reported on code.google.com by ji...@google.com on 17 Jun 2014 at 8:14

GoogleCodeExporter commented 9 years ago 
I have forwarded this request to the engineering team. We will update this 
issue with any progress updates and a resolution.

Best regards, Vaqar

Original comment by vshe...@google.com on 27 Apr 2015 at 9:49