Comment 2 for bug 1251691

Revision history for this message
Ovais Tariq (ovais-tariq) wrote :

MySQL configuration on slave:

[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

[mysqld]
user = root
port = 23390
socket = /tmp/mysql_sandbox23390.sock
basedir = /work/binaries/percona-server/5.5.34
datadir = /work/sandboxes/rsandbox_ps_5_5_34/node1/data
tmpdir = /work/sandboxes/rsandbox_ps_5_5_34/node1/tmp
pid-file = /work/sandboxes/rsandbox_ps_5_5_34/node1/data/mysql_sandbox23390.pid
#log-slow-queries = /work/sandboxes/rsandbox_ps_5_5_34/node1/data/msandbox-slow.log
#log = /work/sandboxes/rsandbox_ps_5_5_34/node1/data/msandbox.log
#
# additional options passed through 'my_clause'
#
server-id=101
report-host=SBslave1
report-port=23390
log-bin=mysql-bin
log-error=msandbox.err