… this, a subsequent run of chef-client is done to update the cnf files with IP address of members (excluding itself…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p_mysql:2 ] After the update and after fixing some small issues like the one bellow… 6.4 [root@percona2 percona]# yum -y update [root@percona3 percona]# yum -y update Meanwhile, we can already prepare the first node… cman ccs Back on the two nodes that were updating, they are now updated to 6.4: [root@percona3 percona]# cat /etc…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select query) also… hang up. If I do show processlist, the update queries show up with state =’Updating‘ or some others with state =’query end…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… and DROP TEMPORARY tables are not supported inside transaction. 2. Updates involving non-transactional storage engines – It is not possible to…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
Now that June has arrived it is time to plan what you will do over the summer months. In addition to your summer vacation plans, give thought to MySQL training for you and your team. Summer is the time to brush up on those critical skills needed to ensure all systems are ready for the holiday …
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… migrate an existing unicast cluster to multicast with a rolling update. I believe (but could be proven wrong) that you must…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes infrequently…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
Stephane, how are you coping with bug#69095 (replication fails with GTID enabled and master changes from SBR to RBR) and bug#69135 (mysql.slave_master_info is not updated) ?
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid…
Comment: Percona XtraBackup 2.1.2 for MySQL available for download
May 22, 2013 By 4 Comments
…-link-up-start-mysql-its-a-cluster-f). When I update i could not start my second and third node. I…
