I'm new to mysql and GC. It may sound like opinion based question, so sorry for that. But, I really need a right opinion. My company wants to move their on-prem mysql to GC managed mysql. I was looking for feature differences and I found this link: https://cloud.google.com/sql/docs/mysql/features

However, nothing related to tablespaces mentioned here. I wanted to check if we can create tablespaces on GC for mysql and what other things can be missing there.

If anyone has exact idea about pros and cons of GC managed mysql..that will be really helpful. Thanks in advance!

  • Google Cloud SQL is a managed service which means storage is also managed. Specifying storage locations is not supported. Why do you need this feature? Apr 28, 2021 at 17:16
  • @JohnHanley - I know google managed database will auto-scale. But, I don't know in case of partitioned table - how does it do partition allocation physically. On on-prem - what we used to do that we keep each partition to separate disk. Likewise, we get a good performance. Apr 28, 2021 at 17:27
  • You do not control those features. Google Cloud SQL is a "managed" service. Apr 28, 2021 at 17:29
  • @JohnHanley - if you have used google managed databases in past ..would you recommand that? Apr 28, 2021 at 17:56
  • You will have to do your own research to determine if Cloud SQL is for you. It is an excellent product that I have been using for years (since it was first released). Remember that you do not have "privileged" rights as Google Cloud manages the database system. Apr 28, 2021 at 18:09


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.