… 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, add…: #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: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… true ); $memcacheOpts = array( ‘servers’ =>array( array( ‘host’ => ‘192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache … = $totalTimeStore / 100000; $timer->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000; $i++) { $obj = $…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
… need an extra IP because you move from 127.0.0.1 to 192.168.x.x it’s a whole lot simpler (and by…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… 0.1 0.1 2.9 0.1 1678.6 | 1341.6 0.1 74.4 1584.6 87.0 | 337.0 0.1 0.1 1.1 0.0 1670.9 | 1334.9 0.1 75.0 1567.0 88.0 | 336.0 0.1 0.1 1.0 0.0… 0.1 0.1 1.5 0.0 [root@udbqa006.sf2p ~]# lvcreate –size 60g –snapshot –name snap /dev/VolGroup20/mysqldata Logical volume “snap” created 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.7…
Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 29, 2006 By 48 Comments
… often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still constantly see people unaware of it. Myself… timestamp); 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… address in the table it will be added with hits=1 if it is already where (note ip is PRIMARY KEY…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
June 30, 2006 By 48 Comments
[...] use INSERT ON DUPLICATE KEY UPDATE (via MySQL Performance Blog): my $ret = $dbh->do(“INSERT INTO ipstat VALUES(inet_aton(‘192.168.0.1‘),1,now()) ON duplicate KEY UPDATE hits=hits+1“); Note: ip should be a primary key in this case [...]
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… 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 28540/php-cgi tcp 0 0 192.168.1.70:45399 192.168.1…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…_RESKEY_test_passwd_default=”mysql” OCF_RESKEY_enable_creation_default=0 OCF_RESKEY_additional_parameters_default=”" OCF_RESKEY_replication_port_default…_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…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
…:heartbeat:IPaddr \ params ip=”192.168.2.200″ \ operations $id=”failover-ip-operations” \ op monitor start-delay=”0” interval=”2″ \ meta …” \ expected-quorum-votes=”2″ \ stonith-enabled=”false” \ dc-version=”1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558″ \ no-quorum-policy=”ignore” \ cluster-…
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 … 100% percona-server-5.5.29_rel29.4-1-armv6h 4.1 MiB 323K/s 00:13 [########################################################] 100% (4/4…
