Replication status

SELECT s.MEMBER_HOST,s.MEMBER_ID, s.MEMBER_PORT, s.MEMBER_STATE, case when p.VARIABLE_VALUE=s.MEMBER_ID then 'PRIMARY' else 'SECONDARY' END as MEMBER_ROLE FROM performance_schema.replication_group_members s join performance_schema.global_status p where p.VARIABLE_NAME='group_replication_primary_membe

select id,server_name,backup_Type, status, log, stamp from dbbackup_status where stamp in (SELECT DATE_FORMAT(now(),'%Y-%m-%d')) order by id desc limit 1;