Now that you are fully armed with the basic understanding of physical and theoretical limitations, it is time to learn about different types of replication.
The first distinction we can make is whether to replicate synchronously or asynchronously.
What does this mean? Let us assume we have two servers and we want to replicate data from one server (the master) to the second server (the slave). The following diagram illustrates the concept of synchronous and asynchronous replication:
We could use a simple transaction like the one shown in the listing:
BEGIN: INSERT INTO foo VALUES ...