Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

Query Matched Man Text

Linux 2.6 - man page for mysqlserverclone (debian section 1)

MYSQLSERVERCLONE(1)						  MySQL Utilities					       MYSQLSERVERCLONE(1)

NAME
mysqlserverclone - Start a new instance of an existing MySQL server
SYNOPSIS
mysqlserverclone [options]
DESCRIPTION
This utility permits an administrator to clone an existing MySQL server instance to start a new server instance on the same host. The utility creates a new datadir (--new-data), and starts the server with a socket file. You can optionally add a password for the login user account on the new instance.
OPTIONS
mysqlserverclone accepts the following command-line options: --help Display a help message and exit. --mysqld=<options> Additional options for mysqld. To specify multiple options, separate them by spaces. Use appropriate quoting as necessary. For exam- ple, to specify --log-bin=binlog and --general-log-file="my log file", use: --mysqld="--log-bin=binlog --general-log-file='my log file'" --new-data=<path_to_new_datadir> The full path name of the location of the data directory for the new server instance. If the directory does not exist, the utility will create it. --new-id=<server_id> The server_id value for the new server instance. The default is 2. --new-port=<port> The port number for the new server instance. The default is 3307. --quiet, -q Turn off all messages for quiet execution. --root-password=<password> The password for the root user of the new server instance. --server=<source> Connection information for the server to be cloned in <user>[:<passwd>]@<host>[:<port>][:<socket>] format. --verbose, -v Specify how much information to display. Use this option multiple times to increase the amount of information. For example, -v = verbose, -vv = more verbose, -vvv = debug. --version Display version information and exit. --write-command=<file_name>, -w<file_name> Path name of file in which to write the command used to launch the new server instance.
EXAMPLES
The following command demonstrates how to create a new instance of a running server, set the root user password and enable binary logging: $ mkdir /source/test123 $ mysqlserverclone --server=root:pass@localhost --new-data=/Users/cbell/source/test123 --new-port=3310 --root-password=pass --mysqld=--log-bin=mysql-bin # Cloning the MySQL server running on localhost. # Creating new data directory... # Configuring new instance... # Locating mysql tools... # Setting up empty database and mysql tables... # Starting new instance of the server... # Testing connection to new instance... # Success! # Setting the root password... # ...done.
COPYRIGHT
Copyright (c) 2010, 2012, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER- CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
AUTHOR
MySQL Utilities Team
COPYRIGHT
2010, Oracle and/or its affiliates. All rights reserved. 1.0.3 May 09, 2012 MYSQLSERVERCLONE(1)

Featured Tech Videos