… test environment consisting of a single commodity database server with 6 cores (+6ht) and 24GB of memory was selected. The selected….0.0.1:7000 inlist=* between=* [shard1] host=192.168.56.101 db=ontime [shard2] host=192.168.56.102 db=ontime [shard3] host=192.168.56.103 db=ontime [shard4] host=192.168.56…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 93 Comments
… IP=”192.168.2.201″ node db2.grennan.com \ attributes IP=”192.168.2.202″ primitive failover-ip ocf:heartbeat:IPaddr \ params ip=”192.168.2…=”1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558″ \ no-quorum-policy=”ignore” \ cluster-infrastructure=”openais” \ last-lrm-refresh=”1328725415″ property $id=”mysql_replication” \ replication_info=”192.168…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… 0 1 row in set (0.00 sec) mysql> select * from information_schema.client_STATISTICS\G *************************** 1. row *************************** CLIENT: 192.168.10.174…| from_message_id | 8363 | | art115 | article115 | forum_id_2 | 6 | | art61 | img_out61 | from_message_id | 4475 | | art90 | img…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
….8 43.2 | 70.9 0.1 277.6 401.6 43.8 421.5 | 336.8 1.6 239.7 414.8 44.0 | 84.7 0.1 228.2 394.2 45.6….9 1.6 87.0 603.9 54.9 | 253.0 0.1 49.3 388.4 45.7 1498.6 | 1200.7 0.1….0 0.1 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248.7 6.2 321…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 3, 2012 By 93 Comments
… keepalived with Direct Routing for loadbalancing. We setup a vip (192.168.5.141) in the config, and attach 3 real servers…, just pacemaker. I’m running everything from squeeze-backport: Pacemaker 1.1.6-2
