-
MySQL and HA
updated 3 years, 5 months ago
2 Members
·
2
Posts
-
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.
-
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.
Log in to reply.