Sunday, May 27, 2018

[google-cloud-sql-discuss] Re: MyISAM tables on Cloud SQL

Hello Dan,


I found it odd that on your existing instance, you initially were not able to use myISAM, but then somehow that changed. So a possible explanation for this behavior could be that you had configured your instance for high availability, and the replica itself may had this issue and not the original master. Hence, the failover instance (due to failover) could have replaced the original master (became master and retained the original master's ID). [Side note] The procedure also creates a new failover instance to replace the old failover.


That said, I tested this theory and found that when the failover instance replaces the master, it indeed allows using myISAM, and that is not an expected behavior. Thus, I opened this public issue for further investigation by the Cloud SQL team. If that is not the case with you, you may open a private issue per my suggestion above to inspect your instance.


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fc852dd3-14b5-4404-bb80-ce70c4115d34%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment