ports/189257: [NEW PORT] databases/percona56-xtradb-cluster
John Ko
john at johnko.ca
Mon May 26 01:00:01 UTC 2014
The following reply was made to PR ports/189257; it has been noted by GNATS.
From: John Ko <john at johnko.ca>
To: Daniel Ylitalo <daniel at blodan.se>
Cc: "bug-followup at FreeBSD.org" <bug-followup at freebsd.org>
Subject: Re: ports/189257: [NEW PORT] databases/percona56-xtradb-cluster
Date: Sun, 25 May 2014 20:53:59 -0400
--047d7b5d3eecc6e1b704fa4303e2
Content-Type: text/plain; charset=UTF-8
Oops just found out my umask was 077... which means my /server/mysql/data
didn't let galera write to it
it appears to work now:
# pgrep -lf mysql
64880 /usr/local/libexec/mysqld --defaults-extra-file=/server/mysql/my.cnf
--basedir=/usr/local --datadir=/server/mysql/data
--plugin-dir=/usr/local/lib/mysql/plugin --user=mysql
--log-error=/server/mysql/data/NXQCSO-NXQCSO.err
--pid-file=/server/mysql/data/NXQCSO-NXQCSO.pid
--wsrep_start_position=00000000-0000-0000-0000-000000000000:-1
64249 /bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/server/mysql/my.cnf --user=mysql
--datadir=/server/mysql/data --pid-file=/server/mysql/data/NXQCSO-NXQCSO.pid
--
John
_
On Sun, May 25, 2014 at 8:50 PM, John Ko <john at johnko.ca> wrote:
> Looks like I can't even boot up the first node:
>
> More in my gist here:
> https://gist.github.com/johnko/f22c87931e31246598eb
>
> # grep mysql /etc/rc.conf
> mysql_limits="YES"
> mysql_dbdir="/server/mysql/data"
> mysql_optfile="/server/mysql/my.cnf"
> mysql_enable="YES"
> mysql_args=""
>
> #####
>
> # cat /server/mysql/my.cnf
> [mysqld]
> datadir = /server/mysql/data
> tmpdir = /server/mysql/tmp
> log-error = /var/log/mysql-error.log
> slow-query-log-file = /var/log/mysql-slow.log
> port = 3306
> innodb_autoinc_lock_mode = 2
> wsrep_sst_method = xtrabackup-v2
> wsrep_provider = /usr/local/lib/libgalera_smm.so
> wsrep_provider_options = "gmcast.listen_addr=tcp://127.0.0.1:4567"
> wsrep_cluster_name = mycluster
> wsrep_node_name = NXQCSO-NXQCSO
> wsrep_node_address = 127.0.0.1
> wsrep_slave_threads = 8
> wsrep_sst_auth = "sst:25awfaSADF4toih4t"
> server-id = 1
> wsrep_cluster_address=gcomm://
>
>
>
--047d7b5d3eecc6e1b704fa4303e2
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">Oops just found out my umask was 077... which means my /se=
rver/mysql/data didn't let galera write to it<div><br></div><div>it app=
ears to work now:</div><div><br></div><div>
<p class=3D""><span class=3D"">#</span> pgrep -lf mysql</p>
<p class=3D"">64880 /usr/local/libexec/mysqld --defaults-extra-file=3D/serv=
er/mysql/my.cnf --basedir=3D/usr/local --datadir=3D/server/mysql/data --plu=
gin-dir=3D/usr/local/lib/mysql/plugin --user=3Dmysql --log-error=3D/server/=
mysql/data/NXQCSO-NXQCSO.err --pid-file=3D/server/mysql/data/NXQCSO-NXQCSO.=
pid --wsrep_start_position=3D00000000-0000-0000-0000-000000000000:-1</p>
<p class=3D"">64249 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-fil=
e=3D/server/mysql/my.cnf --user=3Dmysql --datadir=3D/server/mysql/data --pi=
d-file=3D/server/mysql/data/NXQCSO-NXQCSO.pid</p></div><div class=3D"gmail_=
extra">
<br clear=3D"all"><div><div dir=3D"ltr">--<br>John<br>_<br></div></div>
<br><br><div class=3D"gmail_quote">On Sun, May 25, 2014 at 8:50 PM, John Ko=
<span dir=3D"ltr"><<a href=3D"mailto:john at johnko.ca" target=3D"_blank">=
john at johnko.ca</a>></span> wrote:<br><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir=3D"ltr"><div class=3D"gmail_extra">Looks like I can't even boo=
t up the first node:</div><div class=3D"gmail_extra"><br></div><div class=
=3D"gmail_extra">More in my gist here:</div><div class=3D"gmail_extra"><a h=
ref=3D"https://gist.github.com/johnko/f22c87931e31246598eb" target=3D"_blan=
k">https://gist.github.com/johnko/f22c87931e31246598eb</a><br>
</div><div class=3D"gmail_extra"><br></div><div class=3D"gmail_extra">
<p># grep mysql /etc/rc.conf<br><span>mysql</span>_limits=3D"YES"=
<br><span>mysql</span>_dbdir=3D"/server/<span>mysql</span>/data"<=
br><span>mysql</span>_optfile=3D"/server/<span>mysql</span>/my.cnf&quo=
t;<br>
<span>mysql</span>_enable=3D"YES"<br><span>mysql</span>_args=3D&q=
uot;"</p><p>#####</p><p>
</p><p><span>#</span>=C2=A0cat /server/mysql/my.cnf<br>[mysqld]<br>datadir=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /server/mysql/data<br>=
tmpdir =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /server/mysql/t=
mp<br>log-error=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /var/log/mysql=
-error.log<br>
slow-query-log-file=C2=A0 =3D /var/log/mysql-slow.log<br>port =C2=A0 =C2=A0=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D 3306<br>innodb_autoinc_lock_=
mode =3D 2<br>wsrep_sst_method =C2=A0 =C2=A0 =C2=A0 =3D xtrabackup-v2<br>ws=
rep_provider =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /usr/local/lib/libgalera_smm.s=
o<br>wsrep_provider_options =3D "gmcast.listen_addr=3Dtcp://<a href=3D=
"http://127.0.0.1:4567" target=3D"_blank">127.0.0.1:4567</a>"<br>
wsrep_cluster_name =C2=A0 =C2=A0 =3D mycluster<br>wsrep_node_name=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =3D NXQCSO-NXQCSO<br>wsrep_node_address =C2=A0 =C2=A0 =3D=
127.0.0.1<br>wsrep_slave_threads=C2=A0 =C2=A0 =3D 8<br>wsrep_sst_auth =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =3D "sst:25awfaSADF4toih4t"<br>server-id=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D 1<br>
wsrep_cluster_address=3Dgcomm://</p><p><br></p></div></div>
</blockquote></div><br></div></div>
--047d7b5d3eecc6e1b704fa4303e2--
More information about the freebsd-ports-bugs
mailing list