jetpants icon indicating copy to clipboard operation
jetpants copied to clipboard

Support cloning a slave from an online master

Open nevermort opened this issue 7 years ago • 2 comments

Hi guys. Thx for u'r great soft. Tell me pls, is there a solution in jetpants for adding (not clone) slave for single master (without any other slaves). (maybe, by using Percona XtraBackup or some other "hot" backup utilities)? I didn't find any stuff like this in jetpants.

nevermort avatar May 24 '17 15:05 nevermort

Jetpants doesn't have support for hot-copy yet, but it is high on the priority list. Most likely it will wrap xtrabackup for this purpose.

Currently though all cloning is cold-copy, meaning the source mysqld is shut down and a physical file copy is performed. This is why the CLI's jetpants clone_slave command currently only allows cloning standby replicas. You can clone a master or read replica via jetpants console by running Ruby code, but this is a disruptive process since the source instance needs to be shut down.

evanelias avatar May 24 '17 17:05 evanelias

Thanks for answer. We will expect from you even more excellent solutions and approaches (especially about hot backup process). My best regards!

nevermort avatar May 25 '17 04:05 nevermort