[root@ovaistariq-test node1]# cat my.sandbox.cnf
# The MySQL Sandbox
# Copyright (C) 2006-2012 Giuseppe Maxia
# Contacts: http://datacharmer.org
#
# 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
# MERCHANTABILITY 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
[mysql]
prompt='slave1 [\h] {\u} (\d) > '
#
[client]
user = msandbox
password = msandbox
port = 23390
socket = /tmp/mysql_sandbox23390.sock
MySQL configuration on slave:
[root@ovaistari q-test node1]# cat my.sandbox.cnf datacharmer. org
# The MySQL Sandbox
# Copyright (C) 2006-2012 Giuseppe Maxia
# Contacts: http://
#
# 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
# MERCHANTABILITY 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
[mysql]
prompt='slave1 [\h] {\u} (\d) > '
#
[client] sandbox23390. sock
user = msandbox
password = msandbox
port = 23390
socket = /tmp/mysql_
[mysqld] sandbox23390. sock percona- server/ 5.5.34 /rsandbox_ ps_5_5_ 34/node1/ data /rsandbox_ ps_5_5_ 34/node1/ tmp /rsandbox_ ps_5_5_ 34/node1/ data/mysql_ sandbox23390. pid /rsandbox_ ps_5_5_ 34/node1/ data/msandbox- slow.log /rsandbox_ ps_5_5_ 34/node1/ data/msandbox. log host=SBslave1 msandbox. err
user = root
port = 23390
socket = /tmp/mysql_
basedir = /work/binaries/
datadir = /work/sandboxes
tmpdir = /work/sandboxes
pid-file = /work/sandboxes
#log-slow-queries = /work/sandboxes
#log = /work/sandboxes
#
# additional options passed through 'my_clause'
#
server-id=101
report-
report-port=23390
log-bin=mysql-bin
log-error=