… = 0, memb_num = 1 120724 10:58:09 [Note] WSREP: forgetting 7e6d285b-d56d-11e1-0800-2491595e99bb (tcp://192.168.70.2:4567) 120724…: version = 2, component = PRIMARY, conf_id = 2, members = 1/1 (joined/total), act_id = 16, last_appl. = 0, protocols = 0/4/2 (gcs… address: gcomm://192.168.70.2:4567 group: trimethylxanthine sst: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…_CHECK_LEVEL=”1” \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1” primitive reader_vip_1 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163.171″ nic=”eth0″ primitive reader_vip_2 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163… 28 11:16:40 2012 via crmd on PRM_S1 Stack: openais Current DC: PRM_S1 – partition with quorum Version: 1.1.6…
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
…,h=192.168.1.45,p=…,u=percona dst_db:foo dst_tbl:bar dst_dsn:h=192.168.1.46,p=…,u=percona lock:1 transaction:1…,h=192.168.1.45,p=…,u=percona dst_db:foo dst_tbl:bar dst_dsn:h=192.168.1.46,p=…,u=percona lock:1 transaction:1…(ISNULL(`data`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `foo`.`bar` FORCE INDEX (`PRIMARY`) WHERE (1=1) FOR UPDATE; When you update…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… TABLE_ROWS_READ: 0 SELECT_COMMANDS: 2 UPDATE_COMMANDS: 16 OTHER_COMMANDS: 26 COMMIT_TRANSACTIONS: 15 ROLLBACK_TRANSACTIONS: 0…: 0 1 row in set (0.00 sec) mysql> select * from information_schema.client_STATISTICS\G *************************** 1. row *************************** CLIENT: 192.168.10.174…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 130221 17:59:05 [Note] WSREP: wsrep_start_position var…:59:05 [Note] WSREP: Passing config to GCS: base_host = 192.168.14.150; base_port = 4567; cert.log_conflicts = no; gcache… = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… -l /data total 335544320 -rw-r–r– 1 root root 343597383680 Sep 9 16:05 foo [root@udbqa006.sf2p /home/pv/work/src/randomio-1.3]# xfs_bmap -l /data/foo… 626.7 | 502.0 0.1 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248…
