Re: [google-cloud-sql-discuss] In Cloud SQL second generation, you do not support point-in-time recovery. So Why binary-logs are so HUGE?

Hi Amina-

As David mentions, point in time recovery is supported for Cloud SQL First Generation instances.  It is not yet supported for Second Generation instances.  Binary logging is required to enable replication (failover or read replicas) on Second Gen instances.  Your existing binary log files can be removed by disabling backups and binary logging.

Thanks,

Brett

On Tuesday, April 26, 2016 at 9:50:24 AM UTC-7, David Newgas wrote:

Hi,

We do support point in time recovery: https://cloud.google.com/sql/docs/backup-recovery#pitr. Binary logs are kept as far back as your oldest backup (7 days).

On Tue, Apr 26, 2016 at 1:05 AM, Amina <aminadavg@gmail.com> wrote:

My DB contains 3GB of data.

The binary log 10GB. 

What do you keep the binary log, after the failover instance replicate the data?

As I understand you do not support point-in-time recovery, so I don't need it. 

Am I right?

How long do you save the binlogs?

--
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/970852e2-0998-4de3-acd7-80eacc4d3a3c%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/7fcd2f1b-4f52-4fe7-9840-916efdec8e92%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.