… CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick… more detail about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where… master and redirect replication on the other servers to s2. This scenario can happen when you want to perform a planned failover… with GTIDs, you cannot totally forget old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and… if you’re not using GTID-based replication. If you are using GTID-based replication, it looks like you’ll need to…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY… is not supported to perform such type of statements http://mysqlopt.blogspot.co.uk/2013/06/restrictions-on-replication-with-gtids.html
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June… those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at some other layer of…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… subqueries) and we saw in my presentation that sometimes these perform worse and sometimes better than another equivalent solution. If you… using temporary tables in this way, for example when using replication, a temporary table could vanish if the slave restarts and… solution for randomly choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
If you are using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6.4, upgrading … in maintenance mode before the update, see bellow how to perform this action [root@percona1 percona]# yum update -y [root@percona1..._TIMEOUT=0/g" /etc/sysconfig/cman And create the cluster, perform the following command on one server only: [root@percona1 ~]# ccs…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much… does NOT set an lower bound on performance, only a upper bound. The best performance you can expect is modifying a given… update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is…
