… (again, talk to your network guys). I’m using 239.192.0.11, so we’ll add this to our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11″ If you already have wsrep_provider_options set… address: #wsrep_cluster_address = gcomm://192.168.70.2,192.168.70.3,192.168.70.4 wsrep_cluster_address = gcomm://239.192.0.11 And this works fine…
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
….launchpad.net/percona-xtrabackup/+bug/945161 while using percona-xtrabackup-2.0.6, so I update this software to 2.0.7. But my backup script get this error: “innobackupex: … –host=192.168.10.118 –user=backup –password=23khfisF –slave-info –no-lock –safe-slave-backup /db/backup/tst_ch118_3/201305″ innodb…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… nodes (using firewall rules): iptables -A INPUT -d 192.168.70.3 -s 192.168.70.2 -j REJECT This rule simulates a network outage that… -d 192.168.70.3 -s 192.168.70.2 -j REJECT nothing changes, data stays different: percona1 mysql> select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2…
Post: How to start a Percona XtraDB Cluster
January 29, 2013 By 10 Comments
… = 192.168.1.1 node2 = 192.168.1.2 node3 = 192.168.1.3 we defined the setting like this : wsrep_urls=gcomm://192.168.1.1:4567,gcomm://192.168.1.2:4567,gcomm://192.168.1.3…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
…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…
Comment: How to start a Percona XtraDB Cluster
January 30, 2013 By 10 Comments
Hi Just so i understand this right: You still has your ‘wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3‘ in the my.cnf file?
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… ip=”192.168.163.171″ nic=”eth0″ primitive reader_vip_2 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163.172″ nic=”eth0″ primitive reader_vip_3 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…] 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.105 db=ontime [shard5] host=192.168.56… 2001 and 2011 GROUP BY dest.CityName ORDER BY 2 DESC; — Q8.3 SELECT dest.CityName, COUNT( DISTINCT origin.CityName) from ontime…
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
… | 2012-09-24 09:38:49 | | 2 | node1, row2 | 2012-09-24 09:38:49 | | 3 | node1, row3 | 2012-09-24 09…:P=3306,h=192.168.1.45,p=…,u=percona dst_db:foo dst_tbl:bar dst_dsn:h=192.168.1.46,p…:P=3306,h=192.168.1.45,p=…,u=percona dst_db:foo dst_tbl:bar dst_dsn:h=192.168.1.46,p…:P=3306,h=192.168.1.45,p=…,u=percona dst_db:foo dst_tbl:bar dst_dsn:h=192.168.1.46,p…
Comment: Shard-Query turbo charges Infobright community edition (ICE)
October 5, 2012 By 23 Comments
…’s content: array( ‘host’=>’192.168.1.211′, ‘user’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port’=>3306 ), ‘shard2′ => array( ‘host’=>’192.168.1.101′, ‘user’=>’root…(‘col1′, array($mapper,’map’)); $sql = “INSERT INTO t1 VALUES(1,2),(2,3),(3,4),(4,5),(5,6),(6,7),(7,8),(8…’s content: array( ‘host’=>’192.168.1.211′, ‘user’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port’=>3306 ), ‘shard2′ => array( ‘host’=>’192.168.1.101′, ‘user’=>’root…
