… For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And … executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-…-c3ae-11e2-b986-0800272864ba is the server UUID of s2, and that the other one …
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
…. Bugs Fixed: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced a regression…_uuid and wsrep_last_committed. Bug fixed #1181222. innobackupex automatic version detection did not work correctly for latest Percona Server and MySQL… close the connection while backup is being taken. Fixed by setting the bigger value for wait_timeout option on the server…
Comment: Confusing MySQL Replication Error Message
April 19, 2013 By 11 Comments
I have observed this is still a problem with MySQL 5.6 today. The problem and resolution are slightly different though. My server-id were properly set differently, but the server-uuid was the same, because this new slave was a clone. My resolution was to change the server-uuid
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary… prepdefined A: MySQL Server will not automatically define any indexes for you. Hopefully your CMS already comes with reasonable set of indexes… auto increment. Having said that there are many people using UUID rather successful in applications which do not need to be…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…| 1 | | wsrep_cluster_state_uuid | 8dccca9f-d4b8-11e1-…mysql> select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ | 2 | percona1 | lefred | | 3 | percona2 | kenny | +—-+—————+——–+ 2 rows in set (0.00 sec) percona2 mysql…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
… is however completely separate problem which can be fixed in MySQL 5.1 Data Clustering This again applies to Innodb tables…” items more frequently and data set is large auto_increment would work much better than UUID because UUID will have recent data scattered… of 40305 rows/sec. For UUID process took over 12 hours and is still going. From MySQL status I can see it…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…with MySQL you might need to deal with RAID recovery every …1 Layout : left-symmetric Chunk Size : 64K Name : 001F33EABA01:2 UUID : 01a26106:50b297a8:1d542f0a:5c9b74c6 Events : 83 Number Major Minor…Fri Aug 26 13:51:11 2011 mdadm: size set to 2925544704K Continue creating array? y mdadm: Defaulting to…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state…script examines wsrep_local_state variable. To set it up, create the clustercheck user. mysql> grant process on *.* to ‘clustercheckuser’@'localhost’ identified…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… UUID=`uuidgen` mysql test -e “insert into sorttest value (‘$UUID‘);” let “COUNT=COUNT+1″ done I know, I could have used the uuid() function of MySQL… `seq 1 1000` do START=`date +%s.%N` OUT=`mysql -e “set session sort_buffer_size=32*1024*$i;select * from sorttest…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… execution plans are cached. MySQL Query Cache is not. It does not cache the plan but full result sets. This means it… works with current data, uses non-deterministic functions such as UUID(), RAND(), CONNECTION_ID() etc it will not be cached. Table… of them quite likely would not have change their result set but MySQL has no way to identify which one of them…
