lamp stack, set the mysql server… log_bin=ON

269 views
Skip to first unread message

Mulilo Chuula

unread,
Nov 17, 2020, 12:03:10 PM11/17/20
to Google Cloud SQL discuss
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


Alexis (Google Cloud Support)

unread,
Nov 19, 2020, 1:28:35 PM11/19/20
to Google Cloud SQL discuss
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.

Reply all
Reply to author
Forward
0 new messages