…, 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: 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?
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…
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
…version’; +————————+———–+ | Variable_name | Value | +————————+———–+ | wsrep_provider_version | 2.1(r113) | +————————+———–+ After that you will be…async IST sender starting to serve tcp://192.168.70.2:4568 sending 24-27 120802 13:05:…
Comment: How To Test Your Upgrades - pt-upgrade
July 24, 2012 By 7 Comments
… doing the following steps 1. # pt-query-digest query.log > /var/lib/mysql/log-query-for-pt-upgrade 2. # pt-upgrade /var/lib/mysql/log-query-for-pt-upgrade h=localhost,u=root,P=3306 h=192.168.1.100… –continue-on-error –base-dir /tmp/ptupgrade/ > /tmp/ptupgrade/test1 2>/tmp/ptupgrade/test1.error Here I have omitted –compare results…
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… –continue-on-error –base-dir /tmp/ptupgrade/ > /tmp/ptupgrade/test1 2>/tmp/ptupgrade/test1.error
