1. How to setup a replication slave with TwinDB Backup tool

How to setup a replication slave with TwinDB Backup tool

Setting up a replication slave is pretty straightforward, yet cumbersome process that needs a lot of attention to details. Look, even if the six steps are simple, together they constitute something I cannot call simple.

We decided to fix that. Our TwinDB Backup tool can take backups, can restore them, can copy files over the network. If we put that together we can get a one line command to fire up a replica from a live master. And we did it in the recent TwinDB Backup release.

To clone a server twindb-backup runs XtraBackup on the Master. It streams the backup copy directly to the Slave.

For files transfer over the network it starts netcat server on the Slave on TCP port 9990 by default.

After the copy lands to the Slave twindb-backup applies the XtrbaBackup redo log, fixes server_id, starts MySQL and configures replication.

That I call simple.

However the most useful application of this feature comes probably with the twindb-backup python module.

The module can be used in your MySQL automation framework.

So, check it out and let us know what you think. We distribute twindb-backup packages via TwinDB Software Repository. The source code is traditionally on GitHub.

Previous Post Next Post