… install mysql-server-wsrep-5.5.20-23.4 with galera-23.2.0. When starting the second node and higher we… 1 (ubuntu-server-129) requested state transfer from ‘*any*’. Selected 0 (ubuntu-server-128)(SYNCED) as donor. Apr 1 14:14…: success, donor: 0 Apr 1 14:14:27 ubuntu-server-129 mysqld: 120401 14:14:26 [Warning] IP address ‘192.168.210.128…
Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 29, 2006 By 46 Comments
… but often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still constantly see people unaware of it… null, last_hit timestamp); insert into ipstat values(inet_aton(‘192.168.0.1′),1,now()) on duplicate key update hits=hits+1…. This allows to save on field length significantly by using 4 bytes instead of 15 The third feature this example takes…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… column=date_id mapper=hash gearman=127.0.0.1:7000 inlist=* between=* [shard1] host=192.168.56.102 Scale-out In addition to…=127.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… Carrier = ‘AA’ GROUP BY Year, Carrier,dest.CityName ORDER BY 4 DESC; Conclusion The divide and conquer approach is very useful…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… binary log and executing them on the SLAVE. Since MySQL 4.0 this process is a bit more involved having events passing…_IO_State: Waiting for master to send event Master_Host: 192.168.10.171 Master_User: replicant Master_Port: 3306 Connect_Retry…_Log_File instead. This naming was left from pre MySQL 4.0 era and it still causes confusion so many years later…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… 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 6.2 321.2 529.4…
