… people setting up clusters with 3-6+ nodes on 1 Gbps networks. 1 Gbps seems like a lot, doesn’t it? Actually… our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11″ If you already have wsrep_provider_options set…: #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_Cache… raw results from this test run (100,000 store operations, 1,000,000 fetch operations): Standard Memcache: Storing [100,000] items…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
… an extra IP because you move from 127.0.0.1 to 192.168.x.x it’s a whole lot simpler (and…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…_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.163… ip=”192.168.163.170″ nic=”eth0″ \ meta target-role=”Started” ms ms_MySQL p_mysql \ meta master-max=”1” master-node-max=”1…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… 28540 tcp 0 0 192.168.1.70:58555 192.168.1.90:11211 ESTABLISHED 28540/php-cgi tcp 0 0 192.168.1.70:52711 192.168.1.88:8080 ESTABLISHED 28540/php-cgi tcp 0 0 192.168.1.70:45384 192.168.1.82:3306 ESTABLISHED…-cgi tcp 0 0 192.168.1.70:45408 192.168.1.82:3306 ESTABLISHED 28540/php-cgi tcp 0 0 192.168.1.70:35556 192.168.1.92:11211 ESTABLISHED…
Post: How to start a Percona XtraDB Cluster
January 29, 2013 By 10 Comments
… : 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…_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…
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…,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…,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: 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: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… fix the connection problem: iptables -D INPUT -d 192.168.70.3 -s 192.168.70.2 -j REJECT nothing changes, data stays different… = 0, memb_num = 1 120724 10:58:09 [Note] WSREP: forgetting 7e6d285b-d56d-11e1-0800-2491595e99bb (tcp://192.168.70.2:4567) 120724… address: gcomm://192.168.70.2:4567 group: trimethylxanthine sst: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs…
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… 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…
