Failover replica as read replica

[Lieven Janssen]

How can I use my failover replica as a read replica?

Can't seem to find any info or setting to turn this on.

[Kamran (Google Cloud Support)]

Hello Lieven,

As described in this article:

You can use the failover replica as a read replica, to offload read operations from the master.

For more information about creating read replicas, see Configuring Replication.

I hope this helps.

Sincerely,

[Lieven Janssen]

Hi Kamran,

I read this in the documentation but if I create a failover replica it doesn't allow me to use it as a read replica. Do you suggest creating a read replica instead of a failover replica? Will a read replica also be used as a failover when there is an outage of the master?

Best Regards,

Lieven

Op zaterdag 17 juni 2017 23:42:20 UTC+2 schreef Kamran (Google Cloud Support):

[Vadim Berezniker]

A failover replica is fully usable as a read replica. 

What errors do you see when you try to connect to it?

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/5c734c08-0b05-47e3-b4e3-1bc4a0751fd4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Lieven Janssen]

Hi Vadim,

I expected that it would autoatically be a read replica for our end users (through API) as well to ease the load on our main db but I only saw one active connection. Do we need to set up a seperate db connection for all selects we do on the db from our API?

L.

On Monday, 19 June 2017 22:09:52 UTC+2, Vadim Berezniker wrote:

A failover replica is fully usable as a read replica. 

What errors do you see when you try to connect to it?

On Mon, Jun 19, 2017 at 6:16 AM Lieven Janssen <lie...@salesflare.com> wrote:

Hi Kamran,

I read this in the documentation but if I create a failover replica it doesn't allow me to use it as a read replica. Do you suggest creating a read replica instead of a failover replica? Will a read replica also be used as a failover when there is an outage of the master?

Best Regards,

Lieven

Op zaterdag 17 juni 2017 23:42:20 UTC+2 schreef Kamran (Google Cloud Support):

Hello Lieven,

As described in this article:

You can use the failover replica as a read replica, to offload read operations from the master.

For more information about creating read replicas, see Configuring Replication.

I hope this helps.

Sincerely,

On Saturday, June 17, 2017 at 3:34:52 PM UTC-4, Lieven Janssen wrote:

How can I use my failover replica as a read replica?

Can't seem to find any info or setting to turn this on.

--
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+unsub...@googlegroups.com.

[Vadim Berezniker]

Yes, that's right. You have to connect separately to the read replica if you want to offload some queries.

On Tue, Jun 20, 2017 at 9:17 PM Lieven Janssen <lie...@salesflare.com> wrote:

Hi Vadim,

I expected that it would autoatically be a read replica for our end users (through API) as well to ease the load on our main db but I only saw one active connection. Do we need to set up a seperate db connection for all selects we do on the db from our API?

L.

On Monday, 19 June 2017 22:09:52 UTC+2, Vadim Berezniker wrote:

A failover replica is fully usable as a read replica. 

What errors do you see when you try to connect to it?

On Mon, Jun 19, 2017 at 6:16 AM Lieven Janssen <lie...@salesflare.com> wrote:

Hi Kamran,

I read this in the documentation but if I create a failover replica it doesn't allow me to use it as a read replica. Do you suggest creating a read replica instead of a failover replica? Will a read replica also be used as a failover when there is an outage of the master?

Best Regards,

Lieven

Op zaterdag 17 juni 2017 23:42:20 UTC+2 schreef Kamran (Google Cloud Support):

Hello Lieven,

As described in this article:

You can use the failover replica as a read replica, to offload read operations from the master.

For more information about creating read replicas, see Configuring Replication.

I hope this helps.

Sincerely,

On Saturday, June 17, 2017 at 3:34:52 PM UTC-4, Lieven Janssen wrote:

How can I use my failover replica as a read replica?

Can't seem to find any info or setting to turn this on.

--
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-d...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/5c734c08-0b05-47e3-b4e3-1bc4a0751fd4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e6da3220-3308-4353-a46e-03947bd9ecdb%40googlegroups.com.