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?
On Fri, Feb 5, 2016 at 11:21 PM, Graphics Geeks <graphicsguru600@gmail.com> wrote:
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?
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/0daad97c-a5d4-48f3-9c7a-717175e9a0c0%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-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bZZfrHZBUafx%2BGZiLq%2BgRdf4jqXP6e1BUx3ifdbwQCQ5A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment