… this, a subsequent run of chef-client is done to update the cnf files with IP address of members (excluding itself…, naturally duration of SST is paramount. We recommend Xtrabackup SST for its reduced locking period from its use (which means the… by Peter Boros (“Percona XtraDB Cluster reference architecture with HaProxy”) for details. In their setup they have automated this with a…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… to your summer vacation plans, give thought to MySQL training for you and your team. Summer is the time to brush… those critical skills needed to ensure all systems are ready for the holiday shopping season. In addition to our revised courses… 19, 2013 , 9am – 5pm We have a 10% discount code for use when ordering, register early and save even more as…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… upgrade process. So like for Pacemaker 0.6.x to 1.0.x, you need again to update all nodes as once… logfile ‘/var/log/corosync.log’ for reason: Permission denied (13).#012. So now you need to update all nodes to Pacemaker 1… 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
… a problem regarding long running select query. A query runs for say 300 seconds and because the resultset is huge, it… 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… can arise if slave host is using different storage engine for the respective table on master databases. Also, if BINLOG_FORMAT…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… get nervous around 100MBps. By default Galera uses unicast TCP for replication. Because synchronous replication needs to replicate to all nodes… more nodes in your cluster, the more the bandwidth required for replication multiplies. Now, this isn’t really much different from… 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
… the “gap” will be picked more frequently. Nearly every solution for randomly choosing rows involves some compromise, either of performance, or… another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes infrequently…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… take away that you should be using MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which… fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom… risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… besides 1 and suddenly you can update much faster. I see this tuning very frequently for “performance” reasons when data durability isn… your application will need to do for hotspots. wsrep_retry_autocommit If your hotspots are all updates with autocommits, you can rely on wsrep_retry_autocommit to auto-retry the transactions for you. However, each…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… Added package install/update instructions and other documentation updates (bugs 1139652, 1124200, 1015981) * Updated documentation with the new Cacti sample images * Updated “…from our software repositories. The plugins are fully supported for customers with a Percona Support contract and free …
