…, 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… mcast 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…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… 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 28540/php-cgi tcp 0 0 192.168.1.70…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… we fix the connection problem: iptables -D INPUT -d 192.168.70.3 -s 192.168.70.2 -j REJECT nothing changes, data stays different: percona1… = 0, memb_num = 1 120724 10:58:09 [Note] WSREP: forgetting 7e6d285b-d56d-11e1-0800-2491595e99bb (tcp://192.168.70.2:4567) 120724 10… address: gcomm://192.168.70.2:4567 group: trimethylxanthine sst: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs.fc…
Comment: Gathering queries from a server with Maatkit and tcpdump
August 30, 2009 By 23 Comments
…: $VAR1 = { ack => 3333564724, complete => 1, data => ’110000000373656c656374202a2066726f6d207070′, data_len => 21, dgram_len => 61, dst_host => ‘192.168.84.22′, dst_port => ‘… 0×0030: 6563 7420 2a20 6672 6f6d 2070 70‘, seq => 599923085, src_host => ‘192.168.84.146′, src_port => ’2557′, tcp_hlen => …
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
… (ex: wsrep_provider_options = “ist.recv_addr=192.168.70.2;”) if you don’t use yet…’; +————————+———–+ | Variable_name | Value | +————————+———–+ | wsrep_provider_version | 2.1(r113) | +————————+———–+ After that you will be able…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
…/foo /data/foo: 0: [0..173950911]: 320..173951231 173950912 blocks 1: [173950912..341722991]: 183500864..351272943 167772080 blocks 2: [341722992..509495071]: 367263808….4 5.0 287.5 419.8 43.2 | 70.9 0.1 277.6 401.6 43.8 421.5 | 336… 626.7 | 502.0 0.1 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248…
