… isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication… 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
…a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are … => true ); $memcacheOpts = array( ‘servers’ =>array( array( ‘host’ => ‘192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend…
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…management system. Now, since wsrep_urls is deprecated since version 5.5.28 what is the better option to start the cluster…
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,5),(5,6),(6,7),(7,8),(8,9)”; $shard_query->query($sql); ?> read.php script’s content: array( ‘host’=>’192.168.1.211…
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…? I have same set of data in mysql-4.1.x and mysql-5.5.x (tested with pt-table-checksum). My aim…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… ; or \g. Your MySQL connection id is 868 Server version: 5.5.24 Copyright (c) 2000, 2011, Oracle and/or its affiliates… = 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: 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…_mysql:0_monitor_0 (node=PRM_S1, call=6, rc=5, status=complete): not installed writer_vip_start_0 (node=PRM…
Comment: Gathering queries from a server with Maatkit and tcpdump
August 30, 2009 By 23 Comments
…, complete => 1, data => ’110000000373656c656374202a2066726f6d207070′, data_len => 21, dgram_len => 61, dst_host => ‘192.168.84.22′, dst_port => ’4333′, ip_hlen => 5, pos_in_log => 13193, raw_packet => ’2009-08-31 14:26:13.120420 IP 192.168.84.146.2557 > 192.168.84.22… 2070 70′, seq => 599923085, src_host => ‘192.168.84.146′, src_port => ’2557′, tcp_hlen => 5, ts => ’2009-08-31 14:26:13…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… using Linux (ssh) and Windows (Tunnelier): $ ssh root@192.168.0.180 root@192.168.0.180′s password: Last login: Fri Feb 22…): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-1 Total Download Size: 8.07… KiB 1089K/s 00:00 [########################################################] 100% percona-server-5.5.29_rel29.4-1-armv6h 4.1 MiB 323K/s 00:13 [########################################################] 100% (4…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…QUERIES: 0 1 row in set (0.00 sec) mysql> select * from information_schema.client_STATISTICS\G *************************** 1. row *************************** CLIENT: 192.168.10.174 …like to test it here is link to patch for 5.0.67. http://www.mysqlperformanceblog.com/mysql/experimental/userstatv2….
