maria-discuss team mailing list archive

[Sylvain Raybaud <sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

On 24/06/2015 14:13, Guillaume Lefranc wrote:
> Hello Sylvain,
> 
> the last lines of the error log of nodes 2 and 3 would be more
> helpful.

Here are the last 20 lines of error log on node #2:
http://pastebin.com/XQduzP18

and node #3: http://pastebin.com/x8dshEph


> Also how do you start your cluster? Do you bootstrap the first
> node correctly then start the two other nodes?

I start the cluster on node #1 with:

/usr/bin/mysqld_safe  --defaults-file=/etc/mysql/my.cnf
- --wsrep-new-cluster

on node #2 with:
/usr/bin/mysqld_safe  --defaults-file=/etc/mysql/my.cnf
- --wsrep-cluster-address=gcomm://192.168.1.77

and on node #3 with:
/usr/bin/mysqld_safe  --defaults-file=/etc/mysql/my.cnf
- --wsrep-cluster-address=gcomm://192.168.1.77,192.168.1.80

192.168.1.77 and 192.168.1.80 are the IP addresses of nodes #1 and #2.

Maybe the thing I'm missing is bootstrapping the first node because
I'm not sure what it means. I'm on my way to look it up.

Thanks,

Sylvain

> 
> Thanks Guillaume
> 
> 2015-06-24 14:04 GMT+02:00 Sylvain Raybaud 
> <sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx 
> <mailto:sylvain.raybaud@xxxxxxxxxxxxxxxxxxxxxxx>>:
> 
> Hi
> 
> I'm setting up a 3 nodes cluster of mariadb+galera. The cluster
> seems to be created properly:
> 
> mysql -u root -p -e 'SELECT VARIABLE_VALUE as "cluster size" FROM 
> INFORMATION_SCHEMA.GLOBAL_STATUS WHERE 
> VARIABLE_NAME="wsrep_cluster_size"' Enter password: 
> +--------------+ | cluster size | +--------------+ | 3
> | +--------------+
> 
> 
> Problem is, I can only connect to mysql on the first node I create.
> On the other nodes it gives me:
> 
> ERROR 2002 (HY000): Can't connect to local MySQL server through
> socket '/tmp/mysql.sock' (111 "Connection refused")
> 
> /tmp/mysql.sock does exist and has correct permissions. However it 
> does not seem to be in listening state since it is not shown by 
> netstat -l.
> 
> I feel this must be some simple configuration problem but I'm
> quite stuck.
> 
> My configuration can be found at: http://pastebin.com/gVie8uKp
> 
> Note that since I'm compiling and running mariadb in buildroot I
> do not have /etc/mysql/debian.cnf.
> 
> Any idea?
> 
> Thanks,
> 
> 
> 
> _______________________________________________ Mailing list:
> https://launchpad.net/~maria-discuss Post to     :
> maria-discuss@xxxxxxxxxxxxxxxxxxx 
> <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx> Unsubscribe :
> https://launchpad.net/~maria-discuss More help   :
> https://help.launchpad.net/ListHelp
> 
> 

- -- 
Sylvain Raybaud
www.green-communications.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJViqNoAAoJEEkkwl4JtJ9ytekP/0rWfUfvtT2MIT0kmLLGA2lM
w9D7IRsve8/K/JzeKrKMkP+XyE9K+Aq/bl+5SQi2pV9s+i7GkHFRzpLBcrhujQ/U
BBfJKCJhqXSaLjPmxmRLaVH5QPC/BJCunDEdkQNZWXi8dsVXCKmVuqh8mNVtTCYy
8pdApgTZkUWQHU3lkZnsXPSQ6z59sxmu5TtGmNfKEtzo3S5oJFnbnvMcFErA7DYG
nAjs+dRWPvYFhVfLyITWhKjfLkWYxAQ6ZzZElZUF2FqqBmaWpJaTKCM6KihLhAcb
urDjv7H+uIozsjsrgn4YtFo9Ps4sq746WnmU6WRLvvU7JNZiDzTLD1+S5UmqdpZw
4MMu72kyA+x4mdi2fhQ5Pzvo096yzHfrEZrg6iqpXdJBvorTugHWqaQfh7Qki/jV
J+JCOPFdC0KAGgau3gpmyPDDRlnzhid02ZUEqed4iH59tutjh6+M+6lUYd2gDVxS
zXfSh8es4E0s/qOF0vWtoQe2dU647rmZRQc7Mws0n9J47oe4WO4gcF2qPjoGzUfy
pND5k8RAnpmuW2KItmkT8TJF3VQkuim2GpM7RBWaTCFKluesqCZLJy1oplZWtkeH
62B16bsGw6AZmRv5SuttUCeGOjd8bZsOQch02mJzbUKhIH3JC+boum7vehIDWpQh
6g9gGNtyo3SgMCO9ottT
=Rbks
-----END PGP SIGNATURE-----