… new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team, will talk about MHA for MySQL High Availability… pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5… and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to… questions, let’s create a simple replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First… regular replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change…
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… the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal…; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, …was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other … –include=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to …
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…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what… work fine with 5.6 if you’re not using GTID-based replication. If you are using GTID-based replication, it looks like…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution…-known MySQL HA tools and technologies available today (largely 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: 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… the small but handy improvements – changes and bug corrections – in MySQL 5.6 that can make our lives easier and have passed… try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each, so…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
Yes, because MySQL 5.6 GTID is fundamentally broken in the design. You don’… replication cluster of MySQL 5.6 and MariaDB 10 using GTID. You will be kept plenty busy trying to get even a pure MySQL 5.6 gtid replication…
