Sample Header Ad - 728x90

mysql unable to start with semi sync parameter

0 votes
0 answers
602 views
Im using mysql 5.7 and it has 2 slaves with GTID. I tried to enable semi-sync and I have done with set global variable in mysql prompt. It was running fine. Then I did a restart, after that mysql unable to start and it says unknown variable 'rpl-semi-sync-master-enabled=1' ## mysql log 2018-11-03T08:28:35.453089Z 5 [Note] Start binlog_dump to master_thread_id(5) slave_server(2), pos(, 4) 2018-11-03T08:28:35.453119Z 5 [Note] Start asynchronous binlog_dump to slave (server_id: 2), pos(, 4) 2018-11-03T08:28:35.793103Z 6 [Note] Start binlog_dump to master_thread_id(6) slave_server(3), pos(, 4) 2018-11-03T08:28:35.793141Z 6 [Note] Start semi-sync binlog_dump to slave (server_id: 3), pos(, 4) 2018-11-03T08:29:25.656749Z 0 [Note] Giving 5 client threads a chance to die gracefully 2018-11-03T08:29:25.656793Z 0 [Note] Shutting down slave threads 2018-11-03T08:29:33.658167Z 5 [Note] Stop asynchronous binlog_dump to slave (server_id: 2) 2018-11-03T08:29:33.658360Z 6 [Note] Stop semi-sync binlog_dump to slave (server_id: 3) 2018-11-03T08:29:35.658275Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-11-03T08:29:35.658368Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-11-03T08:29:35.658532Z 0 [Note] Binlog end 2018-11-03T08:29:35.662977Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave' 2018-11-03T08:29:35.663025Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master' 2018-11-03T08:29:35.663059Z 0 [Note] unregister_replicator OK 2018-11-03T08:29:35.663062Z 0 [Note] Shutting down plugin 'auth_socket' ## syslog: Nov 3 04:11:17 mysql-systemd-start: ERROR: Unable to start MySQL server: Nov 3 04:11:17 mysql-systemd-start: 2018-11-03T04:11:17.961175Z 0 [ERROR] unknown variable 'rpl-semi-sync-master-enabled=1' Nov 3 04:11:17 mysql-systemd-start: 2018-11-03T04:11:17.964899Z 0 [ERROR] Aborting ## Update: I used the lines then it worked. But what is the use of these parameters? loose-rpl_semi_sync_master_enabled = 1 loose-rpl_semi_sync_slave_enabled = 1
Asked by TheDataGuy (1986 rep)
Nov 3, 2018, 08:34 AM
Last activity: Nov 3, 2018, 08:47 AM