Hey all, using 5.5 here and had a three node cluster happily running along.
host names are dot3, dot8, dot9 Well, hardware failure on dot8 caused us to replace it with a new server. Installed same OS (ubuntu 14.04) same procedure to install galera, copied config files over, etc..
when i execute the command
this is all i see in the terminal
[sudo] password for piv:
161108 09:27:16 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect.
161108 09:27:16 mysqld_safe Logging to '/var/log/mysql/error.log'.
and in /var/log/mysql/error.log
161108 09:27:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161108 09:27:16 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.PWfNCw' --pid-file='/var/lib/mysql/dot138-recover.pid'
nohup: ignoring input
161108 9:27:16 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
161108 9:27:16 [Note] /usr/sbin/mysqld (mysqld 5.5.53-MariaDB-1~trusty-wsrep) starting as process 4661 ...
/usr/sbin/mysqld: Query cache is disabled (resize or similar command in progress); repeat this command later
it does take a few seconds before it stops. There is also no process runnning in the background
relevent mysql my.cnf info
[mysqld_safe]
28 socket = /var/run/mysqld/mysqld.sock
29 nice = 0
30
31 [mysqld]
32
33 innodb_buffer_pool_size = 215G
34 innodb_log_file_size = 12G
35 innodb_flush_log_at_trx_commit = 0
36 innodb_file_per_table=1
37
38 #mysql settings from galera file
39 binlog_format=ROW
40 default-storage-engine=innodb
41 innodb_autoinc_lock_mode=2
42 query_cache_size=0
43 query_cache_type=0
44 bind-address=0.0.0.0
45 #galera settings
46 wsrep_provider=/usr/lib/galera/libgalera_smm.so
47 wsrep_cluster_name="main_cluster"
48 wsrep_cluster_address="gcomm://
192.168.1.119,192.168.1.138,192.168.1.133"
49 wsrep_sst_method=rsync
50 wsrep_sst_auth=main_user:main_pass
51 wsrep_sst_donor='dot9'
is there anywhere else this operation writes logs?
thanks for any tips