… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the… check that 3ec18c45-c3ae-11e2-b986-0800272864ba is the server UUID of s2, and that the other one is from s0…
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…
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… when using a CMS where DB structure is prepdefined A: MySQL Server will not automatically define any indexes for you. Hopefully… 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
…conf_id | 18446744073709551615 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid | 8dccca9f-d4b8-11e1-0800-344f6b618448 | | wsrep_cluster_status | non-…test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is…
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… set is large auto_increment would work much better than UUID because UUID will have recent data scattered all across. Lookups Later… 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
Dealing with MySQL you might need to deal with RAID recovery every so … : 1 Layout : left-symmetric Chunk Size : 64K Name : 001F33EABA01:2 UUID : 01a26106:50b297a8:1d542f0a:5c9b74c6 Events : 83 Number Major Minor RaidDevice… Offset : 8 sectors Recovery Offset : 5631463944 sectors State : clean Device UUID : 77ea1f91:5d4915c3:5cd17402:7f1ecafb Update Time : Fri Aug 26 22…
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… important point here, at least for the Linux, glibc and MySQL versions I used and for the test I did, there…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant … mainly due to modifying the uu index. This is because UUID() spreads values prefix very well effectively giving almost uniform access… does not exist, which reduced performance for random selects by UUID from 400 to 20 per second (from single thread). Decreasing…
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…–db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
