MySQL5.7版本MGR启动时报:
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.
查看告警日志:
2020-03-04T07:48:58.797180Z 574478 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is
added.'2020-03-04T07:48:58.844857Z 574714 [ERROR] Slave SQL for channel 'group_replication_applier': Error 'This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its d
eclaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)' on query. Default database: ''. Query: 'CREATE DEFINER=`root`@`192.168.187.%` FUNCTION `GetDistance`(`lat1` float,`lng1` float,`lat2` float,`lng2` float) RETURNS floatbegin
DECLARE earth_padius float DEFAULT 6378.137;
DECLARE radLat1 float DEFAULT 0;
DECLARE radLat2 float DEFAULT 0;
DECLARE a float DEFAULT 0;
DECLARE b float DEFAULT 0;
DECLARE s float DEFAULT 0;
set radLat1 = Radian(lat1);
set radLat2 = Radian(lat2);
set a = radLat1 - radLat2;
set b = Radian(lng1) - Radian(lng2);
set s = 2 *
Asin(Sqrt(power(sin(a / 2), 2)