On the Master-Slave semi-Synchronize replication Scheme and MHA of mysql Database

won"t there be any problems with mysql"s performance under high concurrency when using master-slave semi-Synchronize replication scheme? After all, semi-Synchronize also has a delay, which will slightly block the thread

in addition, I think there is MHA+Keepalived "s master-slave scheme MHA for failover high availability, but suppose the following scheme: two master, do each other mysql master-slave use keepalived to expose virtual IP, one master backups multiple slave through keepalived external service and the other master backup multiple slave is based on the current service master behind this virtual IP
when a master failure occurs, Another master provides services through keepalived, so it doesn"t have to fail over. Why do you need a MHA?

Apr.23,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e48227-4c395.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e48227-4c395.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?