…, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a… 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…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…serialization’ => true ); $memcacheOpts = array( ‘servers’ =>array( array( ‘host’ => ‘192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_…Memcache: Storing [100,000] items: 233863 ms total 2.33863 ms per/cmd 1.449 ms min per/cmd 7.324 …
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… = 0, memb_num = 1 120724 10:58:09 [Note] WSREP: forgetting 7e6d285b-d56d-11e1-0800-2491595e99bb (tcp://192.168.70.2:4567) 120724 10:58:09 [Note] WSREP: deleting entry tcp://192.168.70.2:4567 120724 10:58… address: gcomm://192.168.70.2:4567 group: trimethylxanthine sst: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs.fc…
Post: How to start a Percona XtraDB Cluster
January 29, 2013 By 10 Comments
… this : node1 = 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:4567…_cluster_address with the following syntax: wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3 As you can see the port is not needed…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 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.200″ …cib-bootstrap-options” \ expected-quorum-votes=”2” \ stonith-enabled=”false” \ dc-version=”1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558″ \ no-quorum…
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…_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…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
….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… BETWEEN 1980 and 2011 GROUP BY dest.CityName ORDER BY 2 DESC; Finally, Shard-Query performance continues to improve when grouping…
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…-master*/; REPLACE INTO `foo`.`bar`(`id`, `data`, `date_created`) VALUES (‘2‘, ‘node1, row2′, ’2012-09-24 09:38:49′) /*percona-toolkit…,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…
Comment: Shard-Query turbo charges Infobright community edition (ICE)
October 5, 2012 By 23 Comments
… script’s content: array( ‘host’=>’192.168.1.211′, ‘user’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port’=>3306 ), ‘shard2′ => array( ‘host’=>’192.168.1.101′, ‘user’=>’root’, ‘password…_info(‘col1′, array($mapper,’map’)); $sql = “INSERT INTO t1 VALUES(1,2),(2,3),(3,4),(4,5),(5,6),(6,7),(7… script’s content: array( ‘host’=>’192.168.1.211′, ‘user’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port’=>3306 ), ‘shard2′ => array( ‘host’=>’192.168.1.101′, ‘user’=>’root’, ‘password…
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?
