DELIMITER $$ USE `GSSKeepAlive`$$ DROP PROCEDURE IF EXISTS `sp_GSSKeepAlive`$$ CREATE DEFINER=`xxxxx`@`%` PROCEDURE `sp_GSSKeepAlive`(eid VARCHAR(15)) BEGIN DECLARE my_wsrep_local_state_comment VARCHAR(25); DECLARE my_wsrep_cluster_status VARCHAR(25); DECLARE my_read_only VARCHAR(25); DECLARE my_wsrep_ready VARCHAR(25); SELECT VARIABLE_VALUE INTO my_wsrep_local_state_comment FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_state_comment'; SELECT VARIABLE_VALUE INTO my_wsrep_cluster_status FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_cluster_status'; SELECT VARIABLE_VALUE INTO my_read_only FROM performance_schema.global_variables WHERE VARIABLE_NAME = 'READ_ONLY'; SELECT VARIABLE_VALUE INTO my_wsrep_ready FROM performance_schema.global_status WHERE VARIABLE_NAME = 'wsrep_ready'; IF my_wsrep_local_state_comment='Synced' AND my_wsrep_cluster_status='Primary' AND my_read_only='OFF' AND my_wsrep_ready='ON' THEN SELECT my_wsrep_local_state_comment, my_wsrep_cluster_status, my_read_only, my_wsrep_ready; END IF; END$$ DELIMITER ;