…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….” \ expected-quorum-votes=”2″ \ stonith-enabled=”false” \ dc-version=”1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558″ \ no-quorum-policy=”ignore” \ cluster-…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…Linux (ssh) and Windows (Tunnelier): $ ssh root@192.168.0.180 root@192.168.0.180′s password: Last login: Fri … 100% percona-server-5.5.29_rel29.4-1-armv6h 4.1 MiB 323K/s 00:13 [########################################################] 100% (4/4…
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
… (ex: wsrep_provider_options = “ist.recv_addr=192.168.70.2;”) if you don’t use …version’; +————————+———–+ | Variable_name | Value | +————————+———–+ | wsrep_provider_version | 2.1(r113) | +————————+———–+ After that you will be able …
Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 29, 2006 By 48 Comments
… often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still constantly see people unaware of it. Myself…); insert into ipstat values(inet_aton(‘192.168.0.1‘),1,now()) on duplicate key update hits=hits+1; This example actually shows one more… address in the table it will be added with hits=1 if it is already where (note ip is PRIMARY KEY…
Comment: How To Test Your Upgrades - pt-upgrade
July 24, 2012 By 7 Comments
… I am wrong, I will be doing the following steps 1. # pt-query-digest query.log > /var/lib/mysql/log-query…-for-pt-upgrade h=localhost,u=root,P=3306 h=192.168.1.100,u=perc,p=perc,P=3306 –convert-to-select… query? I have same set of data in mysql-4.1.x and mysql-5.5.x (tested with pt-table…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
June 30, 2006 By 48 Comments
[...] use INSERT ON DUPLICATE KEY UPDATE (via MySQL Performance Blog): my $ret = $dbh->do(“INSERT INTO ipstat VALUES(inet_aton(‘192.168.0.1‘),1,now()) ON duplicate KEY UPDATE hits=hits+1“); Note: ip should be a primary key in this case [...]
Comment: Edge-case behavior of INSERT...ODKU
October 30, 2012 By 6 Comments
… > echo long2ip(-1062706175) , “\n”; 192.168.100.1 (root@localhost) [(none)]> select INET_NTOA(-1062706175); +————————+ | INET_NTOA(-1062706175) | +————————+ | NULL | +————————+ 1 row in set (0…
Comment: How To Test Your Upgrades - pt-upgrade
July 23, 2012 By 7 Comments
…/mysql/query.log h=localhost,u=root,P=3306 h=192.168.1.100,u=perc,p=perc,P=3306 –convert-to-select…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
December 1, 2011 By 102 Comments
… it’s only content: $ grep -n ^%% ~/.crmconf/web 23:%% ip 192.168.1.101 31:%% netmask 35:%% lvs_support 61:%% id websvc 65…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…=date_id mapper=hash gearman=127.0.0.1:7000 inlist=* between=* [shard1] host=192.168.56.102 Scale-out In addition to….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…
