#24 System Design - CAP Theorem
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
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