Google Cloud SQL data loss

Question

I have recently started using google cloud sql as the backend for an api. Today whilst adding a new IP to the access control the DB went down. I restarted it after a while and when it came back up several tables of data had been lost.

I have it set to use the more reliable method for writes and cannot see how this could happen.

How is this possible?

Answer 1

It could be you are using the wrong storage engine. You should use InnoDB. The Google Cloud SQL FAQ states:

Warning: Using the MyISAM storage engine could result in data loss in some situations, such as unclean shutdowns. For more information, Corrupted MyISAM Tables.

https://developers.google.com/cloud-sql/faq#innodb