cat my.4000.cnf
[mysqld_safe]
wsrep_urls= gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm:// 192.168.2.21:6030,gcomm://
[mysqld]
port = 4000
socket=/tmp/mysql.4000.sock
datadir=/wali/mysql/data1
basedir=/wali/percona/Percona-XtraDB-Cluster-5.5.27-23.6.356 .Linux.x86_64
user=mysql
log_error=error.log
binlog_format=ROW
wsrep_provider=/wali/percona/Percona-XtraDB-Cluster-5.5.27-2 3.6.356.Linux.x86_64/lib/libgalera_smm.so
wsrep_sst_receive_address=192.168.2.21
wsrep_node_incoming_address=192.168.2.21
wsrep_slave_threads=2
wsrep_cluster_name=trimethylxanthine
wsrep_provider_options = “gmcast.listen_addr=tcp://192.168.2.21:4030;”
wsrep_sst_method=rsync
wsrep_node_name=node4000
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2
mysqld_safe --defaults-file=/etc/my.4000.cnf
vi /wali/mysql/data1/error.log
120926 17:57:39 mysqld_safe Starting mysqld daemon with databases from /wali/mysql/data1
120926 17:57:39 [Note] Flashcache bypass: disabled
120926 17:57:39 [Note] Flashcache setup error is : ioctl failed
120926 17:57:39 [Note] WSREP: Read nil XID from storage engines, skipping position init
120926 17:57:39 [Note] WSREP: wsrep_load(): loading provider library ‘/wali/percona/Percona-XtraDB-Cluster-5.5.27-23.6.356.Linux. x86_64/lib/libgalera_smm.so’
120926 17:57:39 [Note] WSREP: wsrep_load(): Galera 2.2(r115) by Codership Oy <info@codership.com> loaded succesfully.
120926 17:57:39 [ERROR] WSREP: Failed to read output of: ‘/sbin/ifconfig | grep -m1 -1 -E ‘[1]?eth[0-9]’ | tail -n 1 | awk ‘{ print $2 }’ | awk -F : ‘{ print $2 }’’
120926 17:57:39 [Warning] WSREP: Failed to autoguess base node address
120926 17:57:39 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
120926 17:57:39 [Note] WSREP: Reusing existing ‘/wali/mysql/data1//galera.cache’.
120926 17:57:39 [Note] WSREP: Passing config to GCS: gcache.dir = /wali/mysql/data1/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /wali/mysql/data1//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; gmcast.listen_addr = tcp://192.168.2.21:4030; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
120926 17:57:39 [Note] WSREP: Flushing memory map to disk…
120926 17:57:39 [ERROR] WSREP: non-standard exception
120926 17:57:39 [ERROR] WSREP: wsrep::init() failed: 6, must shutdown
120926 17:57:39 [ERROR] Aborting
-
a-z ↩︎