Find answers, ask questions, and connect with our
community around the world.

Home Forums GCP GCP Associate Cloud Engineer MySQL and HA

  • MySQL and HA

  • rochahe5

    Member
    April 9, 2021 at 12:05 pm

    hey guys in this Q, by just creating the DB using multiple zones options – HA – option “Point-in-time recovery is enabled” is enabled by default there is no option to enable/disable in fact, if you select a multi zone MySQL. Second if you have an existing DB and want to enable-ADD- HA you just ADD HA and GCP will take care of enabling what it is needed in order to have HA in another zone in the same region.

    check the video as well I enable HA or a standby DB for MySQL and and I just clicked on ADD and Point in Time Recovery was enable by default

    https://www.screencast.com/t/2PX9qTthnQ

    I know theory says the same but when I worked on a MySQL DB I saw that behavior

    ————————————–

    Category: ACE – Planning and Configuring a Cloud Solution

    You are working for a finance company and are assigned to configure a relational database solution on Google Cloud Platform to support a small set of operational data in a particular geographical location. Your company requires the database to be highly reliable and supports point-in-time recovery while minimizing operating costs.

    (x) Choose Cloud SQL (MySQL) and verify that the enable binary logging option is selected.

    Choose Cloud SQL (MySQL) and select the create failover replicas option.

    Choose Cloud Spanner and configure your instance with 2 nodes.

    Choose Cloud Spanner and set up your instance as multi-regional.

    • This discussion was modified 3 years, 1 month ago by  rochahe5.
    • This discussion was modified 3 years, 1 month ago by  rochahe5.
  • lervin-john-obando

    Member
    April 11, 2021 at 2:36 pm

    Hi rochahe5,

    That is indeed correct. Point-in-time recovery and automated backup features are enabled automatically when the HA option is enabled.

    Also, when setting up a MySQL instance in a single zone, those features become optional.

    For the correct answer, it only says to verify the binary logging option and not to configure. Cloud SQL needs binary logging for the point-in-time recovery. Hence, the correct answer.

    We will note your concern and discuss this with our team to check if the question needs improvement.

Viewing 1 - 2 of 2 replies

Log in to reply.

Original Post
0 of 0 posts June 2018
Now