1MK-SLAVE-MOVE(1) User Contributed Perl Documentation MK-SLAVE-MOVE(1)
2
6 mk-slave-move - Move a MySQL slave around in the replication hierarchy.
7
9 Usage: mk-slave-move [OPTION...] SLAVE_DSN [DSN...]
10 mk-slave-move moves replication slave(s) around in the hierarchy.
12 Examples:
14 mk-slave-move slave --sibling-of-master
16 mk-slave-move slave --slave-of-sibling sibling
18 mk-slave-move slave --slave-of-uncle uncle
20
22 The following section is included to inform users about the potential
23 risks, whether known or unknown, of using this tool. The two main
24 categories of risks are those created by the nature of the tool (e.g.
25 read-only tools vs. read-write tools) and those created by bugs.
26 mk-slave-move is a read-write tool by default. It manipulates
28 replication settings. Some of the features are incomplete, including
29 some safety checks such as not moving slaves that have temporary tables
30 open.
31 At the time of this release, we know of no bugs that could cause
33 serious harm to users.
34 The authoritative source for updated information is always the online
36 issue tracking system. Issues that affect this tool will be marked as
37 such. You can see a list of such issues at the following URL:
38 <http://www.maatkit.org/bugs/mk-slave-move>.
39 See also "BUGS" for more information on filing bugs and getting help.
41
43 This tool knows how to disconnect and reconnect slaves to each other,
44 compare replication positions, and so on. This makes it able to move a
45 slave around the replication hierarchy safely and correctly. It
46 doesn't do anything you can't do by hand, but it is tedious and error-
47 prone to do this by hand.
48 The hosts are given by a DSN. A DSN is a special syntax that can be
50 either just a hostname (like "server.domain.com" or 1.2.3.4), or a
51 "key=value,key=value" string. Keys are a single letter:
52 KEY MEANING
54 === =======
55 h Connect to host
56 P Port number to use for connection
57 S Socket file to use for connection
58 u User for login if not current user
59 p Password to use when connecting
60 F Only read default options from the given file
61 If you omit any values in the sibling or uncle host, they are filled in
63 with defaults from the slave host, so you don't need to specify them in
64 both places. "mk-slave-move" reads all normal MySQL option files, such
65 as ~/.my.cnf, so you may not need to specify username, password and
66 other common options at all.
67
69 An exit status of 0 (sometimes also called a return value or return
70 code) indicates success. Any other value represents the exit status of
71 the Perl process itself.
72
74 Specify one and only one of "--sibling-of-master",
75 "--slave-of-sibling", "--slave-of-uncle", or "--detach".
76 This tool accepts additional command-line arguments. Refer to the
78 "SYNOPSIS" and usage information for details.
79 --ask-pass
81 Prompt for a password when connecting to MySQL.
82 --charset
84 short form: -A; type: string
85 Default character set. If the value is utf8, sets Perl's binmode
87 on STDOUT to utf8, passes the mysql_enable_utf8 option to
88 DBD::mysql, and runs SET NAMES UTF8 after connecting to MySQL. Any
89 other value sets binmode on STDOUT without the utf8 layer, and runs
90 SET NAMES after connecting to MySQL.
91 --config
93 type: Array
94 Read this comma-separated list of config files; if specified, this
96 must be the first option on the command line.
97 --defaults-file
99 short form: -F; type: string
100 Only read mysql options from the given file. You must give an
102 absolute pathname.
103 --detach
105 Make this server forget that it is a slave.
106 --help
108 Show help and exit.
109 --host
111 short form: -h; type: string
112 Connect to host.
114 --password
116 short form: -p; type: string
117 Password to use when connecting.
119 --pid
121 type: string
122 Create the given PID file. The file contains the process ID of the
124 script. The PID file is removed when the script exits. Before
125 starting, the script checks if the PID file already exists. If it
126 does not, then the script creates and writes its own PID to it. If
127 it does, then the script checks the following: if the file contains
128 a PID and a process is running with that PID, then the script dies;
129 or, if there is no process running with that PID, then the script
130 overwrites the file with its own PID and starts; else, if the file
131 contains no PID, then the script dies.
132 --port
134 short form: -P; type: int
135 Port number to use for connection.
137 --set-vars
139 type: string; default: wait_timeout=10000
140 Set these MySQL variables. Immediately after connecting to MySQL,
142 this string will be appended to SET and executed.
143 --sibling-of-master
145 Make the server a slave of its grandparent, so it is a sibling of
146 its master.
147 The procedure is as follows:
149 1. Connect to the server's master.
151 2. Stop the slave processes on the master.
152 3. Wait for the server to catch up to its master in replication.
153 4. Point the slave to the master's master.
154 --slave-of-sibling
156 Make the server a slave of one of its siblings. Specify the
157 sibling as a DSN.
158 The procedure is as follows:
160 1. Connect to the sibling and verify that it has the same master.
162 2. Stop the slave processes on the server and its sibling.
163 3. If one of the servers is behind the other, make it catch up.
164 4. Point the slave to its sibling.
165 --slave-of-uncle
167 Make the server a slave of one of its uncles (parent's siblings).
168 Specify the uncle as a DSN.
169 An "uncle" is a sibling of the server's master. The procedure is
171 as follows:
172 1. Connect to the slave's master and its uncle, and verify that both have the
174 same master. (Their common master is the slave's grandparent).
175 2. Stop the slave processes on the master and uncle.
176 3. If one of them is behind the other, make it catch up.
177 4. Point the slave to its uncle.
178 --socket
180 short form: -S; type: string
181 Socket file to use for connection.
183 --timeout
185 type: time; default: 10m
186 Timeout when waiting for replication to catch up.
188 --user
190 short form: -u; type: string
191 User for login if not current user.
193 --version
195 Show version and exit.
196
198 These DSN options are used to create a DSN. Each option is given like
199 "option=value". The options are case-sensitive, so P and p are not the
200 same option. There cannot be whitespace before or after the "=" and if
201 the value contains whitespace it must be quoted. DSN options are
202 comma-separated. See the maatkit manpage for full details.
203 · A
205 dsn: charset; copy: yes
207 Default character set.
209 · D
211 dsn: database; copy: yes
213 Default database.
215 · F
217 dsn: mysql_read_default_file; copy: yes
219 Only read default options from the given file
221 · h
223 dsn: host; copy: yes
225 Connect to host.
227 · p
229 dsn: password; copy: yes
231 Password to use when connecting.
233 · P
235 dsn: port; copy: yes
237 Port number to use for connection.
239 · S
241 dsn: mysql_socket; copy: yes
243 Socket file to use for connection.
245 · u
247 dsn: user; copy: yes
249 User for login if not current user.
251
253 You can download Maatkit from Google Code at
254 <http://code.google.com/p/maatkit/>, or you can get any of the tools
255 easily with a command like the following:
256 wget http://www.maatkit.org/get/toolname
258 or
259 wget http://www.maatkit.org/trunk/toolname
260 Where "toolname" can be replaced with the name (or fragment of a name)
262 of any of the Maatkit tools. Once downloaded, they're ready to run; no
263 installation is needed. The first URL gets the latest released version
264 of the tool, and the second gets the latest trunk code from Subversion.
265
267 The environment variable "MKDEBUG" enables verbose debugging output in
268 all of the Maatkit tools:
269 MKDEBUG=1 mk-....
271
273 You need Perl, DBI, DBD::mysql, and some core packages that ought to be
274 installed in any reasonably new version of Perl.
275
277 For a list of known bugs see
278 <http://www.maatkit.org/bugs/mk-slave-move>.
279 Please use Google Code Issues and Groups to report bugs or request
281 support: <http://code.google.com/p/maatkit/>. You can also join
282 #maatkit on Freenode to discuss Maatkit.
283 Please include the complete command-line used to reproduce the problem
285 you are seeing, the version of all MySQL servers involved, the complete
286 output of the tool when run with "--version", and if possible,
287 debugging output produced by running with the "MKDEBUG=1" environment
288 variable.
289
291 This program is copyright 2007-2011 Baron Schwartz. Feedback and
292 improvements are welcome.
293 THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
295 WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
296 MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
297 This program is free software; you can redistribute it and/or modify it
299 under the terms of the GNU General Public License as published by the
300 Free Software Foundation, version 2; OR the Perl Artistic License. On
301 UNIX and similar systems, you can issue `man perlgpl' or `man
302 perlartistic' to read these licenses.
303 You should have received a copy of the GNU General Public License along
305 with this program; if not, write to the Free Software Foundation, Inc.,
306 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
307
309 See also mk-table-checksum, mk-table-sync, mk-slave-delay.
310
312 Baron Schwartz
313
315 This tool is part of Maatkit, a toolkit for power users of MySQL.
316 Maatkit was created by Baron Schwartz; Baron and Daniel Nichter are the
317 primary code contributors. Both are employed by Percona. Financial
318 support for Maatkit development is primarily provided by Percona and
319 its clients.
320
322 This manual page documents Ver 0.9.12 Distrib 7540 $Revision: 7531 $.
323perl v5.30.0 2019-07-25 MK-SLAVE-MOVE(1)