Comments - Setting Up Replication

4 years, 2 months ago Juan Vera

You actually can use a "blank" slave and set it up to replicate every event that has happened on the master since the was blank too. Although technically possible, this would require that you 1) can identify the exact transaction on the master that was equivalent to the clean slave's current state, 2) have saved all the binary logs on the master from that blank state up to the present, and 3) have the time to replay the master's transaction history on the slave.

So your intuition is correct. It's just that practically speaking, letting the slave replay the master's transaction history from installation forward is a lot more difficult and time-consuming than starting from a recent backup.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.