Cloud Read Replica Not Updating

23 views
Skip to first unread message

Graphics Geeks

unread,
Feb 6, 2016, 2:21:38 AM2/6/16
to Google Cloud SQL discuss
I'm running a first generation sql cloud read replica.

It was my understanding that the replica should update from the master (although being perhaps a few seconds behind)

Nothing is happening. It just sits there costing me money with the same data it had when it was created.

I've enabled binary logging on the master.

Why isn't this doing anything?

David Newgas

unread,
Feb 7, 2016, 2:39:15 PM2/7/16
to Google Cloud SQL discuss
If everything is set up then yes, updates to the master will be replicated to the slave. If you had data on the master before binary logging was turned on, it will not be replicated (which may prevent later updates from being replicated... you generally want to start a slave from a clone of the master).

Could you send the output of SHOW SLAVE STATUS on the slave and both SHOW PROCESSLIST and SHOW BINARY LOGS on the master?

--
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/0daad97c-a5d4-48f3-9c7a-717175e9a0c0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages