[google-cloud-sql-discuss] Re: lamp stack, set the mysql server… log_bin=ON

Hi,

If I understand properly, you are attempting a replication (from ___, external? Which provider?) to Cloud SQL and you cannot turn on binary logs with Google.

Since Cloud SQL is a managed service, you will be restricted from certain accesses. For example, superuser is disabled and to turn on binlogs, you do it according to these[1] instructions.

If you have further issues after this, please link us the official article of the replication process at the source database. Without that, it's hard to tell if we are following standard procedure. From our end, the official procedure looks like this[2], make sure you're not missing any official steps from both providers.

[1] https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#enablingpitr

[2] https://cloud.google.com/sql/docs/mysql/replication/replication-from-external

On Tuesday, November 17, 2020 at 12:03:10 PM UTC-5 dac...@gmail.com wrote:

Hi i have a lamp stack and wish to migrate database to cloud sql. I have managed to set the server_id  to 1 and gtid_mode. ON 

however cant resolve this is the error.

mysql> SET GLOBAL log_bin=ON ; ERROR 1238 (HY000): Variable 'log_bin' is a read only variable

I create the replica but recieve this error ...   unable to connect to source database server.

I am assuming that it is because log_bin is OFF.

thanks mulilo

--
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/87573284-07ff-4153-acf6-83565725ff06n%40googlegroups.com.