[google-cloud-sql-discuss] Re: How to disable Read-Only in SQL replica?

Hey Ann Su,

I'll be checking whether this is reproducible on my own instances. The documentation implies this is alterable, so it shouldn't be happening in my view. I'll update you with my findings within the next two days.

Cheers,

Nick
Cloud Platform Community Support

On Wednesday, December 28, 2016 at 9:22:17 AM UTC-5, Ann Su wrote:

Google Console interface allows to set up "read-only" flag to OFF for a read replica. However, regardless of the flag's value, which according to: 

$ gcloud sql instances describe {{replica}}

is correctly set:

[...]

  - name: read_only

    value: 'off'

the global variable in mysql is still set to ON:

mysql> show variables like "read_only";

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| read_only     | ON    |

+---------------+-------+

Is this a bug? 

I'm aware of all related risks of writing to a replica and am willing to do that anyway. If I can't disable read_only mode for built-in replicas, what are my options? Can I manually configure replication using SQL instances in a way that such replica wouldn't get into read_only mode?

--
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/a3412438-3395-4de0-b573-42170a9b382d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.