Understanding Replication In MySQL

March 17, 2024 · 1328 words · 7 min

MySQL Replication is a process where data from one MySQL database known as the master is copied over to one or more other databases called replicas or slaves. In this article, we’ll learn what replication is, how to enable replication, replication modes and replication forms.

Understanding MVCC In MySQL InnoDB

March 9, 2024 · 1335 words · 7 min

In MySQL, MVCC (Multi-Version Concurrency Control) refers to the concurrency control mechanism used by the InnoDB storage engine. It provides concurrent access to data and ensures data consistency and isolation in a multi-user environment.