Quorum based approach can also provide availability as even if some nodes are not available, system still will be able to response with the available nodes result.
i think MySQL prioritizes consistency over availability in case of network partitions. Suppose it's a master-slave replication with synchronous replication, if the master fails, the system may block writes to ensure consistency
Thanks, It is the Best article I have read about CAP THEOREM.
Quorum based approach can also provide availability as even if some nodes are not available, system still will be able to response with the available nodes result.
Ashish , I think MY SQL database follow the tradeoffs of "CA" , you mentioned it in the wrong category of (CP). Kindly correct it.
i think MySQL prioritizes consistency over availability in case of network partitions. Suppose it's a master-slave replication with synchronous replication, if the master fails, the system may block writes to ensure consistency