… the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June… grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at some other layer of…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… of the MySQL Community: Vadim Tkachenko, Percona co-Founder and CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of… pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide…
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… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific… you ever want to use MySQL on top of something like that? I can’t imagine the performance being all that fantastic, and I could see network latency wreaking havoc with MySQL‘s internal understanding…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… master and redirect replication on the other servers to s2. This scenario can happen when you want to perform a planned failover…; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, … in this way, for example when using replication, a temporary table could vanish if the … choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… may 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: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at 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…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…Replication Manager (PRM) with RHEL/CentOS prior… update, see bellow how to perform this action [root@percona1 percona]# yum …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse… does NOT set an lower bound on performance, only a upper bound. The best performance you can expect is modifying a given…
