… | | 13 | percona1 | miguel | | 14 | percona1 | marcos | | 15 | percona1 | baron | | 16 | percona1 | brian | | 17 | percona2 | daniel | +—-+—————+——–+ 10 rows in set…-2491595e99bb (tcp://192.168.70.2:4567) 120724 10:58:09 [Note] WSREP: deleting entry tcp://192.168.70.2:4567 120724 …
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
… CentOS 6.2 32 bit. One Master name: PRM_M, IP: 192.168.163.205 One Slave name: PRM_S1, IP: 192.168.163.206…:heartbeat:IPaddr2 \ params ip=”192.168.163.171″ nic=”eth0″ primitive reader_vip_2 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163.172″ nic=”eth0… 11:19:57 2012 Last change: Mon May 28 11:16:40 2012 via crmd on PRM_S1 Stack: openais Current…
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
… | 1 | node1, row1 | 2012-09-24 09:38:49 | | 2 | node1, row2 | 2012-09-24 09:38:49 | | …h=192.168.1.45,p=…,u=percona dst_db:foo dst_tbl:bar dst_dsn:h=192.168…. `date_created` + 0, CONCAT(ISNULL(`data`)))) AS UNSIGNED)), 10, 16)), 0) AS crc FROM `foo`.`bar` FORCE INDEX …
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 ACCESS_DENIED: 0 EMPTY_QUERIES: 506 *************************** 2. row *************************** CLIENT: 192.168.10.161 TOTAL_CONNECTIONS: 41539 CONCURRENT_CONNECTIONS:…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…address=gcomm:// binlog_format=ROW wsrep_slave_threads=2 wsrep_cluster_name=trimethylxanthine wsrep_sst_method=…[Note] WSREP: Passing config to GCS: base_host = 192.168.14.150; base_port = 4567; cert.log_conflicts = …= 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… 1596.9 88.0 | 335.6 0.1 0.1 2.2 0.0 [root@udbqa006.sf2p ~]# lvcreate –size 60g –snapshot –name… 335544320 -rw-r–r– 1 root root 343597383680 Sep 9 16:05 foo [root@udbqa006.sf2p /home/pv/work/src/randomio.....173951231 173950912 blocks 1: [173950912..341722991]: 183500864..351272943 167772080 blocks 2: [341722992..509495071]: 367263808..535035887 167772080 blocks 3: [509495072..671088639]: 550502464… 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248.7 6.2 321.2…
