…, 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
… Pro) Centos 6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache …’ => true ); $memcacheOpts = array( ‘servers’ =>array( array( ‘host’ => ‘192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_…
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…,4),(4,5),(5,6),(6,7),(7,8),(8,9)”; $shard_query->query($sql); ?> read.php script’s content: array( ‘host’=>’192.168.1…
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…-upgrade query? I have same set of data in mysql-4.1.x and mysql-5.5.x (tested with pt-table…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… (6) | | wsrep_cert_index_size | 2 | | wsrep_cluster_conf_id | 4 | | wsrep_cluster_size | 2 | | wsrep_cluster_state_uuid | 8dccca9f-d4b8… = 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…
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… Carrier = ‘AA’ GROUP BY Year, Carrier,dest.CityName ORDER BY 4 DESC; Conclusion The divide and conquer approach is very useful…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…192.168.0.180 root@192.168…
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
… ist.recv_addr (ex: wsrep_provider_options = “ist.recv_addr=192.168.70.2;”) if you don’t use yet the magic…:03 [Note] WSREP: async IST sender starting to serve tcp://192.168.70.2:4568 sending 24-27 120802 13:05:15…] WSREP: Receiving IST: 4 writesets, seqnos 23-27 120802 13:05:15 [Note] WSREP: 0 (percona2): State transfer to 1 (percona1) complete…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
….7 0.1 69.6 2853.9 82.4 | 360.2 0.1 0.1 4.2 0.1 1675.6 | 1340.0 0.1 74.6 1596.9 88.0 | 335.6 0.1 0.1 2….1 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248.7 6.2 321.2 529.4…
Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 29, 2006 By 48 Comments
… but 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…. This allows to save on field length significantly by using 4 bytes instead of 15 The third feature this example takes…
