Tuesday, November 17, 2020

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

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/2debf88f-97fd-4271-9778-3627bdcdf82an%40googlegroups.com.

No comments:

Post a Comment