150223 11:20:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150223 11:20:17 mysqld_safe Skipping wsrep-recover for c4e268a9-ba52-11e4-acbc-e7084507e85e:1635303 pair 150223 11:20:17 mysqld_safe Assigning c4e268a9-ba52-11e4-acbc-e7084507e85e:1635303 to wsrep_start_position 2015-02-23 11:20:18 0 [Note] WSREP: wsrep_start_position var submitted: 'c4e268a9-ba52-11e4-acbc-e7084507e85e:1635303' 2015-02-23 11:20:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-02-23 11:20:18 11016 [Note] WSREP: Read nil XID from storage engines, skipping position init 2015-02-23 11:20:18 11016 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so' 2015-02-23 11:20:18 11016 [Note] WSREP: wsrep_load(): Galera 3.8(rf6147dd) by Codership Oy loaded successfully. 2015-02-23 11:20:18 11016 [Note] WSREP: CRC-32C: using hardware acceleration. 2015-02-23 11:20:18 11016 [Note] WSREP: Found saved state: c4e268a9-ba52-11e4-acbc-e7084507e85e:1635303 2015-02-23 11:20:18 11016 [Note] WSREP: Passing config to GCS: base_host = 192.168.101.12; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; 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.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.recov 2015-02-23 11:20:18 11016 [Note] WSREP: Service thread queue flushed. 2015-02-23 11:20:18 11016 [Note] WSREP: Assign initial position for certification: 1635303, protocol version: -1 2015-02-23 11:20:18 11016 [Note] WSREP: wsrep_sst_grab() 2015-02-23 11:20:18 11016 [Note] WSREP: Start replication 2015-02-23 11:20:18 11016 [Note] WSREP: Setting initial position to c4e268a9-ba52-11e4-acbc-e7084507e85e:1635303 2015-02-23 11:20:18 11016 [Note] WSREP: protonet asio version 0 2015-02-23 11:20:18 11016 [Note] WSREP: Using CRC-32C for message checksums. 2015-02-23 11:20:18 11016 [Note] WSREP: backend: asio 2015-02-23 11:20:18 11016 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory) 2015-02-23 11:20:18 11016 [Note] WSREP: restore pc from disk failed 2015-02-23 11:20:18 11016 [Note] WSREP: GMCast version 0 2015-02-23 11:20:18 11016 [Note] WSREP: (db5d952f, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 2015-02-23 11:20:18 11016 [Note] WSREP: (db5d952f, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 2015-02-23 11:20:18 11016 [Note] WSREP: EVS version 0 2015-02-23 11:20:18 11016 [Note] WSREP: gcomm: bootstrapping new group 'Percona-XtraDB-Cluster' 2015-02-23 11:20:18 11016 [Note] WSREP: start_prim is enabled, turn off pc_recovery 2015-02-23 11:20:18 11016 [Note] WSREP: Node db5d952f state prim 2015-02-23 11:20:18 11016 [Note] WSREP: view(view_id(PRIM,db5d952f,1) memb { db5d952f,0 } joined { } left { } partitioned { }) 2015-02-23 11:20:18 11016 [Note] WSREP: save pc into disk 2015-02-23 11:20:18 11016 [Note] WSREP: discarding pending addr without UUID: tcp://192.168.101.12:4567 2015-02-23 11:20:18 11016 [Note] WSREP: discarding pending addr proto entry 0x30af250 2015-02-23 11:20:18 11016 [Note] WSREP: discarding pending addr without UUID: tcp://192.168.101.13:4567 2015-02-23 11:20:18 11016 [Note] WSREP: discarding pending addr proto entry 0x30b7910 2015-02-23 11:20:18 11016 [Note] WSREP: gcomm: connected 2015-02-23 11:20:18 11016 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 2015-02-23 11:20:18 11016 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) 2015-02-23 11:20:18 11016 [Note] WSREP: Opened channel 'Percona-XtraDB-Cluster' 2015-02-23 11:20:18 11016 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 2015-02-23 11:20:18 11016 [Note] WSREP: Waiting for SST to complete. 2015-02-23 11:20:18 11016 [Note] WSREP: STATE_EXCHANGE: sent state UUID: db5e6a50-bb77-11e4-a366-a254164d6e5c 2015-02-23 11:20:18 11016 [Note] WSREP: STATE EXCHANGE: sent state msg: db5e6a50-bb77-11e4-a366-a254164d6e5c 2015-02-23 11:20:18 11016 [Note] WSREP: STATE EXCHANGE: got state msg: db5e6a50-bb77-11e4-a366-a254164d6e5c from 0 (MySQL-0) 2015-02-23 11:20:18 11016 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 0, members = 1/1 (joined/total), act_id = 1635303, last_appl. = -1, protocols = 0/6/3 (gcs/repl/appl), group UUID = c4e268a9-ba52-11e4-acbc-e7084507e85e 2015-02-23 11:20:18 11016 [Note] WSREP: Flow-control interval: [16, 16] 2015-02-23 11:20:18 11016 [Note] WSREP: Restored state OPEN -> JOINED (1635303) 2015-02-23 11:20:18 11016 [Note] WSREP: Member 0.0 (MySQL-0) synced with group. 2015-02-23 11:20:18 11016 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1635303) 2015-02-23 11:20:18 11016 [Note] WSREP: New cluster view: global state: c4e268a9-ba52-11e4-acbc-e7084507e85e:1635303, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3 2015-02-23 11:20:18 11016 [Note] WSREP: SST complete, seqno: 1635303 2015-02-23 11:20:18 11016 [Note] Plugin 'FEDERATED' is disabled. 2015-02-23 11:20:18 7f11da2437e0 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html. 2015-02-23 11:20:18 11016 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-02-23 11:20:18 11016 [Note] InnoDB: The InnoDB memory heap is disabled 2015-02-23 11:20:18 11016 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-02-23 11:20:18 11016 [Note] InnoDB: Memory barrier is not used 2015-02-23 11:20:18 11016 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-02-23 11:20:18 11016 [Note] InnoDB: Using Linux native AIO 2015-02-23 11:20:18 11016 [Note] InnoDB: Using CPU crc32 instructions 2015-02-23 11:20:18 11016 [Note] InnoDB: Initializing buffer pool, size = 2.0G 2015-02-23 11:20:18 11016 [Note] InnoDB: Completed initialization of buffer pool 2015-02-23 11:20:18 11016 [Note] InnoDB: Highest supported file format is Barracuda. 2015-02-23 11:20:19 11016 [Note] InnoDB: 128 rollback segment(s) are active. 2015-02-23 11:20:19 11016 [Note] InnoDB: Waiting for purge to start 2015-02-23 11:20:19 11016 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.1 started; log sequence number 13814628557 2015-02-23 11:20:19 11016 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work. 2015-02-23 11:20:19 11016 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work. 2015-02-23 11:20:19 11016 [Note] Server hostname (bind-address): '*'; port: 3306 2015-02-23 11:20:19 11016 [Note] IPv6 is available. 2015-02-23 11:20:19 11016 [Note] - '::' resolves to '::'; 2015-02-23 11:20:19 11016 [Note] Server socket created on IP: '::'. 2015-02-23 11:20:19 11016 [Warning] 'user' entry 'root@mysql-cluster1' ignored in --skip-name-resolve mode. 2015-02-23 11:20:19 11016 [Warning] 'user' entry '@mysql-cluster1' ignored in --skip-name-resolve mode. 2015-02-23 11:20:19 11016 [Warning] 'proxies_priv' entry '@ root@mysql-cluster1' ignored in --skip-name-resolve mode. 2015-02-23 11:20:19 11016 [Note] Event Scheduler: Loaded 0 events 2015-02-23 11:20:19 11016 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.21-70.1-56' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel70.1, Revision 938, WSREP version 25.8, wsrep_25.8.r4150 2015-02-23 11:20:19 11016 [Note] WSREP: inited wsrep sidno 1 2015-02-23 11:20:19 11016 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2015-02-23 11:20:19 11016 [Note] WSREP: REPL Protocols: 6 (3, 2) 2015-02-23 11:20:19 11016 [Note] WSREP: Service thread queue flushed. 2015-02-23 11:20:19 11016 [Note] WSREP: Assign initial position for certification: 1635303, protocol version: 3 2015-02-23 11:20:19 11016 [Note] WSREP: Service thread queue flushed. 2015-02-23 11:20:19 11016 [Note] WSREP: Synchronized with group, ready for connections 2015-02-23 11:20:19 11016 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.