Comments - Start replication with clones?

9 months, 1 week ago Kristian Nielsen

Yes, shutting down and cloning the system will work, and this is a very robust method if you are able to shutdown the server briefly.

You need to set a different server_id in the configuration file of the clone.

You also need to configure the new slave to start replicating from the right point. Using GTID, you can do

    CHANGE MASTER TO master_use_gtid=slave_pos, master_demote_to_slave=1, master_host=...

(Or master_use_gtid=current_pos if you are before MariaDB 10.10).

Otherwise SHOW MASTER STATUS will show the binlog coordinates to start the slave at.

 
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.