In Primary Node: Your MySQL connection id is 93 Server version: 8.0.18 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show master status\G *************************** 1. row *************************** File: phy-30-22-upsql-bin.000003 Position: 4631 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 0843ba7b-0d7d-41dd-90ab-753bd6e00b8f:1-9 1 row in set (0.00 sec) mysql> select * from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | group_replication_applier | 2801ad3c-0b92-11ea-a766-a0369fadeca0 | phy-30-22 | 60014 | ONLINE | PRIMARY | 8.0.18 | | group_replication_applier | 960c1ce2-0b92-11ea-a8d7-9cb6548b20c0 | phy6313 | 60014 | ONLINE | SECONDARY | 8.0.18 | | group_replication_applier | 9a1b07da-0b92-11ea-a310-9cb6548b1098 | phy6320 | 60014 | ONLINE | SECONDARY | 8.0.18 | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ 3 rows in set (0.01 sec) mysql> show create function sys.ifzero; +----------+-----------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | Function | sql_mode | Create Function | character_set_client | collation_connection | Database Collation | +----------+-----------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ | IFZERO | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | CREATE DEFINER=`dba`@`localhost` FUNCTION `IFZERO`(a INT, b INT) RETURNS int(11) DETERMINISTIC RETURN IF(a = 0, b, a) | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | +----------+-----------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+--------------------+ 1 row in set (0.00 sec) binlog is like: SET @@SESSION.GTID_NEXT= '0843ba7b-0d7d-41dd-90ab-753bd6e00b8f:2'/*!*/; # at 233 #191120 20:36:05 server id 13201 end_log_pos 295 Query thread_id=11 exec_time=23 error_code=0 SET TIMESTAMP=1574253365/*!*/; SET @@session.pseudo_thread_id=11/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1168113696/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8mb4 *//*!*/; SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/; BEGIN /*!*/; # at 295 #191120 20:36:05 server id 13201 end_log_pos 434 View_change_log_event: view_id=15742533677789734:2 # at 434 #191120 20:36:05 server id 13201 end_log_pos 502 Query thread_id=11 exec_time=23 error_code=0 SET TIMESTAMP=1574253365/*!*/; COMMIT /*!*/; # at 502 #191120 20:39:49 server id 13201 end_log_pos 584 GTID last_committed=1 sequence_number=2 rbr_only=no original_committed_timestamp=1574253589999659 immediate_commit_timestamp=1574253590001518 transaction_ length=298 # original_commit_timestamp=1574253589999659 (2019-11-20 20:39:49.999659 CST) # immediate_commit_timestamp=1574253590001518 (2019-11-20 20:39:50.001518 CST) /*!80001 SET @@session.original_commit_timestamp=1574253589999659*//*!*/; /*!80014 SET @@session.original_server_version=80018*//*!*/; /*!80014 SET @@session.immediate_server_version=80018*//*!*/; SET @@SESSION.GTID_NEXT= '0843ba7b-0d7d-41dd-90ab-753bd6e00b8f:3'/*!*/; # at 584 #191120 20:39:49 server id 13201 end_log_pos 800 Query thread_id=91 exec_time=0 error_code=0 Xid = 58 use `sys`/*!*/; SET TIMESTAMP=1574253589/*!*/; CREATE DEFINER=`dba`@`localhost` FUNCTION `IFZERO`(a INT, b INT) RETURNS int(11) DETERMINISTIC RETURN IF(a = 0, b, a) /*!*/; # at 800 #191120 20:39:53 server id 13201 end_log_pos 882 GTID last_committed=2 sequence_number=3 rbr_only=no original_committed_timestamp=1574253593004622 immediate_commit_timestamp=1574253593006036 transaction_ length=386 In Secondary Node: Server version: 8.0.18 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select * from performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | MEMBER_ROLE | MEMBER_VERSION | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ | group_replication_applier | 2801ad3c-0b92-11ea-a766-a0369fadeca0 | phy-30-22 | 60014 | ONLINE | PRIMARY | 8.0.18 | | group_replication_applier | 960c1ce2-0b92-11ea-a8d7-9cb6548b20c0 | phy6313 | 60014 | ONLINE | SECONDARY | 8.0.18 | | group_replication_applier | 9a1b07da-0b92-11ea-a310-9cb6548b1098 | phy6320 | 60014 | ONLINE | SECONDARY | 8.0.18 | +---------------------------+--------------------------------------+-------------+-------------+--------------+-------------+----------------+ 3 rows in set (0.00 sec) mysql> show master status\G *************************** 1. row *************************** File: phy6313-upsql-bin.000003 Position: 4629 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 0843ba7b-0d7d-41dd-90ab-753bd6e00b8f:1-8 1 row in set (0.00 sec) mysql> show create function sys.ifzero; ERROR 1305 (42000): FUNCTION ifzero does not exist mysql> binlog is just like: SET @@SESSION.GTID_NEXT= '0843ba7b-0d7d-41dd-90ab-753bd6e00b8f:2'/*!*/; # at 233 #191120 20:36:05 server id 13201 end_log_pos 295 Query thread_id=11 exec_time=212 error_code=0 SET TIMESTAMP=1574253365/*!*/; SET @@session.pseudo_thread_id=11/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1168113696/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8mb4 *//*!*/; SET @@session.character_set_client=255,@@session.collation_connection=255,@@session.collation_server=255/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; /*!80011 SET @@session.default_collation_for_utf8mb4=255*//*!*/; BEGIN /*!*/; # at 295 #191120 20:36:05 server id 13201 end_log_pos 434 View_change_log_event: view_id=15742533677789734:2 # at 434 #191120 20:36:05 server id 13201 end_log_pos 502 Query thread_id=11 exec_time=212 error_code=0 SET TIMESTAMP=1574253365/*!*/; COMMIT /*!*/; # at 502 #191120 20:39:31 server id 17441 end_log_pos 584 GTID last_committed=1 sequence_number=2 rbr_only=no original_committed_timestamp=0 immediate_commit_timestamp=1574253580025882 transaction_length=311 # original_commit_timestamp=0 (1970-01-01 08:00:00.000000 CST) # immediate_commit_timestamp=1574253580025882 (2019-11-20 20:39:40.025882 CST) /*!80001 SET @@session.original_commit_timestamp=0*//*!*/; /*!80014 SET @@session.original_server_version=80018*//*!*/; /*!80014 SET @@session.immediate_server_version=80018*//*!*/; SET @@SESSION.GTID_NEXT= '0843ba7b-0d7d-41dd-90ab-753bd6e00b8f:1'/*!*/; # at 584 #191120 20:39:31 server id 17441 end_log_pos 646 Query thread_id=10 exec_time=9 error_code=0 SET TIMESTAMP=1574253571/*!*/; BEGIN /*!*/; # at 646 #191120 20:39:31 server id 17441 end_log_pos 745 View_change_log_event: view_id=15742533677789734:2 # at 745 #191120 20:39:31 server id 17441 end_log_pos 813 Query thread_id=10 exec_time=9 error_code=0 SET TIMESTAMP=1574253571/*!*/; COMMIT /*!*/; # at 813 #191120 20:39:53 server id 13201 end_log_pos 895 GTID last_committed=2 sequence_number=3 rbr_only=no original_committed_timestamp=1574253593004622 immediate_commit_timestamp=1574253780569800 transaction_ length=386 # original_commit_timestamp=1574253593004622 (2019-11-20 20:39:53.004622 CST) # immediate_commit_timestamp=1574253780569800 (2019-11-20 20:43:00.569800 CST) /*!80001 SET @@session.original_commit_timestamp=1574253593004622*//*!*/; /*!80014 SET @@session.original_server_version=80018*//*!*/; /*!80014 SET @@session.immediate_server_version=80018*//*!*/; SET @@SESSION.GTID_NEXT= '0843ba7b-0d7d-41dd-90ab-753bd6e00b8f:3'/*!*/; # at 895 #191120 20:39:53 server id 13201 end_log_pos 1199 Query thread_id=91 exec_time=187 error_code=0 Xid = 20 use `sys`/*!*/; SET TIMESTAMP=1574253593/*!*/; CREATE DEFINER=`dba`@`localhost` FUNCTION `LOCATE2`(needle TEXT(10000), haystack TEXT(10000), offset INT) RETURNS int(11) DETERMINISTIC RETURN IFZERO(LOCATE(needle, haystack, offset), LENGTH(haystack) + 1) /*!*/; # at 1199 #191120 20:39:53 server id 13201 end_log_pos 1281 GTID last_committed=3 sequence_number=4 rbr_only=no original_committed_timestamp=1574253593007988 immediate_commit_timestamp=1574253780571409 transaction_ length=325